Questions tagged [backup]
Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
2,567
questions
0
votes
0
answers
4
views
Backup constantly failing on secondary server with 'Cannot recover a truncated undo tablespace'
We are constantly getting failed backups with xtrabackup when the backup is run from a secondary server. How do we permanently fix this undo tablespace issue on the primary mysql server, so that the ...
- 156
0
votes
0
answers
13
views
Postgres stuck in wal recovery crashloop
My postgres is deployed on k8s using the timescale helm chart. It's managed by patroni and the backup is managed by pgbackrest.
It's been stuck in this state for a day now (removed timestamps etc. ...
- 105
1
vote
1
answer
49
views
Error in the documentation MariaDB -> mysqlbinlog: `--rewrite-db` and `--database`
In the mysqlbinlog utility documentation, the --rewrite-db=name option has the following explanation
Filtering (e.g. with --database=name ) happens AFTER the database rewrites have been performed.
...
- 453
1
vote
1
answer
23
views
How to copy data between postgres schemas if there are objects?
I removed shop from database, that should not be removed. Fortunately I had backup and reverted this backup to schema public_backup.
Now I am trying to restore only this shop. I can't override my ...
- 199
-3
votes
1
answer
35
views
TB database backup and move
For a SQL Server 2019 we want to backup a 3 TB database to another DB and we want very minimum downtime what is the best way?
Thanks
0
votes
0
answers
27
views
Diffrent results recreating .frm files with mysqlfrm between MySQL 5.7 and Percona XtraDB cluster 5.7
Hello to everyone dedicating the time to read this thread.
I have recently stumbled upon a problem while restoring a MySQL 5.7 database into a Percona XtraDB cluster 5.7.
The restoration process was ...
0
votes
0
answers
25
views
Local to Azure backup errors and question
I am wanting to back up a local SQL Server 2016 database to Azure.
When I first started looking into it, I found this quote from the Azure usage calculator.
When I tried to set it up, all the ...
- 193
0
votes
2
answers
55
views
Postgresql backup with ZFS snapshots: Is pg_start_backup()/pg_stop_backup() necessary?
The title says it all. I have found this from 10 years ago saying that if database data it's all in the same snapshot, then isn't needed. PG will start from snapshot like in a typical crash.
But what ...
- 181
0
votes
0
answers
22
views
MySQLPump ends with Segmentation Fault
I am trying to improve the performance of backups using mysqlpump. It works on the smaller databases but the larger ones - where I actually need it - it fails.
The output from mysqlpump indicates a ...
0
votes
1
answer
44
views
mariabackup system file permissions
I have an instance of mariadb 10.6.7 on an Ubuntu 22.04 Server and I am trying to do backups of a specific database with mariabackup.
mariabackup --backup --user="my_test_user" --target-dir=/...
- 1
2
votes
3
answers
49
views
What is a good way to get a time for the data freshness when the source is log shipped to another server?
I'm log shipping from SERVER_A with backups every 10 minutes.
I restore the logs to SERVER_B every 20 minutes.
I pause the restores while I do a DWH load from SERVER_B into SERVER_C
I report out of ...
- 23
0
votes
0
answers
25
views
How can I restore Postgres DB with pg_basebackup in my case?
I have two DB servers and backup which is configured by pg_basebackup. You can see whole command below.
pg_basebackup -h $PGHOST -p $PGPORT -U $PGUSER -w -D $backup_dir/psql_base_backup_$(date +"%...
- 1
0
votes
1
answer
29
views
Very long timestamp for a backup file created via a Maintenance Plan
I have been using Maintenance Plans to back up my databases. It works well enough for me but I am curious to know why the .bak have a very long date/time suffix. Here is an example:
...
- 3
0
votes
1
answer
52
views
Using Ola Hallengren's succeeds to take full backups but fails to take a differential
I take weekly Full backups (all my databases are in Full recovery model) on Sundays and then schedule the Diffs to run nightly (except on Sundays).
Looking through my logs I see this:
Cannot perform ...
0
votes
0
answers
28
views
Corruption in backup but valid checksum
We have corruption in one of our full backups but I can't find an explanation how it happened. The server is a SQL Server 2019 Enterprise edition (CU17) with 5 databases in an AG. The backups are ...
- 1,982
0
votes
1
answer
19
views
Troubleshooting foreign key dependency error when setting up new MariaDB replica
Question: Does anyone have advice on what I can do to successfully get this new replica set up and replicating from our production server just like the old replica?
Details:
I am trying to set up a ...
0
votes
0
answers
26
views
What is the best way to migrate a multi-TB MySQL database from on-prem to gcloud Cloud SQL?
I have several multi-TB on-prem MySQL databases I need to migrate into Google Cloud's managed MySQL offering, Cloud SQL. I have migrated two of size ~1TB so far with mysqldump but this method is far ...
- 113
1
vote
1
answer
35
views
New Network Share For Backups - Permissions don't work until instance restart?
For some time, I have known this... but when I am moving my backup storage to a new network share, I must restart the service account for SQL (sometimes the instance, if the same account is used) in ...
- 11
0
votes
1
answer
41
views
Strategy to backup up databases based on their status obtained from another Table
I'm looking for a solution to backing up databases based on their status stored in a DB Table (Inactive databases stay online as well)
i.e.
Get the status of active DBs using
SELECT dbName from DBMain....
- 3
0
votes
1
answer
20
views
How to backup faunadb collection?
I want to migrate my faunadb collection to a different database, how can I download all data in collection in a JSON format ?
- 101
0
votes
1
answer
33
views
Backup database on local pc
I am using this script to backup database on computer A:
sqlcmd -U MyDatabase -P MyPassword -S .\SQLEXPRESS -Q "EXEC sp_BackupDatabases @backupLocation = 'c:\shared', @databaseName='MyDatabase', @...
- 131
0
votes
1
answer
66
views
What is an ideal retention policy for SQL Server system database backups?
We have defined a data retention policy for our user databases, where our full backups are retained for 90 days, diffs are retained for 30 days, and logs are retained for 48 hours. This meets our ...
- 103
0
votes
0
answers
5
views
How xtrabackup restores data to the replica server
The product is a microservice architecture, divided into multiple databases. In order to facilitate the background management program to facilitate cross-database linked list query, a replica server ...
- 1
1
vote
2
answers
64
views
In PostgreSQL how do I generate a script that will recreate the database and all of its contents?
I'm trying to generate a SQL script that will recreate a Database I have on my installation of PostgreSQL but I have not been successful yet.
I'm able to create a backup file of my database using the ...
- 37
0
votes
1
answer
54
views
Backups cannot be restored on AWS RDS - View creation problem. Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this
The environment is MariaDB 10.6.8, via Amazon RDS. We have all 'admin' rights but not SUPER on AWS databases.
I have a view in an application that has it's data stored in a single schema. We use non-...
- 101
0
votes
0
answers
14
views
Save Query Results into Excel and Automatically run it
I have a very simple query
Select * from Employees
I want to run this query automatically on a daily basis and save the results in excel using SQL Server. Is there any way I can achieve this purpose?
...
0
votes
0
answers
29
views
Does data file instant initialization has anything to do with backup speed?
While I was reading my SQL Server notes, I found this info.
How to speed up the backup of VLDBs?
------------------------------------
Choose a proper time (database is not under heavy load)
Backup ...
- 624
8
votes
2
answers
517
views
MS SQL Server DB Transaction Log Growth Rate
I have a busy database, it has been busy for years and I've seen a transaction log size of approx a few GB a day.
In the last few weeks, that transaction log size has increased to 40-50 GB every 6 ...
- 183
0
votes
1
answer
31
views
How do we recover archivelogs which are deleted by rman but on disk?
We have have rman which keeps only the current day backup.
In asm we have a directory in +RECO/db1/ARCHIVELOG/ which stores the archive logs for the last couples of months.
Our archivelog path is the ...
0
votes
1
answer
50
views
SQL Server compressed backup firstly huge?
Is this a default/normal behavior? When we start a backup it create a file of 316gb and only after backup finishing it shrink to 131gb. Don't make sense because in this case we need a disk of 316gb or ...
- 566
0
votes
2
answers
79
views
Can Oracle dump to stdout?
We're automating the nightly transfer of several databases from production into a "T-1" (or "yesterday") environment. It takes a while currently:
the source server has to dump the ...
- 136
0
votes
1
answer
34
views
Oracle DataGuard between 11.2.0.4 (primary) and 19c (physical standby)
Our production database is on 11.2.0.4. It needs to be upgraded to 19c.
Can I setup physical standby which is at 19c and keep it in sync with primary ?
Thereafter - during a weekend maintenance, the ...
- 141
0
votes
1
answer
88
views
pg_dump can not create directory after increase directory space
I recently run pg_dump to backup database using this command using user postgres : time pg_dump -j 4 -Fd -Z 3 db_profile -f /backup-nfs/
Previously, the size of backup-nfs was 100 G. The pg_dump ...
- 65
0
votes
1
answer
70
views
pg_dump dumping files to ROOT
I run pg_dump last nite to backup some 111Gb database :
time pg_dump -j 5 -Fd -Z 1 db_profans -f /backup-nfs/
I monitor the size growth
But, suddenly this morning, the database is down. I check the ...
- 65
0
votes
1
answer
42
views
Error during pg_basebackup
Im trying to create a cluster of postgresql-11 2 servers(cent7)
I added user "repluser" on main server in pg_hba.conf
on secondary server, stopped postgresql.service and using this as ...
- 5
0
votes
0
answers
63
views
pg_basebackup for one database only
I have a server that is hosting 9 databases at once. Only 1 of them is important.
I do this query to find their cumulative size :
SELECT pg_size_pretty( SUM(pg_database_size(datname))::bigint ) As ...
- 65
0
votes
1
answer
37
views
pg_start_backup vs pg_basebackup
I read stuff about pg_start_backup from here and pg_base_backup here.
I got confused. So, out of the 2 methods, which one is generally better ?
Seems that pg_start_backup is better than pg_base_backup....
- 65
-1
votes
1
answer
32
views
SQL Server long term backup policy
I wish to implement a long term backup policy in SQL Server on VM, much like Retention policies in azure sql database.
I have full backup once a week, diff once a day and log backup every 15 minutes.
...
- 1
0
votes
1
answer
313
views
Delete WAL archive files
I have around 200Gb of WAL archives. Can I just delete them all without considering any database restoration? I am just asking whether it is safe to delete them all or at least 50% of them.
I read a ...
- 65
2
votes
1
answer
36
views
Are there better alternatives to a time series databases for managing financial transactions?
We are considering using AWS Timestream to store financial transactions from various sources for users. Any solution needs to be able to support ~4k transactions per user per year for 1 million users. ...
- 21
0
votes
0
answers
57
views
Unable to Backup to Network Share Using Standard Backup Methods in SSMS BUT Works using Ola Hallengren's Scripts - SQL 2019
We have recently installed our first instance of SQL 2019 and are having a weird issue with trying to backup to a network share using the standard methods found in SSMS but it's working fine with Ola'...
- 153
2
votes
1
answer
55
views
How to develop backup strategy of many databases in 1 server
I have a server with many databases...it contains like 20 databases. Some of them has 16 millions of rows, but not that many. There are usually very low to no activity at night but not that busy ...
- 65
2
votes
1
answer
37
views
Any way to quickly shrink a database for using as clones
We have a database that's a bit over a TB - we normally back this up, then when developers make a clone database to develop against it takes a copy of this database and restores it to a fresh instance ...
- 365
1
vote
1
answer
27
views
Cassandra can't start with an old backup of /var/lib/cassandra
I have an old Cassandra backup of /var/lib/cassandra on an external drive and I want to setup a new database with this backup.
I install the same Cassandra version as then and in the yaml file I ...
0
votes
0
answers
36
views
Restrict logins from restoring backups into some databases - SQL Server
I'm looking for a way to restrict some logins (not users, see more below) from restoring backups into some specific, already existing databases.
I've read a couple articles on database permissions and ...
- 1
0
votes
0
answers
53
views
Backup not taking latest position
We are doing a Backup / Restore with maintenance plans. Running a scheduled job for the maintenance plan to backup a database and save it to another server. The backup is being created every night and ...
0
votes
0
answers
223
views
Mobile finance service transaction table design
I try to create an MFS(mobile financial service/p2p money transfer, bank with limited work) for learning. The transaction looks difficult. The user can do 3 things with his account.
Deposit money to ...
-1
votes
1
answer
40
views
How to Verify Backup Archive in MySQL
I would like to know if there is any way to verify MySQL backup files. (Check if the file is valid or not for restore). Thanks!!
2
votes
0
answers
26
views
Mysql shell seems not to dump deterministically. How can I minimise data transfer when rsyncing subsequent dumps?
What I'm trying to do is generate a full dump of my database using mysql shell, like so:
util.dumpSchemas(["my_db"], "outdir", {threads:88, bytesPerChunk: "256M"})
And ...
- 33
1
vote
0
answers
64
views
Powershell Script for Copying backup files and capture results in output file with specific details
I have the below PowerShell script which is working for me to capture the results for one set of backup file but my requirement is to copy 10 or more backups files in parallel to a shared location and ...
