Re: SQL Server BAckup
From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 09/25/02
- Next message: Shane: "Permissions required to view SQL counters in System Monitor"
- Previous message: PNG: "SQL Server BAckup"
- In reply to: PNG: "SQL Server BAckup"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Andrew J. Kelly" <akelly@targitinteractive.com> Date: Wed, 25 Sep 2002 10:17:09 -0400
The only 100% way is to restore it to another DB and actually check it. If
you use the VERIFY option when you do the backup you can at least be sure
the data on tape matched the data in the DB at the time of the backup.
-- Andrew J. Kelly SQL MVP Targitinteractive, Inc. Check out the PASS Community Summit - Seattle, the largest and only user event entirely dedicated to SQL Server, November 19-22. http://www.sqlpass.org/events/seattle/index.cfm "PNG" <pnagar@hotmail.com> wrote in message news:76b101c26498$60cc8d20$2ae2c90a@phx.gbl... > Hi > Please let me know how to verify a SQL Server Backup. I > mean I need to find out whether the data contained in the > backup is correct or not > > > Thanks
- Next message: Shane: "Permissions required to view SQL counters in System Monitor"
- Previous message: PNG: "SQL Server BAckup"
- In reply to: PNG: "SQL Server BAckup"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
