Personally i don't think you can blame technology for the current global financial crisis, I'm sure the data analysis undertaken by banks throughout the world identified, to a certain degree,...

You could script out the jobs on your prod server and run that script to create them on the test box.

What you can is setup your trace using the Profiler GUI, you can then script out the T-SQL needed to run the profiler and use it in a sql server...

Just a quick question, Do you know whatis causing your db to be put into single user mode? I would guess a job or something is putting the db into...

They do have tools for that... so this maybe a possibility if you want to do row or tables restores, but you still need a full backup and the transaction...

You can install SQL server 2005 on the same machine as a SQL server 2000 BUT i believe you may have to use a named instance... for the SQL...

proably restored from a backup.

I offer remote support for both of my clients. I spend some days on site other at my office it works fine for us.

Unfortunately not. Native sql backup does not support row or tables restores. You can only restore a database to a point in time.

So you have 1 raid 5 array with two logical partions c:\ and D:

Does this server have any other disk arrays...I assume not from your post but wanted to check.

I...

A database can only have one primary data file but it can have several secondary datafiles. if you look in BOL for Physical Database Files and Filegroups it should give...

One option you have is to restore a copy the database under a different name up the point just before you made the deletion. you can then copy the deleted...

I too have used both IDEARA and Spolight both are very useful but you still need to know what you're looking for....

From what you have said, an inital guess would...

In reality being a contractor and running my own company with several clients its hard not keep yourself "wired" some of the time while away. basically the health of your...

http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx

This link supports my thoery