Backup and Recovery - What are two options to validate whether or not a SQL Server backup will restore successfully?

Question

Backup and Recovery - What are two options to validate whether or not a SQL Server backup will restore successfully?

Arjun SreeVastsva

SSCertifiable

Points: 7141
More actions
February 17, 2010 at 5:50 am

#386324

Backup and Recovery - What are two options to validate whether or not a SQL Server backup will restore successfully?

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Test question? Interview question?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 2

GilaMonster (2/17/2010)
Test question? Interview question?

Yes ! Yes !

No ! No !

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 3

Joy Smith San

SSC-Insane

Points: 24877

February 18, 2010 at 7:33 am

#1120918

.....has got 585 points in this forum.... 🙂

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 4

:-):-):-)

Raju click the link

http://www.google.co.in/#hl=en&source=hp&q=Backup+and+Recovery+sql&btnG=Google+Search&meta=&aq=f&oq=Backup+and+Recovery+sql&fp=e24c1ca3843ba2b2

Edit:Add the correct link

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 5

muthukkumaran (2/18/2010)

:-):-):-)

Raju click the link

http://www.google.co.in/search?hl=en&rlz=1G1GGLQ_ENIN335&q=Backup+and+Recovery+sql&btnG=Search&meta=&aq=f&oq=%5B/url%5D%5B/quote%5D

Hi Muthukkumaran

Edit the link, it does not work..

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Joy Smith San (2/18/2010)
.....has got 585 points in this forum.... 🙂

You get points from correctly answering the Question of the Day as well.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 7

Joy Smith San (2/18/2010)
.....has got 585 points in this forum.... 🙂

That's not the points in the forum, it is in the entire SSC site.

When I see a user posting such a post, I would click on the user name and from the pop up menu, select Find All member's Post. It returns the last 150 forum posts by that user, (if they have more than 150 posts). It would be clear by looking at the user's previous posts and also how many posts they really made in forums (if less than 150)

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 8

Bru Medishetty (2/18/2010)

muthukkumaran (2/18/2010)
:-):-):-)
Raju click the link
http://www.google.co.in/search?hl=en&rlz=1G1GGLQ_ENIN335&q=Backup+and+Recovery+sql&btnG=Search&meta=&aq=f&oq=%5B/url%5D%5B/quote%5D
Hi Muthukkumaran
Edit the link, it does not work..

Thanks Bru .I edited.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

subha.mcts2005 SSC Eights! Points: 928 More actions · Answer 9

HI everyone,

can u give the exact answer for this question!

Regards

Subha

mattias 58533 SSC Enthusiast Points: 110 More actions · Answer 10

I would guess "RESTORE VERIFY ONLY FROM <BACKUP_DEVICE>"...but what is the second?

subha.mcts2005 SSC Eights! Points: 928 More actions · Answer 11

thanks ,

i know that first one, iam also looking for second one?

ok, we will wait some one will help us!

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 12

I'll give you a hint, there aren't 2, there's only 1, and verifyonly isn't it.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 13

Let me take a wacky guess...

http://www.yohz.com/products_sqlverify_restoreverifyonly.htm?source=ssc

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 14

And here's another one with more details.

http://www.yohz.com/help/sqlverify/howreliableisrestoreverify.htm?source=sv