The only sure-fire way I can recommend is to Evaluate a program called Log Explorer from Lumigent. If the data(all your data) is fairly critical, as well as the immediate...

I've had similar days

I use a cool monitoring tool called Spotlight that sends me an SMS message if there is any type of...

I'm working with this issue currently myself and ended up needing a Instead of trigger to populate a column that used to be a derived column. I hade to make...

If you have the keys correctly configured, then SQL Server is no more capable of deleting the rows than your application is.

If you have T-Log backups configured, you can do...

It priecy, but ER/Studio is my favorite modelling and in general documentation tool. Not sure about compatibility. Cost is about 4K.

The fact that you are using a SAN makes me think that you are using Clustering Services.

If that is the case, then you must make the device a cluster resource...

Two comments:

You can't truncate a table with active Foreign Keys.

When I am faced with a larger task such as this in a Production environment, I will typically:

1. Write a query...

One other thing to consider: Depending on your backup strategy, You could do a full restore and apply all applicable T-logs (to specific point in time) to a new database...

Absolutely! I keep one months worth myself, running dbcc errorlog everynight at midnight. Not alot of problems here so I don't track anything longer than that....

July 3, 2003 at 10:37 am

#464110