
Appendix H - Working with Microsoft SQL Server
301
If the database does not exist, Data Protector Express next identifies the database devices on which
the database was originally located. If the appropriate database
device
already exists, Data Protector
Express will use that device as is without further processing.
If the database
device
does not exist, Data Protector Express
recreates
the database device at its
original
location and with its original size. After all the database devices are created, Data Protector
Express then creates the database with all the original options at the original locations.
TIP:
This method makes disaster recovery simple. The user simply create a restore job and allows
Data Protector Express to recreate whatever is needed in order to successfully restore the database.
Note, however, if a disk drive fails and is not replaced, Data Protector Express will be unable to
restore your database because it will be unable to recreate a database device. For example, if a
segment of your database resides on a database named ‘DATA’ at D:\MSSQL\DATA\DATA.DAT, if
D: is lost and not replaced, when Data Protector Express attempts to recreate the database device, it
will fail, since D: no longer exists.
To avoid this problem, manually recreate the database device at some other location. It must be at
least as large as the original database device since Data Protector Express will attempt to create a
database segment on it the same size as the original database.
An alternative method is to manually create the entire database itself. Thus, when Data Protector
Express attempts to restore the database, since the database already exists, it will use that preexisting
database. This allows you to restore a database in a new location, since Data Protector Express does
not check to see if it is the original device before restoring the database, because the database already
exists.
NOTE:
Data Protector Express tracks databases
by name
. So, if a database already exists with the
same name, Data Protector Express will use that database.
3. Using Data Protector Express, create a restore job and run the job to restore the database. You must
start with a full backup version of the database to restore which was created using a Full backup job.
4. Create additional restore jobs to restore each transaction log backed up after the full database you
restored. You must create and run a separate restore job for each transaction log.
For example, if you ran a full backup on Friday and incremental jobs (that is, jobs that backed up only
the transaction logs) on the following Monday and Tuesday, you must first restore the database using
Friday’s version of the database. Next, create a run and restore job that restores Monday’s version
(Monday’s transaction log). Finally, create and run a job that restores Tuesday’s version (Tuesday’s
transaction log).
In the
last
incremental restore job, click the
Advanced Options
button and select the
Recover
databases
checkbox. If you do not select this checkbox, the database will be offline.
Restoring Microsoft SQL Server 2000 master databases
A damaged master database is evident by the failure of the SQL Server to start, by segmentation faults or
input/output errors or by a report from DBCC. An example of an error might be damage caused by media
failure in the area in which master database is stored.
The procedure used to recover a damaged master database is different from the procedure used to recover
user databases. If the master database becomes unusable, it must be restored from a previous dump. All
changes made to the master database after the last dump are lost when the dump is reloaded and therefore
must be reapplied.
Summary of Contents for BB118BV - StorageWorks Data Protector Express Package
Page 1: ...U s e r s Gu i d ea n dT e c h n i c a l R e f e r e n c e ...
Page 339: ......
Page 345: ......
Page 365: ...Index 347 ...