Sql Database Restore

[bionicman]

Hi,

Im having trouble restoring a SQL Database, I keep getting an error message stating "Database Query Error". This is trying to restore a database over a current one which has no locks.

 

[steveot]

Take a look at the SQL server Application log
Can you run a test backup before you restore?

 

[SQLBill]

You can't just restore over another database (even if it's the same name). You need to restore it with the REPLACE command. Since I don't use the Backup Exec SQL Agent, I don't know if the REPLACE option is available.

-SQLBill

Posting advice: FAQ481-4875

 

[steveot]

IN the SQL agent restore properties - pick the option to overwrite - this will issue the replace command behind the scenes.