Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Join Date
    May 2004
    Posts
    44

    Unanswered: How to re-directory of Master and model dbs

    Hi All,

    Anyone know how to change the directory of system dbs --- master and model dbs? Thanks.

  2. #2
    Join Date
    May 2004
    Posts
    44
    I mean changing the directory of system db data files.

  3. #3
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    May 2004
    Posts
    44
    Hi Guys,

    I tried to use the infor you guys providing for me to moved the msdb, was ok. but as moving Master db, I changed the startup Parameters using new location, then tried to restart the SQL server which was failed, got error message:"Could not start the MSSqlserver service on local computer. Error 1067: The process terminated unexpectedly".

    Any suggestiongs????


    Thanks.

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Did you move MDF and LDF files to the location that you specified in startup parameters?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  7. #7
    Join Date
    May 2004
    Posts
    44
    Yes, I moved both of them.

  8. #8
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Did you move anything else like MODEL?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  9. #9
    Join Date
    May 2004
    Posts
    44
    No, I didn't move Model only Master.

  10. #10
    Join Date
    May 2004
    Posts
    44
    This is the steps I did:

    Moving the master database
    1. Change the path for the master data and log files in SQL Server Enterprise Manager.

    Note You may optionally change the location of the error log here as well.
    2. Right-click the SQL Server in Enterprise Manager and click Properties.
    3. Click the Startup Parameters button and you will see the following entries: -dD:\MSSQL7\data\master.mdf
    -eD:\MSSQL7\log\ErrorLog
    -lD:\MSSQL7\data\mastlog.ldf

    -d is the fully qualified path for the master database data file.

    -e is the fully qualified path for the error log file.

    -l is the fully qualified path for the master database log file.
    4. Change these values as follows: a. Remove the current entries for the Master.mdf and Mastlog.ldf files.
    b. Add new entries specifying the new location: -dE:\SQLDATA\master.mdf
    -lE:\SQLDATA\mastlog.ldf



    5. Stop SQL Server.
    6. Copy the Master.mdf and Mastlog.ldf files to the new location (E:\Sqldata).
    7. Restart SQL Server.

    Now last step was failed. Failed to restart SQL server. The error is " An error 1058 -- ( The service connot be started, either because it is disabled or because it has no enabled devices asociated with it ) occurred while performing this service operation on the MSSQL server service.

    Any solutions Please? Thanks.

  11. #11
    Join Date
    May 2004
    Posts
    44
    Hi,

    I checked the service porperty---Log on button---- Hardware Profile, disabled it and enabled it , then start the service again, the previous error message just gone , but other error coming out"Could not start the MSSqlserver service on local computer. Error 1067: The process terminated unexpectedly". I checked all possibility, but still no any clues.

    Help !!!! Please!!!

  12. #12
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Try checking the sql server logs, event viewer to have an indication of what is going wrong ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  13. #13
    Join Date
    May 2004
    Posts
    44
    I checked both of them yesterday: event view was empty, and sql server error log is :

    2004-10-13 14:15:30.53 spid51 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..

    2004-10-13 14:15:30.64 spid51 Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_msver'.

    2004-10-13 14:26:20.26 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager."

    I tried to put the original startup parameters back at MSSQL service property window on log on button--- startup parameter.

    it's still failed and nothing recorded at event view and error log too.

  14. #14
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100
    I think you have a typo in the "Startup Parameters"

    I Might be able to help you fix it, but need more info.

    What is the exact paths to the following files?

    master.mdf
    ERRORLOG
    mastlog.ldf

    What OS are you running?

    I am assuming SQL 2000 SP3, correct?

    Tim S

  15. #15
    Join Date
    May 2004
    Posts
    44
    Thanks a lot Tim.

    My OS is window 2000, and Sql server is sp3. The Mater original path is :

    -dD:\Database Files\MSSQL\Data\master.mdf
    -eD:\Database Files\MSSQL\Data\Log\ERRORLog
    -lD:\Database Files\MSSQL\Data\mastlog.ldf

    The new path I changed is:

    -dD:\Database Files\Master\master.mdf
    -eD:\Database Files\MSSQL\Data\Log\ERRORLog (this one was not changed)
    -lD:\Log Files\Master\mastlog.ldf


    Thanks.

Posting Permissions

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