Ruddy,

The piece that I didn't see you mention was
restoring the "msdb" database. That is necessary.
See Appendix B of the TDP for SQL V1 User's Guide.

Also, take a look at the new TDP for SQL Redbook
for more details on using TDP for SQL for disaster recovery.
The redbook examples show the restore using TDP for SQL 2.2
but, you can at least follow the general process used.
You can find it at:

   www.redbooks.ibm.com

Or... here is a direct link:

   http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246148.pdf

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

"It's a beautiful day.  Don't let it get away."  -- Bono




                    Ruddy STOUDER
                    <Ruddy.Stouder@IRI       To:     ADSM-L AT VM.MARIST DOT EDU
                    SLINK.COM>               cc:
                    Sent by: "ADSM:          Subject:     SQL Server Disaster 
Recovery question
                    Dist Stor Manager"
                    <[email protected].
                    EDU>


                    06/27/2001 07:38
                    AM
                    Please respond to
                    "ADSM: Dist Stor
                    Manager"





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