A friend sent me this, I thought people here might get a laugh out of it.

http://social.answers.microsoft.com/Forums/en-US/vistahardware/thread/720108ee-0a9c-4090-b62d-bbd5cb1a7605

Do not delete the log file. The transaction log is not an optional piece of the database, it's not an error log. It's critical in ensuring database integrity and there's...

isabel (7/15/2009)

---

I am doing a backup of our database using the following command:

BACKUP DATABASE [Northwind] TO DISK = '\\externaldevice\databasename.bak',

DISK='\\serverB\databasename.bak'

WITH INIT , NOUNLOAD , NAME = N'northwind backup',...

A SQL instance needs exclusive access to its data files, hence only one SQL instance at a time can be using a particular data file.

No. That would be the data integrity task.

Look at the difference in reads as...

It doesn't timeout. If you start a transaction and...

I haven't ever been there. It is on my list of planned holiday destinations. Sometime.....

It's 10pm. What self-respecting IT person is not still working at this .... oh wait,...

Jan Van der Eecken (7/14/2009)

---

Gail, Lutz and Grant, I admire you for the amount of patience you seem to have with that guy. Maybe you should all be sainted as...

Interesting. I tested with profiler and the durations were much the same as I saw with stats time. The insert into with the cluster existing was faster by a factor...

And schedule regular backups of the system databases. Weekly's probably enough, unless you make lots of changes to the system databases.

I'm not too familiar with mirroring, but I'd be surprised if you could back the log up on the mirror. If you can, it shouldn't affect anything. It's the principal...

http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/

http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/Auto-shrink-e28093-turn-it-OFF!.aspx

http://www.straightpathsql.com/blog/2009/1/6/dont-touch-that-shrink-button.html

http://www.straightpathsql.com/blog/2009/6/18/a-picture-that-says-dont-shrink-and-other-things.html

Please query sys.databases and see what the value of log_reuse_wait_descr is for that database. Also run DBCC SQLPERF(LogSpace) and post the results here.