Did you "rebuild the master database using the same character
set and sort order as the master database backup being restored"?
After restoring the master database, are you restarting the sql server
in multi-user mode ( Ie. Not in single user mode) ?
What errors are you getting when you restart the server? Any event
log messages?
Thanks,
Bill
William Degli-Angeli
IGS TDP Development
Endicott, NY
(607) 752-6749
TieLine: 852-6749
Internet: [EMAIL PROTECTED]
Ruddy STOUDER
<Ruddy.Stouder@IRI To: [EMAIL PROTECTED]
SLINK.COM> cc:
Sent by: "ADSM: Subject: Re: SQL Server Disaster
Recovery question
Dist Stor Manager"
<[EMAIL PROTECTED]
EDU>
06/27/2001 11:44
Please respond to
"ADSM: Dist Stor
Manager"
Del,
Indeed, the msdb database has to be restored but, according to the
redbook, it has to be done after :
- With TDP for SQL 1.1.1, I restored the master.dat file
- I tried to restart the SQL server and it fails ...
So, after restarting the SQL server, I am supposed to restore the msdb
database but the SQL server does not restart ...
Ruddy
Ruddy Stouder
System Engineer
TSM Certified Consultant
I.R.I.S.
Rue du Bosquet 10 - Parc Scientifique de
Louvain-La-Neuve
B- 1435 Mont-Saint-Guibert
[EMAIL PROTECTED]
http://www.irislink.com
<http://www.irislink.com>
Tel: +32 (0)10 48 75 10 - Fax: +32 (0)10 48 75
40
-----Original Message-----
From: Del Hoobler [mailto:[EMAIL PROTECTED]]
Sent: mercredi 27 juin 2001 14:39
To: [EMAIL PROTECTED]
Subject: Re: SQL Server Disaster Recovery question
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
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
Ruddy STOUDER
<Ruddy.Stouder@IRI To:
[EMAIL PROTECTED]
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
[EMAIL PROTECTED]
<http://www.irislink.com>
Tel: +32 (0)10 48 75 10 - Fax: +32 (0)10 48 75
40
