Restore options

Question

Restore options

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
June 24, 2018 at 2:41 am

#77198

Comments posted to this topic are about the item Restore options

Viewing 13 posts - 1 through 12 (of 12 total)

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

Stewart "Arturius" Campbell SSC Guru Points: 72625 More actions · Answer 1

Good question to start the week on, thanks, Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 2

Compressed backups have CHECKSUM by default or is the BOL wrong? Or is it too early and i have to wake up first?

Andrew Watson-478275 SSCarpal Tunnel Points: 4652 More actions · Answer 3

Of course, before it even gets that far, it will fail because of the missing quote at the start of the filename ;^{)}

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 4

From BOL:

To enable backup checksums in a BACKUP statement, specify the WITH CHECKSUM option. To disable backup checksums, specify the WITH NO_CHECKSUM option. This is the default behavior, except for a compressed backup.

Enable or Disable Backup Checksums During Backup or Restore (SQL Server)
So, the backup is compressed and the restore runs successfully.

Mighty SSCrazy Eights Points: 9063 More actions · Answer 5

Carlo Romagnano - Monday, June 25, 2018 4:45 AM
From BOL:
To enable backup checksums in a BACKUP statement, specify the WITH CHECKSUM option. To disable backup checksums, specify the WITH NO_CHECKSUM option. This is the default behavior, except for a compressed backup.

Enable or Disable Backup Checksums During Backup or Restore (SQL Server)
So, the backup is compressed and the restore runs successfully.

+1

George Vobr SSCrazy Eights Points: 9997 More actions · Answer 6

Thanks, Steve for a pretty interesting question. After reading the Docs "Enable or Disable Backup Checksums During Backup or Restore (SQL Server)", I was not sure of the correct answer at all.
This topic is much better explained on the SSC.com blog in "Are CHECKSUMs being performed with a Compressed Backup?"
Another interesting article is on the MSDN blog "Backup Compression and Checksum".

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 7

Points awarded back. I never looked at compression, just randomly choosing a non-checksum option. However that would be a good question.

Apoligies.

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 8

Steve Jones - SSC Editor - Tuesday, June 26, 2018 3:02 AM
Points awarded back. I never looked at compression, just randomly choosing a non-checksum option. However that would be a good question.
Apoligies.

When?

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 9

?? When is it a good question? When did I do this? Not sure what you're responding to.

t.ovod-everett Default port Points: 1487 More actions · Answer 10

Andrew Watson-478275 - Monday, June 25, 2018 3:27 AM
Of course, before it even gets that far, it will fail because of the missing quote at the start of the filename ;^{)}

That's what I came here looking to see mentioned in the discussion thread - even spotted that one in the e-mail before I clicked on the link!

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 11

Steve Jones - SSC Editor - Thursday, June 28, 2018 11:14 AM
?? When is it a good question? When did I do this? Not sure what you're responding to.

When did you award back Points? I still see "Incorrect answer" in my profile.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 12

Hmmm, my process is supposed to update all these. I've gone ahead and manually updated the database