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
 Transact-SQL (2005)
 restore

Author  Topic 

bilencekic
Posting Yak Master

121 Posts

Posted - 2007-01-24 : 08:31:01
hi
when i try to restore the database
it give error "database in use"
of course it is in use it must be onilne 24 hours
how can i restore the database ???

MS BLESS US

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-24 : 08:46:22
ask all users to quit ?


KH

Go to Top of Page

bilencekic
Posting Yak Master

121 Posts

Posted - 2007-01-24 : 08:49:00
i am the only user
or
how can i kick all other users ? (but a forum uses my database)
how to restore the db

MS BLESS US
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-01-24 : 13:29:31
See

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

for syntax included forcing the database to Single User as part of the Restore operation.

Kristen
Go to Top of Page
   

- Advertisement -