New answers tagged backup
1
vote
Backup SQL Server databases in Parallel using Ola Hallengren script
In this Github issue, Ola Hallengren explained that:
You need to create multiple jobs with the same parameters, and add @DatabasesInParallel = 'Y'. The jobs will then work together in processing the ...
- 331
1
vote
Why can't I restore my SQL-Server database?
I think this query here from my friend John can help you:
/*-------------------------------------------------------------------------*\
This query will generate the proper restore chain for all ...
- 16.6k
1
vote
Migrating SQL Server databases using differential backups, NOT transaction log backups
I's say you've taken the right steps. If you can reach a point in time where no legitimate user or application can modify the databases, then you can safely take the "final backup", and use ...
- 193
3
votes
Accepted
Why can't I restore my SQL-Server database?
All that the GUI does is to create a bunch of T-SQL commands for you. The restore dialog, in particular is a very difficult beast to understand. When I teach, I can explain backup and restore ...
- 17.9k
0
votes
Get-DbaBackupInformation with -Azurecredential
The AzureCredential parameter is the name of a SQL Server Credential that has the Azure Credentials used for backing up/restoring backup files from Azure. This is the same credential you would use ...
- 10.4k
1
vote
Accepted
Take a backup from specific range
I need to backup the data of a specific table by week and then restore
it but without truncate table
If we are talking about previous week based on current date then to find the starting day(Monday) ...
- 4,463
0
votes
Website Content Not Displaying Correctly in Vietnamese After Restoring Database from Backup
"restored the website using the backup" -- Could we see a little more of the backup -- namely where some Vietnamese text can be seen.
I worry that the backup may have been messed up.
Also, ...
- 79.4k
2
votes
Accepted
Differential backups don't work
Your command to examine the backup information could be expanded by a couple of columns. Two that spring to mind are is_snapshot and is_copy_only and then the application performing the backup: ...
- 18.3k
0
votes
Cassandra Backups questions
attach a local Disk and copy or snapshot the data onto this Disk
That should work fine.
What is your replication factor (RF)? If you're running with RF==2 on 2 nodes, then they should each have ...
- 4,280
Top 50 recent answers are included