Thank you Gail -- I should have been more clear -- I did Transaction Log backups, and immediately ran SELECT log_reuse_wait_desc, * FROM sys.databases afterwards.

But the status of log_reuse_wait_desc does...

SQLkiwi -- now THAT actually makes it clear... thank you very much!

Got it! That makes sense.

Thanx!

The book I found with the best explanation of SQL Security is:

WROX - Beginning SQL Server 2005 Administration

Chapter 6 - SQL Server 2005 Security

Page 175

Does anyone know of any excellent...

Thank you, that's extremely helpful!

Can you recommend a good, comprehensive book on SSIS?

Wow! Your installation instructions are excellent.

Thank you!

mohammed moinudheen (3/17/2011)

---

You may refer below link.

http://support.microsoft.com/kb/174799%5B/quote%5D

Thank you for the link, but that article only addresses installing a Service Pack for Windows itself, not for SQL.

Criag - you definitely win the prize for the fastest response to a ridiculously long question!

And thank you for the detailed responses -- I know, the answer is always, "it...

Data sets with addresses, etc:

http://aws.amazon.com/publicdatasets/

http://www.manifold.net/updates/product_downloads.shtml

http://www.gsd.harvard.edu/gis/manual/realestate/index.htm

http://www.ibm.com/developerworks/xml/library/x-geomap2/index.html

http://www.gearthblog.com/blog/archives/2006/06/huge_database_u.html

Free data set generator, including names, addresses, phone numbers, emails, etc. Not real-world data, but...

These errors are not checked for by default on a database upgraded from SQL 2000 or lower. CheckDB must run successfully once, with the DATA_PURITY option before

[[cr]]

CheckDB will not fix...

SKYBVI (10/11/2010)

---

(1) ... then truncate the log file by performing a full backup ...

(2) By temporally changing from the Full recovery model to the Simple recovery mode, and...

Thank you Gail, I especially love the part where you say, "All too often I hear of maintenance plans that first rebuild all the indexes, then shrink the data files....

I have a Maintenance Plan that does the FULL backup, and I have...

It seems like, finally, something has dawned on me:

All user-defined server side traces are DELETED every time SQL Server is restarted (or even if you just restart the SQL Server...

Another question, if I may: if you look at that code I posted above, there is a simple command to list all the traces running on a server: ...