How can I confirm whether my Backup file is usable or not ?

Question

question

jhunu asked Dec 20, '11

How can I confirm whether my Backup file is usable or not ?

I have created a backup File. How can I confirm whether my Backup file is usable or not ?

oracle 11g

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-12-20T10:37:17Z

salum answered Dec 20, '11

you can use restore with verifyonly option to check backup file. here is more details http://www.mssqltips.com/sqlservertip/1093/verifying-backups-with-the-restore-verifyonly-statement/

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn_Melton commented · Dec 20, 2011 at 10:58 AM

This is a question toward Oracle, if you go by how the OP tagged the question.

1 ·

Answer 2 · 2011-12-20T11:10:12Z

Shawn_Melton answered Dec 20, '11

You can find the answer in Oracle's documentation: [Validating Database Files with BACKUP VALIDATE][1] [1]: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmvalid.htm#CHDCEHFD

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2011-12-21T04:02:26Z

ramesh 1 answered Dec 21, '11

use this script RESTORE verifyonly from disk = 'C:\Database\TfsIntegration.bak' ---full path with file name of backup file RESTORE filelistonly from disk = 'C:\Database\TfsIntegration.bak'---full path with file name of backup fil

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn_Melton commented · Dec 21, 2011 at 06:37 AM

Again, the OP is referring to Oracle, not SQL Server.

1 ·

question