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 =...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
backup × 2752sql-server × 1114
mysql × 531
restore × 472
postgresql × 310
mysqldump × 223
sql-server-2012 × 161
transaction-log × 157
oracle × 150
sql-server-2008-r2 × 123
sql-server-2008 × 106
sql-server-2014 × 105
replication × 95
rman × 94
sql-server-2016 × 79
recovery × 73
innodb × 71
percona × 70
availability-groups × 65
ola-hallengren × 65
mongodb × 57
sql-server-2005 × 56
mariadb × 54
maintenance-plans × 39
oracle-11g-r2 × 37