MSSQLServer won't start (after master move)

Question

Post reply

MSSQLServer won't start (after master move)

bryan99y

SSCarpal Tunnel

Points: 4672
More actions
November 11, 2002 at 11:01 am

#174731

Moving the Master Database:
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.
Right-click the SQL Server in Enterprise Manager and click Properties.
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.
Change these values as follows:
Remove the current entries for the Master.mdf and Mastlog.ldf files.
Add new entries specifying the new location:
-dE:\SQLDATA\master.mdf
-lE:\SQLDATA\mastlog.ldf
Stop SQL Server.
Copy the Master.mdf and Mastlog.ldf files to the new location (E:\Sqldata).
Restart SQL Server.
---------
Did above, now MSSQLServer service won't start.
Any ideas?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Mkumari Hall of Fame Points: 3498 More actions · Answer 1

There is an article by Steve,I think it will explan what you are looking for.

http://www.sqlservercentral.com/columnists/sjones/moveyourmaster.asp

bryan99y SSCarpal Tunnel Points: 4672 More actions · Answer 2

figured it out.

I had to edit the registry and change the startup values.

(-d, -l, -e)

bryan99y SSCarpal Tunnel Points: 4672 More actions · Answer 3

are there any other major entries in the registry that SQL Server has for databases or database configurations?

Antares686 SSC Guru Points: 125444 More actions · Answer 4

Not to my knowledge, other than the ones configruable for Server Properties most all items related to databases are in the sys.... tables of each db or in the master db.

bryan99y SSCarpal Tunnel Points: 4672 More actions · Answer 5

I put a call into Microsoft for this because it applies to how/when we do our Ghost Images.

Microsoft said that only Installation, Master DB, Service Packs and Full Text catalogs have registry entries.

Everything else is in Master/System/User DB's.

dba-134197 Grasshopper Points: 19 More actions · Answer 6

Could you please go to details, I think I have tried the same but it doesn't work?

Thanks,

Hobo Long Right there with Babe Points: 733 More actions · Answer 7

The reg entries can be changed at:

Local Machine\Software\Microsoft\MSSQLServer\MSSQLServer\Parameters