1,575 questions
0
votes
0
answers
47
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
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 ...
- 31
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 ...
- 1,550
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 ...
- 888
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/...
- 814
1
vote
0
answers
111
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
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()
{...
- 196
1
vote
1
answer
105
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
38
views
How to use PREPARE and EXECUTE in Stored Procedure backup script (MySQL)
I have a Stored Procedure which loops through all the tables in a schema (customerinfo) and makes a backup of them by renaming them to include the date and copying them to another schema (...
- 115
0
votes
1
answer
514
views
Azure SQL backup is not available to restore to a new server
I am creating a simple DR plan for my Azure application. The app's RTO is up to a week so it is not a critical app so I don't need to setup Active/Passive servers or any type of automated failover.
...
- 832
0
votes
1
answer
119
views
How do I Dump MySql Tables One At a Time Using Python
I am using MySQL 5.6.21 on a Windows server and need to migrate from one machine to another. Been trying to use the MySQL Workbench Export Tables and I keep getting an error 22 on write at some point ...
0
votes
1
answer
370
views
Troubleshooting Database Backup Errors in Odoo
Database backup error: Command '['/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpnre4kpbf/dump.sql', 'test']' returned non-zero exit status 1.
I am getting this error message when taking backup and ...
0
votes
1
answer
210
views
Create new database from a MariaDB backup
I have a large database (over 150GB and growing) in production. Currently I make a full back up of it using the mariabackup command, and then twice a day I do incremental backups of the database.
I ...
- 3,720
0
votes
1
answer
215
views
Flutter DB Backup While Using Sqflite
I'm working on a flutter project. I want to extract and add the database for backup, but I haven't been able to do it for days. I'm thinking about how I can do this. I wonder if I can do this. Is this ...
- 1
0
votes
1
answer
131
views
Multiple country Database Backup - Azure YAML Pipeline
I would like to create a pipeline that backup databases on different servers (each server is a different country).
I am thinking that the Stage/step/job for each country will have to be computed by ...
- 1
0
votes
1
answer
58
views
Cassandra Replication Strategy based on Primary Key for Archiving Data Old Data
I'm thinking in the manner of storying iot telemetry data.
I'd like to optimize my storage. In this case let us take iot telemetry as an example. I'd like to keep recent data (eg last 6 months) as hot ...
- 9,612
0
votes
0
answers
89
views
Trouble retrieving a .bak file using SQL Server in Amazon Linux
I have a SQL Server database running on a Amazon Linux machine and I want to create a backup of it. I am using the following query:
BACKUP DATABASE Database TO DISK = 'backup.bak';
This, in fact, ...
0
votes
0
answers
199
views
mariadb-dump with database name containing unicode characters?
Trying to author a mariadb-dump.exe command line to back up our MariaDB 10.11 databases on Windows (Swedish locale, win-1252 system codepage). Unfortunately we expect full unicode support and named a ...
- 1,623
0
votes
1
answer
110
views
Why PostgreSQL extension was not dumped when created from `/docker-entrypoint-initdb.d/*` script?
I created extensions from /docker-entrypoint-initdb.d/* script like this:
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname db <<EOSQL
CREATE EXTENSION citext;
CREATE ...
- 26k
0
votes
1
answer
674
views
Error: reading Backup Vault (AWSTargetBackupVault): couldn't find resource….. getting this erro while creating backup vaullts and plan via terraform
Im trying to create a awa backup plan via terraform
For that i have code creating aws backup vaults.
While terraform apply im getting this error even though the vaults are getting created on the ...
0
votes
1
answer
233
views
mongodump : passing --query argument : error parsing command line options
I have a collection sampleColl.
MongoDB Enterprise > db.sampleColl.find().limit(3);
{ "_id" : ObjectId("64f01e4f58e834c50cdf63c1"), "field" : "2ed2892b" }
{ &...
- 10.6k
0
votes
1
answer
466
views
Navicat backup restoring - [Err] Failed to create View
I was testing the restoring of my database backup
and when it comes to the views, most of them are restored but for some views it gives me an Error
I went to check the view, the view has a select ...
- 1
0
votes
1
answer
248
views
How can I create backup script for selected tables in Oracle
I am using below script to create backup file but it takes backup of all tables. I want backup of selected tables. how can I achieve this.
imp <username>/<password>@<hostname> file=&...
0
votes
0
answers
142
views
pg_dump stops with this message free(): double free detected in tcache 2
We need to create a logical backup of the database, and we initiate the process with the following command:
pg_dump -U postgres -Fc -Z6 -f /tmp/backup.dump DOC
After some time, we encounter the ...
4
votes
2
answers
4k
views
How to access local(backup) file from Pgadmin(Postgres editor) that is running in a docker container to populate my database [closed]
I am in the process of migrating all the database records from my docker Postgres environment. I am new to docker and volumes. I have a backup SQL file of Postgres in my local system. How do I access ...
- 123