Thursday, February 16, 2012

2005 Installation location

The initial installation of 2005 was to the C drive of the server. I want to
uninstall and reinstalling on the D drive. What is the best way of doing this
and still retain all the information already setup in the database? Example,
user security and scheduled jobs?
Thanks,
Emma
Hi Emma
You can backup the databases and restore them onto the new instance see:
http://msdn2.microsoft.com/en-us/library/ms190679.aspx
http://msdn2.microsoft.com/en-us/library/ms190749.aspx
http://msdn2.microsoft.com/en-us/library/ms190255.aspx
If you are not changing the location of the user database files, restoring
master should recover them. If you then want to move them elsewhere they can
be detached/attached in the new location.
Make sure that you have the same build for the new version as the old one.
You may also want to check for orphaned users in each database
http://support.microsoft.com/kb/274188
John
"Emma" wrote:

> The initial installation of 2005 was to the C drive of the server. I want to
> uninstall and reinstalling on the D drive. What is the best way of doing this
> and still retain all the information already setup in the database? Example,
> user security and scheduled jobs?
> Thanks,
> Emma
>

No comments:

Post a Comment