changing master database location in sql server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

changing master database location in sql server

Author

Topic

forager
Starting Member

2 Posts

Posted - 2007-07-10 : 01:42:37

changing master database location in sql server 2000

HELLO PLEASE HELP ME I AM TRYING TO CHANGE THE LOCATION OF MASTER DATABASE ( MDF AND LDF ) AND ERRORLOG FILES I HAVE TRIED EDITING STARTUP PARAMETERS IN ENTERPRISE MANAGER I FAILED ,I TRIED IN COMMAND
PROMPT "SQLSERVR.EXE " I SUCCEEDED IN CHANGING THE DATA FILE AND ERROR LOG BUT UNABLE TO CHANGE THE LOG FILE PATH FROM DEFAULT LOCATION C:\PROGRAM ............
TO D:\DATA
PLEASE GIVE ME THE PROCESS TO CHANGE DATA ,LOG AND ERROR LOG FILES of master database
thanq in advance

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2007-07-10 : 01:58:40

Hope this helps.

http://support.microsoft.com/kb/224071

Don't sit back because of failure. It will come back to check if you still available. -- Binu

forager
Starting Member

2 Posts

Posted - 2007-07-10 : 05:10:01

thanq it was very much helpful

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources