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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-20 : 08:09:16
|
| edwin writes "i have restore master database from backup taken on different server and sql server stopwhen i start it in a single user mode it show this errorStarting up database 'TRAActivePlannerPub'.2005-10-18 18:38:07.11 spid9 FCB::Open failed: Could not open device e:\Program Files\Microsoft SQL Server\MSSQL\data\TRAActivePlannerPub_Data.MDF for virtual device number (VDN) 1.2005-10-18 18:38:07.12 spid9 Device activation error. The physical file name 'e:\Program Files\Microsoft SQL Server\MSSQL\data\TRAActivePlannerPub_Data.MDF' may be incorrect.it seem that master tries to start user database from the old drive which is not availabe on the new server and hence failcan you please help me to solve this" |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-10-20 : 09:16:09
|
| You can try to start the MSSQL Service with the -f flag, and then go in and drop the offending database(s). Restoring master from server to server is not recommended, and you are unfortunately finding out why. |
 |
|
|
chen149
Starting Member
19 Posts |
Posted - 2005-10-20 : 10:31:29
|
| If the both server has same path to store the data, the restoring master should be ok. In your case, you didn't have 'e:\Program Files\Microsoft SQL Server\MSSQL\data\TRAActivePlannerPub_Data.MD' path.Jun |
|
|
|
|
|
|
restore master database