Backup and Ransomware

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Johan Bijnens SSC Guru Points: 135330 More actions · Answer 1

Anyone who has write auth on the backup file, can manipulate it.

Will it be restorable?

use checksum as a backup parameter, so SQLServer checks this and prevents a restore of a manipulated file
- BACKUP DATABASE AdventureWorks2022
  TO DISK = 'Z:\SQLServerBackups\AdvWorksData.bak'
  WITH CHECKSUM;
  GO
If you store actual files in your db, this will not prevent anyone from storing an infected file into your database blob. As from sql server perspective, it will produce a valid backup set.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Deni Kusdeni Ten Centuries Points: 1300 More actions · Answer 2

Ok, thanks, as long as bak file did not protected, still possible anybody "inject" something, right?

Johan Bijnens SSC Guru Points: 135330 More actions · Answer 3

of course, there's also the database's page verify option, that protects page content ...

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Deni Kusdeni Ten Centuries Points: 1300 More actions · Answer 4

Ten Centuries

Points: 1300

August 21, 2024 at 9:04 am

Noted, Thanks