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.
| Author |
Topic |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2006-03-05 : 05:17:41
|
| hiI backed up database it is ok. but when i try to restore database it is not working.it gives error like exclusive access could not be obtained because database is in use.I restarted my computer then i tried. but no changes at all in error.same error facing.Waiting for reply. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-05 : 05:24:20
|
| How do you restore the database ? via the Enterpise Manager or Query Analyser ?Make sure there isn't any application / Query Analyser open that is connecting to the database.If you are using Query Analyser, make sure you are not in the database you are trying to restore. Change database to master and try again----------------------------------'KH' |
 |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2006-03-06 : 22:00:13
|
| Hi,or set database in maintanance mode using alter database command and then restore .Andy DavisSql Shield Team--------------------------------------------SQL Server Encryption Softwarehttp://www.sql-shield.com |
|
|
|
|
|
|
problem in restoring database