Hi,
I have 2 servers SQL7SP3 on W4SerSP6a. On my first server all the system db (master, model, etc) are on the unit C:.
I want restore master on the unit D: on the second server. The restore with the -m option successful, but the restart of sqlserver failed because it can't find master, model etc in C:\mssql7\data.
How can I do to force SQL to start on the D:\mssaql7\data ?
thxQ1 How can I do to force SQL to start on the D:\mssaql7\data ?
A1 For a temp fix, use service startup parameters (in Sql 2k, and probably also 7 this would be -lD:\mssaql7\data\Mastlog.ldf -dlD:\mssaql7\data\Master.mdf)
A2 You may edit the paths in your server's registry for a permanent fix.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment