How to checks whether the SQL backup file is structurally valid and readable.
1) RESTORE VERIFYONLY
2) RESTORE HEADERONLY
3) RESTORE FILELISTONLY
RESTORE VERIFYONLY
FROM DISK = 'D:\SQLData\Backup\DBA_FULL.bak';
RESTORE HEADERONLY
FROM DISK = 'D:\SQLData\Backup\DBA_FULL.bak';
RESTORE FILElistonly
FROM DISK = 'D:\SQLData\Backup\DBA_FULL.bak';
No comments:
Post a Comment