We are trying to emulate a disk crash for one of our SQL servers but we are running into some difficulty. The working server is clustered but the server to restore to isn't. The databases (master, model, and msdb) are stored on e: on the working server bu
t are being restore to d: on the test server. The first database to restore be restored is master but after doing this the server will not restart with the error message "Unable to locate e:". What is the recommended procedure for doing this?
Thanks in advance,
-Dave
Hi
You MUST use SAME DISK CONFIGURATION, if you plan restore the master database!
The master database store file information for all databases, see sysdevices or sysdatabases table.
Andras Jakus MCDBA
"Dave" wrote:
> We are trying to emulate a disk crash for one of our SQL servers but we are running into some difficulty. The working server is clustered but the server to restore to isn't. The databases (master, model, and msdb) are stored on e: on the working server
but are being restore to d: on the test server. The first database to restore be restored is master but after doing this the server will not restart with the error message "Unable to locate e:". What is the recommended procedure for doing this?
> Thanks in advance,
> -Dave
|||If it's just a test environment, you could try subst e: d:\
Not 100% sure is SQL Server will recognize this when doing the restore, but
it would be worth a shot.
HTH,
Morgan
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:0212D0EE-852A-444B-8E73-5BF8446C3C21@.microsoft.com...
> We are trying to emulate a disk crash for one of our SQL servers but we
are running into some difficulty. The working server is clustered but the
server to restore to isn't. The databases (master, model, and msdb) are
stored on e: on the working server but are being restore to d: on the test
server. The first database to restore be restored is master but after doing
this the server will not restart with the error message "Unable to locate
e:". What is the recommended procedure for doing this?
> Thanks in advance,
> -Dave
没有评论:
发表评论