How to verify backups in sql server

Search
Generic filters
Exact matches only
Filter by Custom Post Type
How to verify backups in sql server


1) RESTORE VERIFYONLY
2) RESTORE HEADERONLY
3) RESTORE FILELISTONLY
4) RESTORE LABELONLY

--Backup is valid or not 

RESTORE VERIFYONLY FROM DISK = 'E:\SQLBAKUP\backuptest.bak'

-- How many backup sets are there in your backup. 
Suppose if you take backup more than one time into one file 
this command will show you all backup-sets in that fileĀ 

RESTORE HEADERONLY FROM DISK = 'E:\SQLBAKUP\backuptest.bak'

-- check each backup sets inside database files 
( WITH FILE=2 means 2nd backup (set) in current backup)
It will show physical files (MDF/NDF/LDF) location in your backup setĀ 

RESTORE FILELISTONLY FROM DISK = 'E:\SQLBAKUP\backuptest.bak'
RESTORE FILELISTONLY FROM DISK = 'E:\SQLBAKUP\backuptest.bak' WITH FILE = 2
RESTORE FILELISTONLY FROM DISK = 'E:\SQLBAKUP\backuptest.bak' WITH FILE = 3


--Check backup media options 

RESTORE LABELONLY FROM DISK = 'E:\SQLBAKUP\backuptest.bak'

Liked this Article.?

We have lot more interesting posts like this!  Join more than 5000 subscribers who stays ahead on technology.

By entering your email, you agree to the Terms and Conditions and Privacy Policy and cookies usage

You Make like the below posts

About The Author

Share on

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest

Leave a comment

Your email address will not be published. Required fields are marked *

Can't Find What You Are Looking For?.

Please enter the details below. We will try our best for you :-)

We have more amazing posts

Try searching here

lick edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

We assure our best to meet up to your expectations

Your Feedback will help us

Glad That You Liked It

Your Feedback will help us to improve