Hi there! My name is Yoda!
Wed, Nov 16 2005 18:23
Hi there! My name is Yoda. I'm soon to be the server underneath the MSMVPS.com blog site. Right now I'm getting ready along with the database that is migrating over to me.
One thing is for sure.... my owner is soooooo blonde.... and soooooo not a SQL server expert at all. Fortunately she called in some experts and got help.
Here's what he did.
First off he told her that the database was running in “Full mode“. As Nick said “you know that this creates 814Mb of transaction logs“... “Uh..no“.... she said.
Then he looked at the tables in the blog and both the referrers tables and the url tables had 4 million... M I L L I O N entries. Since this blog has had major issues lately we asked the blog community if it was okay to dump those logs... off they went. Man is the blog site peppier with just that.
Then he found out just how blonde my owner was... all this time she's been setting up blogs by hand with the SQL Enterprise manager... I tell ya does she need a SQL course or what? I'll be so glad when we get SQL 2005 on that SBS box she has in the R2 era ... I think the more GUI interface will force her into learning more about the stuff she has and doesn't use like she should be using.
Nick told her that there was no need for a full database, simple model will do for a web server. My owner just has to remember that she can only go to the last good backup [which the ISP does nightly anyway and she can just plan on pulling over a backup.]
We went from a backup file of 3.27 GBs...you read that right... almost 3.5 gigs to a shrunk down file of 323MB.
Pretty sad isn't it? Obviously we need to work on her SQL capabilities... she's got a long way to go.