Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
 Posted - 2011-09-06 : 06:21:19
|
| Team,We have a Backupset system table in MSDB database, which have the information about the backup run on the server.Is there any way to find out if the backup is Sucess or Not?Please Guide me..Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-09-06 : 09:21:27
|
| You may need to clarify exactly what you mean.If you mean is the .bak file produced buy the backup query a success then you'll only know by doing a restore.This could be done using VERIFY_ONLY or a physical restoration to a test server.There are various tables in MSDB which relate to backups so you could look those up on BOL to help you determine if your query was a success or not.Junior DBA learning the ropes |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-06 : 10:34:27
|
quote:
Originally posted by chris_cs
There are various tables in MSDB which relate to backups so you could look those up on BOL to help you determine if your query was a success or not.
Example query for MSDB Backup history table:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300#273265 |
|
|
|
|
|
|
how to find the backup query runs sucessful or not