Restore database with stored procedure
-
I am doing an assignment on Backup + Restore database with Stored Procedures. Backup is ok, but Restore the error: "RESTORE cannot process database 'db_test' because it is in use by this session. It is recommended that the master database be used when performing this operation.". I tried to fix but the document has not been, hope admin help with this problem. Thanks! Link source: http://www.mediafire.com/?c1uldq2t7eczw3b I use C # VS2010 + sql server 2005.
-
I am doing an assignment on Backup + Restore database with Stored Procedures. Backup is ok, but Restore the error: "RESTORE cannot process database 'db_test' because it is in use by this session. It is recommended that the master database be used when performing this operation.". I tried to fix but the document has not been, hope admin help with this problem. Thanks! Link source: http://www.mediafire.com/?c1uldq2t7eczw3b I use C # VS2010 + sql server 2005.
-
You are restoring a database that you are also probably using at the same time. Try making sure you run a restore in the master database.
I used sql queries Restore is done, but 'Stored Procedures' are not. So I asked to use the 'Stored Procedures' can not do this. And if so please help me modifying my demo about Restore using 'Stored Procedures' . Thank you very much. Link: http://www.mediafire.com/?c1uldq2t7eczw3b