Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2001
    Posts
    1

    Talking Unanswered: Restore master on an another disk !!!

    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 ???

    thx

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Post

    Q1 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •