Hello all,



I have a question about moving the Master database from one
server to another where the disk structure is different. (i.e. I'm
moving from d:\mssql\data\ to e:\mssql\data)



Basically, I created a SQL Server on a new server, updated
it to the same version (8.00.818) . . . but I can't start up the server
after restoring the master DB from the old server.



Now, I know to stop the server, go to cmd line and run
sqlservr -c -m from the binn directory . . . then in query analyzer, I
run the restore with move command . . . which works . . . But when I
try to start it back up, nothing . . . I gather that the main reason is
because the master DB holds the database location information and that
has changed (which is not fixed by the 'with move' command). . .



How can I fix the following script to restore it? Or is
there something else I need to do that I'm not doing?



RESTORE DATABASE master


FROM DISK = 'c:\SQLBKP\Masterbkp.bak'


WITH MOVE 'master' TO 'e:\MSSQL\data\master.mdf',

MOVE 'mastlog' TO 'e:\MSSQL\data\mastlog.ldf',


REPLACE,

STATS = 10





Thanks! (grin)



Steve






MS Sql Server LazyDBA home page