ADSM-L

SQL Server Disaster Recovery question

2001-06-27 07:42:09
Subject: SQL Server Disaster Recovery question
From: Ruddy STOUDER <Ruddy.Stouder AT IRISLINK DOT COM>
Date: Wed, 27 Jun 2001 13:38:19 +0200
Hello,

I made a full NT Server Disaster Recovery. According to the
documentation, after the recovery:

I made a rebuild of the SQL tables
I restarted the SQL Server in single user mode
With TDP for SQL 1.1.1, I restored the master.dat file
I tried to restart the SQL server and it fails ...

The same table beeing used for master.dat and model.dat, I tried :

I made a rebuild of the SQL tables
I restarted the SQL Server in single user mode
With TDP for SQL 1.1.1, I restored the master.dat and model.dat files
I tried to restart the SQL server and it fails with the following
error messages ...

...
01/06/14 13:47:58.48 spid1    Activating disk 'AMX_Data'
01/06/14 13:47:58.51 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device G:\MsSql\SQLserver Data Devices\AMX_Data.DAT
01/06/14 13:47:58.57 kernel   udactivate (primary): failed to open
device G:\MsSql\SQLserver Data Devices\AMX_Data.DAT for vdn 10
01/06/14 13:47:58.62 spid1    Activating disk 'AMX_Log'
01/06/14 13:47:58.64 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device E:\MsSql\SQLserver Log Devices\AMX_Log.DAT
01/06/14 13:47:58.71 kernel   udactivate (primary): failed to open
device E:\MsSql\SQLserver Log Devices\AMX_Log.DAT for vdn 11
01/06/14 13:47:58.74 spid1    Activating disk 'Dev_Device_Data'
01/06/14 13:47:58.78 kernel   udopen: operating system error 2(The
system cannot find the file specified.) during the creation/opening of
physical device G:\MsSql\SQLserver Data Devices\Dev_Device_Data.DAT
...

Many thanks in advance for your help ...


                        Ruddy Stouder
                        Senior System Engineer
                        TSM Certified Consultant
                        I.R.I.S.
                        Rue du Bosquet 10 - Parc Scientifique de
Louvain-La-Neuve
                        B-1348 Mont-Saint-Guibert
                        ruddy.stouder AT irislink DOT com
                        <http://www.irislink.com>
                        Tel: +32 (0)10 48 75 10  -  Fax: +32 (0)10 48 75
40


<Prev in Thread] Current Thread [Next in Thread>