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 |
|
slaurie
Starting Member
2 Posts |
 Posted - 2008-08-12 : 16:49:43
|
| I have a sql 7.0 server the default Dir: g:\MSSQL7\DataI have installed MSSQL 2000 with the custom option and it will not Create g:\MSSQL7 Dir it keep putting MSSQL\MSSQL7\DATA. I need to move master so I have all my user info. I then did an install using the default location. Then created g:\MSSQL7\data moved my production master and followed the how to move master, model, tempdb, and msdb. all works fine. However, I tried to backup and restore Master again and I get cannot restore to new location SQLState: 42000 error. My backup software is Brightstor 12.0 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-12 : 22:25:15
|
| Change master db file path in sql startup parameter, stop sql, copy those files to new location then restart sql. |
 |
|
|
|
|
|
Move master to new server