Showing posts with label referenced. Show all posts
Showing posts with label referenced. Show all posts

Monday, February 20, 2012

Moving instance of Sql server to different location

Is it possible to move an instance sql server from one drive to another, i.e
.
C: to D: without changing connection properties referenced in DTS packages,
etc.?
T.I.A.This should help:
http://support.microsoft.com/kb/224071
-oj
"LNN" <LNN@.discussions.microsoft.com> wrote in message
news:BE7ADDBD-6113-4BB2-9695-DEB61FC00A91@.microsoft.com...
> Is it possible to move an instance sql server from one drive to another,
> i.e.
> C: to D: without changing connection properties referenced in DTS
> packages,
> etc.?
> T.I.A.|||Hi
If you are moving a database then the connection properties will not change
if you following the instructions in the link posted by oj. If you are
rebuilding a new server and want to rename that server (to be the original
server's name) then you will also need
http://msdn.microsoft.com/library/d...nstall_5r8f.asp
John
"LNN" wrote:

> Is it possible to move an instance sql server from one drive to another, i
.e.
> C: to D: without changing connection properties referenced in DTS packages
,
> etc.?
> T.I.A.