Moving SQL installation to a new Partition

Giganews Newsgroups
Subject: Moving SQL installation to a new Partition
Posted by:  Marc C (mcha…@allosource.org)
Date: 7 Aug 2006

Hello,
I have a SQL 2000 installation on a small partion that I would like to
move to a second larger partion on the same disk array array with the
config as follows:
d: full installation of prod and test instances with data and log files
100 GB
e: empty partion with 204 GB which I want to move the "whole thing"

I did an Xcopy of all files,permissions and attributes, checked for
errors, then I changed drive
letters and restarted. Only one instance came up (the other threw an
error of: MSSQL,,the system cannot find the file specified.

I realize that I could detatch the DB's and move them leaving the base
install on  the old partition however I would like to simulate the loss
of  the disk array and the restore to said  array from a backup.
(ultimately I want to delete the 2 partitions and restore from tape to
a single 300GB  d: partition)

I am trying to  buy time and avoid a re-install of SQL untill I can get
a whole new platform.
I can work it out on my own if someone can point me in the right
direction. I suspect a registry entry to a disk id (partition)

Replies