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 - 2003-09-04 : 08:11:45
|
| sreekanth writes "Hi,I am restoring the master database from the production backup to test system. here is th problem i am havingin prodcution system all the datafiles for all the databases are sitting in drive E. But in test we do not have drive E, we have only drive c. So when i restore the master then try to start the server, it is not starting up. becasue it is trying to locate the files in drive E for other databases. i think the master database has the phisical location of the files for other databases. So how do i restore the master from production to test in this situation?thank in advance.sreekanth.g" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-09-04 : 08:58:07
|
| This doesn't sound like a good idea. Why would you want to restore your production master db to your test system? |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-04 : 11:10:31
|
| Why? is it corrupted?You can rebuild it with rebuildm.exeNever had to do that though...pick up a copy of ADMIN 911 by brian knight...Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-04 : 12:35:33
|
| Why would you want to restore the master database? Just copy over the database backups from your production system and place them onto your test system. Then do a restore. You will have to provide the new file location by specifying the WITH MOVE option in the RESTORE command.Tara |
|
|
|
|
|
|
restoring master