Hi,
I am using a job to take daily backup.
BACKUP DATABASE databasenameTO DISK=N'path'
WITH INIT,NOUNLOAD,NAME=N'name',
NOSKIP,STATS=10,NOFORMAT
and it was working fine.
When I tried to restore the backup, I couldn't restore it, the backup was
uncompleted(I know this only when i tried to restore it). But in Enterprise
manager Last Run Status shows 'Succeeded'.
Is there any option to check whether the backup is in good condition or to
check the integrity of the backup immediately after the completion of
backup(through query without restoring the backup).
Thanks,
Soura
>> Stay informed about: Problem in BACKUP job