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