|
|
Posted by Erland Sommarskog on 08/08/06 22:06
Marc C (mchang@allosource.org) writes:
> 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.
Good! You've just done that and found that it does not work!
OK, assuming that you had stopped SQL Server prior you started copying,
the operation as you described it, should work I think. But if there is
a file you missed a long the way there may be trouble.
But for restoring from backup... You can't really just back up the disk
drive as such, you need to use SQL Servers own BACKUP command, so that
backups are consistent. (Well, if you stop SQL Server before you start
the backup, you might get away with it, but normally you don't want to
do that.)
> 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)
I don't think there is any. Rather I would look at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters
as the prime suspect.
Exactly where do you get this error?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|