1,572 questions
2
votes
1
answer
120
views
SQL Server BACPAC import error - foreign key constraint conflict (SQL72014 / Msg 547)
I am trying to export/import a SQL Server database using a .BACPAC file through SQL Server Management Studio, but the import fails with a foreign key constraint error.
Error during import:
Error ...
Best practices
0
votes
1
replies
24
views
Barman postgresql backups
Is it possible to run barman on ubuntu 24.04 (Postgres 16) while the database server is on rhel 7 (Postgres 14)
I am interested since it can achieve low RPO's
- 23
Best practices
1
vote
1
replies
89
views
Ask about mobile cross application
I am interested in building a cross-platform mobile application for both Android and iOS.
If I choose Flutter for app development, what core concepts and skills I should focus on? Similarly, if I ...
-1
votes
1
answer
64
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 ...
- 525
1
vote
1
answer
72
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 ...
- 31
0
votes
0
answers
43
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,550
1
vote
0
answers
132
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 ...
- 1,550
1
vote
1
answer
112
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 ...
- 888
0
votes
1
answer
38
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
149
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 ...
- 49
1
vote
1
answer
482
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 ...
- 41
0
votes
1
answer
164
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()
{...
- 306
0
votes
2
answers
259
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 ...
- 246
1
vote
1
answer
228
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 ...
- 33
0
votes
1
answer
39
views
Backup and restore metadata of PieCloudDB
I am using the cloud edition, and the overall usage of the database is relatively light, about 1GB. I want to know how to backup and restore the metadata of PieCloudDB Database management and control ...
- 89