As a matter of fact we are testing this now. Here is some info that may
be helpful...
The NetWorker User for SQL Server program enables you to specify one of
four different methods for restoring data. These methods are called
restore types and include:
* Normal - Restores the entire set of data associated with one or
more SQL Server 7.0 or later backups, including full, incremental, and
differential backups. The normal restore type supports recovery of a
database, a filegroup, or a file to the database originally backed up.
* Copy - Creates a copy of a database by restoring a SQL Server
7.0 or later database backup to a new location or to a new database
name. The copy restore type makes it easy to replicate a database that
was previously backed up.
* Verify-Only - Verifies the backup media for the selected SQL
Server 7.0 or later backups.
Note: Selecting the verify-only restore type does not restore the SQL
Server data. In addition, when verify-only is specified, item-level
properties for database, filegroup, and file objects are not available.
* Partial - Restores a portion of the filegroups associated with a
single SQL Server 2000 database backup (Microsoft SQL Server 2000 only).
When a partial database restore is performed, the primary filegroup and
associated files are always restored, in addition to the files specified
for restore.
Note: Only a single item can be marked for this operation. In addition,
a copy of a system database can be marked, but it cannot be overwritten.
Kathleen Scalise
-----Original Message-----
From: Legato NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
On Behalf Of Srinivas Rao
Sent: Wednesday, February 01, 2006 3:37 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] Checking Data Integrity...
Dear Networkers,
As part of our restoration policy, I need to check the data integrity by
restoring previously backedup data from tape to a sample restoration
server every month. Could anyone let me know how to restore SQL database
in a directed recovery method to sample restoration server? Please note
that SQL database to be restored is always accessed by users and I
cannot ask my users to logoff to perform this activity. Which method is
suitable for me to restore SQL database to another server(sample
restoration server) without affecting users connected to SQL server and
the original database? We are using Networker Module for SQL3.11. Any
help would be greatly appreciated.
Thanks in Advance,
Srinivas Rao S,
Networker Server Administrator,
Philips Software Centre,
Bangalore, INDIA.
Ph: +91 80 25579000 Extn: 1133
Cell: +91 99457 23423
To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems wit this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or via RSS at
http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
--------------------------------------------------------
If you are not an intended recipient of this e-mail, please notify the sender,
delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------
To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu
if you have any problems
wit this list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|
