Problem in BACKUP job

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
Please try using RESTORE VERIFYONLY on your dodgy backup file - it might be
sufficient in this case.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you Paul. It satisfies me.
Thanks,
Soura.
"Paul Ibison" wrote:

> Please try using RESTORE VERIFYONLY on your dodgy backup file - it might be
> sufficient in this case.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>