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.

Filter by
Sorted by
Tagged with
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=/...
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 ...
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 ...
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 ...
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 ?
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-...
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 ...
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 ...
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'...
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 ...
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 ...

1
2 3 4 5
52