1,575 questions
0 votes
0 answers
49 views
Best practice for backing up large SQL Server databases to S3 [closed]
We are currently backing up all of our databases to a series S3-Compatibable storageGRID buckets hosted by our data center provider. Some of our larger databases backups run quite long (upwards of 8 ...
-1 votes
1 answer
51 views
Match Postgres WAL Segments to According Base Backup
As both the archive_command and restore_command defined with related config options looks to be injected only with %f and %p parameter how actually to identify on top of what base backup the current ...
1 vote
1 answer
43 views
SQL-Express 2019: Restore Multiple .BAK Files as individual Databases
I have to restore a SQL backup from someone external and have the following issue: Instead of making a nice single big file for the entire instance of SQL, I have a folder with 100+ individual ...
0 votes
0 answers
40 views
Unable to Restore SQL Database from Disk. SSMS only sees server filesystem [duplicate]
I have SQL Server 2022 and I am trying to take a .bak from my localhost server instance and restore it to my remote instance (NOT Azure). When I go to Restore Database I select Device and click the ...
1 vote
0 answers
105 views
Unable to run DBCC CHECKDB , Receiving Transport-Level Error Every Time
LOOOONG story short, I am trying to migrate to a new server. I installed SQL Server on the new one and had it access the same drive with the sql databases. There were some bumps trying to get it to ...
0 votes
0 answers
42 views
backup and restore cassandra db while changing time in the past between operations
Anyone experienced backup and restore database actions with cassandra with time set to the past between backup and restore? I tried this: backup a keyspace via nodetool snapshot export keyspace ...
1 vote
1 answer
93 views
Copy SQL Server database from prod to local developer machine without Windows authentication
To improve the DX and address problems with migration conflicts during development we want to move from a common dev DB to a local copy on each developers machine. My idea is to provide a tool or ...
0 votes
0 answers
122 views
Backing up single-node ClickHouse data with restic to S3
What are the pros/cons of using restic to backup a single-node ClickHouse to S3 vs using built-in functionality and/or clickhouse-backup script from Altinity? My main concern is if restic can handle ...
0 votes
0 answers
101 views
How to restore SSAS .db from folder backup
I couldn't connect to (microsoft analysis service) SSAS from SSMS because it threw some errors with old databases. I followed this guide https://learn.microsoft.com/en-us/answers/questions/1159973/...
0 votes
1 answer
29 views
./create backup from on prem script not working properly in oracle linux
[oracle@srv1 oci-cli-scripts]$ ./create_backup_from_onprem --config-file /home/oracle/.oci/config --profile DEFAULT --display-name testbackup --compartment-id ocid1.tenancy.oc1.....
1 vote
0 answers
112 views
Cannot restore SQL Server log due to early LSN of log backup
I want to do a databases backup on master server and afterwards restore of this database on slave server. I have this sequence in T-SQL script: Backup (run on master server) DECLARE @backupFileName ...
1 vote
1 answer
405 views
Certificate and Symmetric Key Restore is not decrypting the data originally encrypted
I am working in a test environment with SQL Server 2017 to verify that encrypting data with a symmetrical key will meet our needs. I have successfully encrypted and decrypted data using the ...
0 votes
1 answer
157 views
problem in backing up mysql database in laravel 11 using a route
I want to backup mysql database in laravel 11 using a route. I tried some ways and all of them had problem: using Spatie/db-dumper: protected $signature = 'backup:database'; public function handle() {...
0 votes
2 answers
223 views
Issues Restoring PostgreSQL dump.sql: Schema Exists and Unique Constraint Violations
I have a dump.sql file that I want to restore to a local database on my machine. However, when I try to import it, I get an error saying all schemas, functions, relations, constraints, roles are ...
1 vote
1 answer
108 views
Problem Restoring PostgreSQL Database in Docker Container with Symfony
I'm developing a Symfony application to backup and restore databases. My application works fine on the Symfony server, but I'm facing issues when trying to use it with my dockerized setup. Context: I ...