Thanks for the reply. During the issue i ran 3 tlog backps. The log still continued to grow. So it was acting as if a transaction was keeping the logical...

Marcin Gol [SQL Server MVP] (10/10/2009)

---

i think that you dont know how to properly manage log files. you should read this one:

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx%5B/quote%5D

Please do not assume that i am...

I live in a world where if a table is deleted or any data for that matter, that it is my butt not the one that did it. Until the...

Also i wonder what this vague phrase means... "for a reasonable amount of time" under the How do I downgrade to SQL Server 2005? from the link Steve provided....

Thanks,

I think i was getting stuck on the thought of physically installing sql 2008 and then downgrading it some how to sql 2005. I understand now that it is really...

The issue has not come back. I have no further info.

The primary and secondary data files are moved as well, to the same location. If you need them to...

K. Brian Kelley (8/26/2009)

---

You may want to add a warning that your script is going to turn on xp_cmdshell in order to perform the move. This may balk someone's configuration,...

I have not tested it like that.

Private Gripweed (8/26/2009)

---

The script works well with one exception. If your logical name for the database files contains spaces, it will cause issues.

If you alter the stored procedure and...

Johan van Tonder (8/26/2009)

---

Very good method.

I'm just not sure if I would want to be any one of the users connected to the DB while the script is run, since...

Sir Slicendice (8/24/2009)

---

Steve makes a really good point about these internet services potentially going out of business and taking your data with them; it's one of the reasons I have...

jeff (8/21/2009)

---

5+ years ago I setup RAID on my home office Win 2003 server. I thought RAID would be a good safeguard - basically I thought it would be...

I use the D-Link DNS-321 NAS. It has 2 drive bays. I have 2 500GB drives at raid1. Easy to setup and use.

Certainly number 11 is wrong in most cases. The others i will leave up to the group, but a function on the left side of an = sign in a...