October 20, 2010 at 10:19 pm
Hi Team,
daily we have taking backups our database but
today backups are completed or not how can we know
which command we have to use backup complted or not
i have check is log in sql but no use please guide me.
Tx
October 20, 2010 at 11:24 pm
You can query the BACKUPSET table in MSDB to get information on successful database backups.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 20, 2010 at 11:33 pm
Hi Adiga,
Can you give one example on this i have tried it but it is not working
know i am trying with
"Restore Verify only <backup device > <load history> is it correct or not
tx
October 20, 2010 at 11:51 pm
RESTORE VERIFYONLY FROM DISK='......'
More information here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 28, 2010 at 4:04 pm
1. You can check your job history if the backup job completed successfully.
2. Check in msdb with following query
select database_name, backup_start_date, backup_finish_date, is_damaged
from
msdb.dbo.backupset
where
database name like '%YourDB%'
3. Check the backup file with following command if the backup file is fine and not corrupted. it will not check the internal sturuture of the datbase
RESTORE VERIFYONLY
FROM <backup_device>
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply