All Questions
Tagged with sql-server backup
1,207
questions
1
vote
1
answer
33
views
Does enabling backup compression in a Back Up Database Task enable checksums, no matter what setting you pick for them?
Observations
The documentation says
To enable backup checksums in a BACKUP (Transact-SQL) statement, specify the WITH CHECKSUM option. To disable backup checksums, specify the WITH NO_CHECKSUM option....
-1
votes
0
answers
48
views
Best Practices for Migrating 2TB MSSQL Databases with High Availability to PostgreSQL
I'm planning to migrate a large-scale MSSQL environment to PostgreSQL and would appreciate some advice and best practices. Here are the details of our current setup:
Current Environment:
Two servers ...
4
votes
1
answer
109
views
Backups/CHECKDB errors - "Cannot find server certificate"
I have been exchanging TDE certificates on various servers to make restores easier - some had the wrong name, the wrong thumbprint, or even both. This involves transferring databases to a temporary ...
1
vote
2
answers
97
views
Understanding Recovery Forks in SQL Server: Meaning and Significance
I'm trying to understand the concept of recovery forks in SQL Server, particularly in relation to the sys.database_recovery_status view. The documentation mentions several columns related to recovery ...
0
votes
0
answers
29
views
Error Delete Distributor on sql Server 2019
I can't delete Distributor. The system shoew message error "Could not drop the Distributor 'Dis_name'. This Distributor has associated distribution database"
-1
votes
3
answers
147
views
Does it make sense to Full Back up weekly or Back up Transaction Log every 15 min?
I have to make a decision (at work) to choose which option is more feasible using SQL Server 2019:
Option 1: Full backups sent once per week and differential backups sent between weekly backups.
...
1
vote
0
answers
49
views
SQL server suddenly backups are slow
I've an older SQL 2008R2 server that will dismissed and upgraded this year.
Unfortunately server needs to remain up and running until then.
Problem is since a few days ago, backups are really slow (...
0
votes
1
answer
34
views
MySQL Backup (.cfk) file to Microsoft SQL Server
.cfk file is a backup from a MySQL database => Microsoft SQL Server
I am currently working on transferring a MySQL database backup file with the extension .cfk to Microsoft SQL Server. I tried the ...
2
votes
1
answer
39
views
Can we take a copy-only backup for filegroups on the SQL Server from a secondary HA replica?
I am getting the below error while executing the script for taking filegroup backups from a secondary replica.
Msg 3059, Level 16, State 1, Line 18
This BACKUP or RESTORE command is not supported on ...
0
votes
1
answer
78
views
Telling SQL Server about moving the backup files
I moved some backup files to new destination. However, the SQL Server seem to think they are still in their old place. (That is, when I use the SSMS Restore Database wizard, it it still comes up with ...
0
votes
1
answer
57
views
Multiples full backup from MS SQL Server all day long
I think this is not the best practice, but on a server I am administering, there is a PowerShell script doing full backups of a Microsoft SQL Server Express Edition instance every X minutes.
What ...
0
votes
1
answer
53
views
Preferred seconday backup in AG - what about the primary ? Shows no backups taken
I did setup the Ola Scripts sticking to https://www.brentozar.com/archive/2015/06/how-to-configure-alwayson-ag-backups-with-ola-hallengrens-scripts/
Options are:
@Databases = 'USER_DATABASES',
@...
0
votes
4
answers
229
views
how to transfer data from Prod environment to Dev environment?
My database in the prod environment is very large and I backup this database every day and restore it to the dev environment. This process takes 4 hours, which is actually too long. What else can I do ...
0
votes
0
answers
41
views
MSSQL logs are not being rotated in AG setup
I have an MSSQL setup primary-secondary configured through availability group. I see the logs do not get rotated even after the full backup is executed daily and logs backup is taken after each hour ...
0
votes
0
answers
107
views
SQL Backups with SQL 2022 Contained Availability Group
We have a SQL 2022 Always On Availabilty Group with Contained databases; a new feature in this version of SQL. The master and msdb databases are now also in the Avalability Group. We like this setup, ...