Hi, I will like to see what the script does. Could you please let me now where to find it. Can you see in the output file if anything was...

If you only need to copy the data once a day. You can use SSIS to create a package that restore the database once a day.

I will check the user that is running the SQLAgent if I was you!

A backup is the way to go!

At work we have a script that generates all the restore T-SQL for all servers and Instances. We used for our DRT's, it is a great script (I didn't write...

I don't know much about SAN snapshots, but I think you need a special license for that!

As I told you earlier the logins will be created on hte master database and you should not get any errors by that. At least that is what I think....

If you are restoring a full backup, it should not be a problem to use with replace on the test server.

What about transaction log backups? Are you doing any? If your answer is yes, my next question will be "How often are you doing the transaction log backups?"

If I'm not mistaken the logins will be created on the master database. I don't understand why you are having problems with creating logins.

Handy scripts!

I don't think you should let them use the SA account. Give them another account with the rights they need. Consultants always want to have sysadmin rigthts and you will...

creating sp_oledb_indexinfo

Warning:

you are installing the stored procedures

on a pre 8.0 SQL Server.

Ignore the following errors.

Msg 2714, Level 16, State 3, Server SERVERNAME, Procedure sp_oledb_indexinfo, Line 59

There is...

I will advice you to Google a little before asking. It will help you a lot better! good luck.

Check this http://www.sqldbatips.com/showarticle.asp?ID=8