Yo, Jim!

Just write you a script to step through sysindexes, pulling the ones that have clustered indexes.  Have the script create your drop statements and your create statements. 

Then write...

If you move the databases to the new server, rather than the complete "image", you will need to move the SQL loginids complete with their passwords and sids, or you...

Its easy if you script it!  We take log backups every 15 minutes.  95 log backups in a single day (skip the time that the full starts).  So, manual restores...

That's what we're doing now.  I have a table in my "DBA" database on each server that has a row for each database.  Controls whether backups are taken of the particular...

For what its worth, I experienced the exact same behavior a few months ago.  And, yes, my hair is still growing back out!  The problem ended up being caused by...

The problem with that solution is that it is a very simple algorithm based on the data itself, and would not pass HIPAA requirements.

A couple of things come to mind...

1....

I don't know of any stored procedure, but the error logs are clear text.  First, you can view them from within Enterprise Manager by expanding the server, then expand management,...

#1 - Not really necessary.  Just make sure there are no users when you start.  The restore itself will keep the users out. (suggest non-operational instead of read only.  read only...

Let me see if I understand what you are saying...

If you delete the EOM backup, your transaction log chain is broken, prohibiting point in time recovery?

If that's what you meant,...

I ran into a problem with a different 3rd party SQL backup agent.  We had been using it to backup a "large" (at that time) database.  In a disaster recovery...

Looks good to me.  The only part I'm not completely understanding is...

"I just have to run a delete

xp_cmdshell 'delete L:\MSSQL\BACKUPS\PRODEOM.BAK' a couple days after so that if I have a...

with a parameter to allow sorting in whatever order you want?????

Steve

Unless you have a transaction log tool installed, such as Lumigent's Log Explorer, and the database is in full recovery model, no.   Hard lesson learned.  Take backups!

Steve

Yes!

I have had numerous situations where a developer/user/... wanted to see data as it existed before some change took place, or how the data existed at some certain point in...

KlK,

Now that my brain is back where it belongs, I was looking at your script.  Its a very interesting approach, and much, much simpler than mine.  I actually parse...