New answers tagged

0 votes

Does mysqldump -all-databases include all objects

I use mysqldump --defaults-file=/something/backup.conf --single-transaction --opt --default-character-set=utf8 --events --routines --triggers --all-databases | gzip -9 -c | sudo tee /...
user avatar
0 votes

Decrypt T-SQL log backup header and read LSN

The log backup MAY be encrypted, depending on your setup. (Ref) The structure of the log backup is likely proprietary, so the only reliable/recommended way to read it is via SQL Server/Microsoft-...
user avatar
  • 1
2 votes

I am facing difficulties in backing up a database in MS SQL Server

I see you are using SQL 2019, not SQL 2022. I can see this from both object explorer and also from the backup path. The number 15 is for SQL 2019. SQL 2022 is still in private preview and not yet ...
user avatar
0 votes

What happens when full backup, differential backup and log backup schedules collide?

You could easily schedule your diffs to run Mon - Sat and that will potentially make the full backups faster. Diffs don't break the backup chain so in the case of restores you would still apply your ...
user avatar
3 votes
Accepted

How do I generate the private key needed to restore the encrypted backup?

The private key is used as part of the BACKUP CERTIFICATE syntax. Per the docs, the syntax is: BACKUP CERTIFICATE certname TO FILE = 'path_to_file' [ WITH PRIVATE KEY ( FILE =...
user avatar
  • 14.2k

Top 50 recent answers are included