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,660
questions
0
votes
1
answer
54
views
Restoring a backup of 1 database to another puts both databases into Restoring mode
We have a 2 databases-
Staging
Test
At times, we refresh out Test environment with a copy of Staging. We do this by taking a full backup of the Staging database and restoring it over the Test ...
1
vote
2
answers
50
views
Cannot restore log of MS SQL database that was previously TDE encrypted (but is not currently encrypted)
I've run into an odd problem with MS SQL Server. I'm working on automating deployment of TDE and want to be able to make sure that I can still do all the things I expect to be able to do with an ...
- 151
4
votes
5
answers
18k
views
Command line tool / script to backup a remote SQL Server database to local disk
I've been researching and googling for 10 hours and couldn't find anything, so I decided to ask here. I'm looking for a command line tool or a script (running under windows) that can backup a remote ...
- 483
0
votes
1
answer
440
views
MongoDB restoring to existing replica set (avoid creating a new one)
I have a MongoDB cluster runnning on 3 AWS EC2 instances, 1 for primary and 2 secondary nodes. I'm trying to perform a backup and restore without having to recreate the replica set. mongodump seems a ...
CommunityBot
- 1
0
votes
0
answers
103
views
SQL Server Differential Backup Size
The setup is SQL Server 2008 R2:
Full Backup - Weekly ~1.1TB
Differential - Every 4 hours ~66GB
Transactional - Every hour
What I want to know is why is the very first differential backup about ...
- 78.8k
47
votes
8
answers
91k
views
Is it possible to mysqldump a subset of a database required to reproduce a query?
Background
I would like to provide the subset of my database required to reproduce a select query. My goal is to make my computational workflow reproducible (as in reproducible research).
Question
...
0
votes
0
answers
28
views
Linux PostgreSQL backup single schemas + data into individual files
Is there a way to backup only the schemas (plus their relative data) of a PostgreSQL DB individually, into single dedicated files?
I'm on Linux CentOS 7, hopefully there's some way to automate this so ...
- 78.8k
0
votes
1
answer
324
views
error writing input to commandERROR: Invalid username and/or password
This is the error I have been getting on my RMAN notifcations on my backup jobs for the last day or so. The title is exactly how the message is formatted.
~~~End Step Output/Error Log~~~
Error Log:...
CommunityBot
- 1
0
votes
1
answer
1k
views
ORA-31626: job does not exist during schema export
I'm exporting schema with following command -
expdp system/system@xxx.xxx.xxx.xxx:1521/orcl schemas=schema-name directory=test_dir dumpfile=Schema.dmp logfile=SchemaLog.log
but it results into ...
CommunityBot
- 1
0
votes
1
answer
270
views
mysqlbackup failed with error when --use-tts option is used
I just found an interesting behavior when using the mysqlbackup feature to create a backup of a database and I'm wondering if I missed any steps or maybe a config that I missed or created a typo ...
CommunityBot
- 1
1
vote
1
answer
578
views
lock-ddl-per-table option not working as expected in Xtrabackup
I've recently been getting the following errors on some of my Percona XtraBackup backups:
InnoDB: An optimized (without redo logging) DDL operation has been performed. All modified pages may not have ...
CommunityBot
- 1
2
votes
1
answer
1k
views
Trying to restore a db2 database but stops at roll-forward with error 'SQL1265N'
I'm trying to restore a backup that is older than the current database.
The restore went ok, but the roll forward didn't giving the following error:
SQL1265N The archive log file ".LOG" is not ...
CommunityBot
- 1
5
votes
3
answers
563
views
PostgreSQL: Do regclass/oid columns persist across backups?
I have a large table (audit) in which I store relation ID of the schema and table.
This is conveniently populated by trigger using TG_RELID.
It is also convenient because I can index it and the index ...
- 439
5
votes
1
answer
1k
views
Full database backup using xtrabackup stream
I'm new to Percona XtraBackup. I've been trying to perform a full backup stream from my local ( test server around 600GB ) to remote server.
I just have some questions and I need guides, and I think ...
CommunityBot
- 1
0
votes
1
answer
785
views
Restoring schemas with the sequences
This evening a developer asked to restore only schemas from a database into another database.
A colleague of mine did this, but after that the developer came to me saying that the sequences are ...
CommunityBot
- 1
0
votes
2
answers
585
views
how to find backup history of SSAS database
Shockingly on Internet, I am unable to find backup history of SSAS database.
Is there no way to do it?
Also should we take multiple backups of SSAS database? I am not much aware of SSAS database.
...
CommunityBot
- 1
1
vote
0
answers
135
views
How do I use mariabackup to do point in time restores? [duplicate]
So I've read about the basic way that I can backup my mariadb using mariadb backup...
What I don't understand is how to make it point in time......
So I want to restore using mariadbackup full and ...
- 78.8k
2
votes
1
answer
4k
views
postgresql: Invalid data directory | Can't open PID file /var/run/postgresql/10-main.pid (yet?) after start: No such file or directory
This error is showing after running this command: sudo systemctl status postgresql@10-main.service
postgresql@10-main.service - PostgreSQL Cluster 10-main
Loaded: loaded (/lib/systemd/system/...
CommunityBot
- 1
2
votes
2
answers
489
views
Can't take backup to the shared folder
Need your help. My sql job is not able to take backup to the shared folder although the domain account, under which the sql agent service account is running, has full permission on that shared folder.
...
1
vote
1
answer
840
views
Troubleshooting RMAN-03009: failure of delete command on d1 channel
I don't have many experience about RMAN backup. I'm running backup daily level 1 incremental backup and weekly Level 0 incremental. Backup files will kept at 2 difference locations (each location one ...
CommunityBot
- 1
0
votes
1
answer
910
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 ...
CommunityBot
- 1
2
votes
1
answer
871
views
DPM transaction log backups of SQL Server partially contained databases
I am trying to use Microsoft System Center Data Protection Manager (DPM) 2016 (5.0.342.0) to protect SQL Server 2017 Standard CU8 (14.0.3029.16) on Windows Server Std 2016.
I have a named instance ...
CommunityBot
- 1
0
votes
1
answer
282
views
Does Percona Xtrabackup support RedHat release 4
I downloaded Percona's Xtrabackup rpm file for RedHAT. I attempted to install but hit into an error. The error seems to point to missing dependencies and libraries. I have no issue with RedHat 6 OS. I ...
CommunityBot
- 1
0
votes
1
answer
663
views
End of file reached. Error 38 in SQL. Passes verification checks
Having issues restoring a database in SSMS, error 38.
The databases are transferred up to google via their Drive API.
Download it on my side and has error.
If I transfer it through teamviewer ...
CommunityBot
- 1
2
votes
1
answer
247
views
Replicating into a Percona XtraDB Cluster
We have a 2 node (plus an arbiter) Percona XtraDB cluster. It is used for data indexing/archiving. It has it's own database called archive but it is also the replication slave for a database called ...
CommunityBot
- 1
0
votes
1
answer
398
views
LSN numbers query regarding Differential backups
We have the following backup regime in place which I am not 100% sure about.
Full backup each night at 18:00 taking approx. 6 hours
Transaction log backup upon completion of full generally about 10 ...
CommunityBot
- 1
0
votes
1
answer
1k
views
mysqldump waiting for table fush for long time
MySQL version: MySQL Commercial 8.0.16 OS: RHEL 7.6
Following is my mysqldump command
mysqldump --defaults-extra-file=/mysql_data/config/extra_options.cnf --single-transaction --flush-logs --master-...
CommunityBot
- 1
2
votes
1
answer
368
views
commitlog broken after standby setup with pg_basebackup [closed]
I'm trying to replicate a database with pg_basebackup in order to use it as standby server. But when I'm trying to start up PostgreSQL I get the following errors and the server shuts down again:
2016-...
CommunityBot
- 1
0
votes
2
answers
287
views
Does using the export option to backup a MySQL database (12GB size) cause any performance issues or locking on database?
I have a 12GB database. I want to take a compressed backup using the export option via phpmyadmin.
Does this cause any performance impact or locking on the database?
CommunityBot
- 1
1
vote
2
answers
1k
views
Dumping and importing with backslash
Background
I have a MySQL database, from which I run mysqldump for backups.
In this database, I have some fields that will contain some backslashes, and when dumping this, it will contain something ...
CommunityBot
- 1
0
votes
1
answer
575
views
could not read symbolic link error while executing pg_start_backup function in Postgresql DB
In order to take data folder backup in postgres 9.6 database executed the order of functions for backup,
while executing pg_start_backup function produced warning : could not read symbolic link for ...
CommunityBot
- 1
0
votes
1
answer
30
views
Would MySQL Replication (master-slave) have prevented this problem?
I'm new to the idea of MySQL Replication (mainly because I've never really had data important enough to have redundancy until recently). Today I had a random crash of my MySQL 8 database with the ...
- 73.8k
2
votes
1
answer
679
views
MongoDB Ops Manager backup and restore
The documentation claims that snapshots taken by ops manager are delta (differential) between successive snapshots.
How do you then restore?
I mean if you are able to delete some snapshots according ...
CommunityBot
- 1
1
vote
1
answer
490
views
MySQL Backup with innobackupex error: Unrecognized character \x01; marked by <-- HERE after <-- HERE near column 1 at - line 1374
Getting following error message:
Unrecognized character \x01; marked by <-- HERE after <-- HERE near column 1 at - line 1374.
170414 19:01:33 Connecting to MySQL server host: localhost, user: ...
CommunityBot
- 1
29
votes
4
answers
44k
views
pg_restore: [archiver] did not find magic string in file header
I'm using PostgreSQL 9.1 and want to restore backup files generated with pg_dump:
sudo pg_dump -h 127.0.0.1 -U postgres --clean --inserts -E UTF8 -f out.sql database_name
This command generates a ...
- 111
0
votes
0
answers
56
views
Backup taking longer time than usual in SQL Server
I have rebuilt huge table. After it my database is extended 1.3 TB to 1.5 TB. I don't shrink free space in data file because of it's impact fragmentation of index. After rebuilding process my daily ...
natiq rzazade
0
votes
2
answers
262
views
Restoring secondary backup files on primary server in sql server
I want to restore log backup file on copy-only full backup in restoring mode on primary replica server
these backups were taken from secondary replica .
I took copy only full back up on secondary ...
CommunityBot
- 1
3
votes
2
answers
1k
views
Percona MySQL 5.7 | XtraBackup 2.4 - xb_load_tablespaces() failed witherror code 11
I am attempting to upgrade MySQL from 5.6 to 5.7 and everything seems to be working, but when I try to run xtrabackup I am now getting this error:
InnoDB: Allocated tablespace ID 12 for percona/...
CommunityBot
- 1
2
votes
2
answers
572
views
Large MYSQL DB on single file
I have a large MYSQL innodb database (115GB) running on single file mode in MySQL server.
I NEED to move this to file per table mode to allow me to optimize and reduce the overall DB size.
Im ...
CommunityBot
- 1
0
votes
3
answers
751
views
How to hot-backup mysql slave database with read operations
I have a slave database of about 120GB in size on which application is performing select statements.
I also have a backup system (Acronis backup) available to me from a hosting company. Unfortunately ...
CommunityBot
- 1
0
votes
3
answers
920
views
The media family on device incorrectly formed for read only file group restore
Yes the databases (source and destination) are the same version. I have checked 3 times. Both are "Microsoft SQL Server 2019 (RTM-CU8-GDR) (KB4583459) - 15.0.4083.2 (X64)"
The database ...
CommunityBot
- 1
0
votes
1
answer
723
views
Barman: What's the best way to switch from backup_method postgres (streaming) to rsync (ssh)?
My production postgresql server is currently backed up with barman using the backup_method postgres (streaming server). I would like to switch to rsync method (ssh) to benefit from better compression. ...
CommunityBot
- 1
0
votes
1
answer
57
views
Cannot open backup device 'D:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\D:\DB_backup\uni.bak'
I have 2 database backup files casa.bak (25 GB) and uni.bak (176 GB) in the same folder. I'm using the same script to restore the database for both files previously both were working successfully. Now ...
- 27.4k
1
vote
1
answer
8k
views
NT SERVICE\MSSQL$SQLEXPRESS user cannot be found when added to network drive
For SQL Server 2016 Express, I would like to backup/restore directly to/from network storage I have mapped to drive S:. SQL Server Express runs under the (virtual?) account NT SERVICE\MSSQL$SQLEXPRESS ...
CommunityBot
- 1
0
votes
0
answers
18
views
Backup History in MySQL and PostgreSQL
What tables in MySQL and PostgreSQL keep a log of successful and failed backups? Similar to the backupset table in SQL server's msdb
1
vote
1
answer
290
views
RDS import from SQL backup
I'm migrating a SQL 2008 database from a corporate data center to an RDS intance on AWS.
So far I have performed a native backup which gave me a .bak file
Is it possible to simply upload this to S3 ...
CommunityBot
- 1