Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Restoring Problem

Author  Topic 

pras2007
Posting Yak Master

216 Posts

Posted - 2009-04-06 : 01:09:26
Hello All,


I executed the below statement:

Use Master

Alter Database Test_DB Set Single_User With Rollback Immediate
GO
Restore Database Test_DB From Disk = 'D:\Test_DB.Bak'
Alter Datbase Test_DB SET Multi_User With Rollback Immediate

I got errors once that statement was ran, now my database is showiing Restoring.... in Management studio, does anyone know how to stop this process and redo? Please advice. Thanks.

   

- Advertisement -