April 18, 2005 at 7:35 pm
Hi all,
I've inherited a SQL instance which has the master and model datafiles and transaction logs in the wrong location. What I want to do is move them, but am unsure how to do it?
Model will be easy enough (detach, move files, reattach), but at a the master loss how to move the files which make up the master DB.
Any advice will be gratefully received. Thanks.
April 18, 2005 at 11:43 pm
Backup master first (precaution).
Stop the sql server.
Regedit to modify master db location.
lOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLSERVER/MSSQLSERVER/PARAMETERS/SQLArg0 ~ SQLArg2
Restart the sql server
April 19, 2005 at 12:56 am
See my article Moving system databases - a checklist, which describes exactly how to do this.
April 20, 2005 at 8:51 am
April 20, 2005 at 11:51 am
Hi,
visit this to move system databases:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
Hope this will help you.
Thanks.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy