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 |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
 Posted - 2011-02-16 : 01:42:09
|
| Hi.I am getting following error while restoring backup file.cannot restore a database other than master when the server is in single user mode.What may be the prob |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-16 : 14:29:03
|
| Why did you start the server in single-user mode? Need to restart without the -m switch. |
 |
|
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2011-02-16 : 23:26:15
|
| I Have Not Started in Single user Mode . But While Restoring back up its giveing that error |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-02-17 : 04:40:02
|
| What does this return ?select DATABASEPROPERTYEX('Your database name','UserAccess')PBUH |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-17 : 11:31:34
|
| Did you recently restore master or msdb?Checked your startup parameters?PBUH, I don't think that'll matter. Error is server, not database, in single user mode. |
|
|
|
|
|
|
Backup Restore