Ads

06 March 2026

How to validate the Backups in SQL server

 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