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.
Monday, February 20, 2012
Moving instance of Sql server to different location
Labels:
changing,
connection,
database,
drive,
dts,
instance,
location,
microsoft,
moving,
mysql,
oracle,
properties,
referenced,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment