I want to know whether or not netbackup or tape backup was successful by runnign the script in sql query analyzer.
Take a look at backupfile and backupset tables
in MSDB... A row is created when backup is done...
YOu can also parse the SQL log or NT Application log for backup information
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Brijesh" <Brijesh@.discussions.microsoft.com> wrote in message
news:4A1DD1FD-397B-41B1-BFCF-652B70FFF2B1@.microsoft.com...
> I want to know whether or not netbackup or tape backup was successful by
runnign the script in sql query analyzer.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment