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
1answer
96 views

SQL Server Backup Failure

This one has me stumped and I'm sure there is a simple explanation that I cannot fathom at present. A few informational pieces: vCentre Database - SIMPLE Recovery Model SQL Server 2008 R2 Standard ...
1
vote
1answer
19 views

Does local.oplog.rs hold all data in mongodb replication?

I'm trying to do backup full and incremental backup, I wonder does local.oplog.rs collecitons contain all info that I need to do backup and incremental backup?
0
votes
0answers
16 views

Cost efficient SSD/ HDD plan for learning about RAID? (SQL Server) [closed]

I'm trying to learn more currently about backup/ recovery processes when it comes to running SQL Server databases. I have a stack of books and courses I'll be going through shortly. Although I have ...
0
votes
1answer
14 views

How to use variables in a mongodump query

I want to backup data of last day (Current Day-1) every day using cron tasks. In the mongo shell, I can query the data using variables as below: var start = new Date(); start.setHours(0,0,0,0); ...
3
votes
5answers
132 views

Restore a database with a different name on the same server

I need a copy of a live database called Carers on the same server for testing purposes. The test database name will be Carers_Test. I took a backup of Carers using SSMS. And tried to restore it using ...
0
votes
1answer
185 views

Percona Xtrabackup fails to backup InnoDB table with fulltext index

I'm trying to make a backup of a large InnoDB table with a fulltext index using Percona Xtrabackup (2.4.12). I have innodb_file_per_table set. To create the backup, I'm running: innobackupex --...
1
vote
2answers
69 views

Backup files - Are they safe to delete?

I've got a back up process which initially writes to a local disk, then the disk gets backed up remotely. After each back up (log, diff and full) I'd like to delete all the files on the local disk. ...
0
votes
1answer
437 views

BACKUP Detected Corruption in the database log [closed]

I took a backups of a few db's on server A (2008R2), Then restored it to server B (2012). One database had TDE enable, so I disabled it, took a back up then proceeded to server B. The other database, ...
1
vote
1answer
64 views

problem with the restored database

I have a database storing user login credentials of my application in a Table. When I backed up and restored my database to another server, the restore is successful but the login is timing out (SQL ...
1
vote
2answers
103 views

To Backup or Not To Backup Test Databases [closed]

Introduction This question is explicitly asking for answers based on experience to allow me to make a decision based on the experience of fellow database administrators in similar situations. This ...
1
vote
1answer
13 views

Can I do a backup without extension functions?

I use the PostGIS extension on my database. The thing is when I do a backup and then a restore, all the PostGIS functions give a warning during the restore process, because the functions already exist,...
1
vote
1answer
27 views

How to take backup of multiple DB in a specific point of time

My test setup is having 3 databases in postgresql-9.6 instance, 2 DBs consumed by 2 live Web apps. I am using pg_dump to take hot backup of all databases. In order to keep CPU load under threshold, ...
70
votes
5answers
94k views

MySQL any way to import a huge (32 GB) sql dump faster?

I have this huge 32 GB SQL dump that I need to import into MySQL. I haven't had to import such a huge SQL dump before. I did the usual: mysql -uroot dbname < dbname.sql It is taking too long. ...
0
votes
2answers
43 views

Initial Full Backup required for Filegroup Backups?

I'm assuming that an initial FULL BACKUP is required if I am taking FILEGROUP backups and would like this confirmed. Many examples show one at the start, but don't make note that it is explicitly ...
0
votes
1answer
27 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-...
1
vote
1answer
82 views

Full backup of Simple recovery model - how much log is backed up if there is an open transaction

I have a situation right now. There is a database in SIMPLE recovery model. Note: 1. Compression is not enabled which will be enabled pretty soon. 2. SQL Server 2012 SP3 BackupSize: 8GB (Usually)&...
0
votes
1answer
88 views

Having two data folder in my postgresql setup- Postgresql

I am using centos 6 and installed Postgresql_9.4 using the following commands yum install postgresql postgresql-contrib postgresql-client pgadmin3 yum install postgresql-server After that i ...
0
votes
1answer
118 views

MySQL backup of incremental changesets

With a MySQL database, is there a way of logging and/or backing up incremental changesets? We have a number of large databases (100-200 GB), for which we take daily backups using mysqldump. These ...
-1
votes
1answer
23 views

Copying a Filemaker Database running with an ODBC Connection

Work has a custom Filemaker Pro application, and it has an ODBC connection for the company website to access. I want to migrate the FMP database into a MySql/MariaDB database to tinker on Schema ...
0
votes
0answers
7 views

Postgresql strange backup message with docker

I'm trying to backing up my remote PostgreSql database into the local one. The backup command is the following: docker run --rm -e PGUSER=user -e PGPASSWORD=password -e PGDATABASE=db -it postgres:11....
0
votes
1answer
115 views

MySQL - Backup new and modified entries only

I am developing a very huge system in Java using Hibernate and MySQL. Now, I want to automate the daily, weekly, and/or monthly replication (backing up) of the data that are stored from the database ...
1
vote
1answer
28 views

RMAN Restore Validate time equals to actual restore time?

I'd like to know if the time to restore the database is equal the time using restore validate database. If not, How can I know how much time the restore will spend?
3
votes
1answer
63 views

Skipping VM backups for high workload SQL Server?

For those who have virtualized SQL Servers with very high volume transaction workload (very high rate of data change), I am curious how you handle VM backups, or if you even do them. Of course, I ...
0
votes
1answer
47 views

MySQL database backup plan

I have a MySQL database that is about 17GB in size. Right now we don't have a backup for this and I have been tasked to look into backing it up automatically. I am a software developer myself, not an ...
0
votes
1answer
11 views

Assigned filetype for backups not applying

I am working to migrate backups over to a new storage point. I figured the easiest thing to do was to duplicate the configuration over from the existing Maintenance Plan to a new one, just in case ...
-1
votes
1answer
251 views

Restoring more than one .bak files in a TSQL query

Can any one share a script that will allow me to restore all the .bak files in my one folder into SQL Server using a TSQL script?
0
votes
1answer
155 views

Transactional Replication initialize from Backup Issues

I implemented Transaction Replication (pull subscription with distributor at subscriber) with initialize from backup. It was working good and today when i checked replication monitor,it shows error on ...
0
votes
1answer
111 views

Restore user db from UNC

I need to create a job that restores all user databases from UNC to my SQL Server. All the backups, for 3 days, are located in the same folder and I need to restore the last modified backup. What is ...
5
votes
6answers
17k views

Backup database directly to FTP server

Is it possible from SQL Management Studio to create a backup directly to an FTP server? Basically, instead of choosing the destination to a disk, I sould like to be able to specify an FTP location (...
0
votes
1answer
21 views

Daily SQL Server Alert: BackupVirtualDeviceFile::SendFileInfoBegin: failure on backup device

I'm running a ~100Gb database on Microsoft SQL Server 2016 (SP2-GDR) Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor) Every weekday night just after 7pm I ...
2
votes
1answer
126 views

MySQL replication backup

How to take MySQL Master-Master and Master-Slave replication backup?. I have setup Master-Master replication with a separate slave for each master on Ubuntu. What happens if, I issue or schedule ...
0
votes
3answers
5k views

Restore database according to editions

I wanted to know that, can I restore backup of SQL Server 2016 Standard edition database into SQL Server 2016 Express edition database. Or vice-versa
0
votes
1answer
31 views

RMAN log file with date and name in Oracle 11gR2 in Linux

I have a script and I want to create my log file with datetime and with unique name. It's my script: ....... ....... rman target/ LOG='/u01/backup/logs/rman.log' <<EOF ....... ....... ....... ...
-1
votes
1answer
131 views

Incomplete dumps using mysqldump

I am running Mysql server with master and slave replication. From past few days i found that backups on my master server are incomplete. When i ran manually on master it's returning the below error ...
2
votes
2answers
67 views

How can I backup my large SQL Server table?

Environment: SQL Server 2008 R2 Standard Edition on Windows Server 2008 R2 (yeah - I know). VMWare, Commvault. We have a 1.4 TB DB with one table. Here is the schema: CREATE TABLE [dbo].[...
6
votes
3answers
9k views

Unable to create restore plan due to break in LSN chain

My backup plan is: Full backup - once a day Differential backup - every four hours Transaction Log backup - every 30 minutes. All database backup are stored on my computer. I add some wrong ...
1
vote
1answer
27 views

Cannot take backup into NAS storage at specific time

I have a job which runs every 30 minute and takes t-log backup of the database suing Ola's script. Every Thursday and Friday at 22:45 I get an error: 11/07/2019 22:45:00,Backup,Unknown,Error: 3041<...
0
votes
1answer
122 views

Log Shipping Server Restart Problem

I have Log Shipping setup from Primary Server A to Destination B. Server B is both Destination and Monitoring server. Yesterday, we restarted both servers around the same time for patching. On the Log ...
3
votes
1answer
31 views

Log error restoring old database to SQL Server 2017

I am trying to migrate a database from an old SQL Server 2008 R2 to SQL Server 2017. The database was originally 2000 and thus has a compatibility level of 80. Initially I took a full database backup ...
1
vote
0answers
25 views

What All Is Factored Into A MySQL Checksum? (Why Could They Be Different?)

I'm currently going through the excruciating task of moving MySQL databases from one shared web hosting environment to another. This has been a multi-month battle (and I'm learning a lot). After ...
0
votes
0answers
11 views

Barman backup fails: reconnection not allowed

Several barman backups failed due lost connection. Is is possible to configure barman to retry backup in such case? barman show-backup psql01a 20191109T040008 Backup 20191109T040008: Server Name ...
1
vote
4answers
138 views

How to prevent a full database backup

We are in the middle of migration, a full backup has been taken and copied to the destination. On Friday, we plan to do a differential backup, but someone has by mistake taken another full backup (did ...
1
vote
1answer
41 views

can I do a restore controlfile from autobackup out FAST RECOVERY AREA?

I know that I can issue the command restore controlfile from "location_here". But there is some config that can I do for issue the command restore controlfile from autobackup even whether the ...
-1
votes
1answer
90 views

Postgres pg_dumpall failing

Recently on my debian server with postgres 10.6, pg_dumpall has started to fail with the following error: su - postgres -c pg_dumpall | gzip > /temp/directory/postgres_backup.gz pg_dumpall: query ...
0
votes
1answer
143 views

Text file report is not generating of Availability Databases other Databases during auto backup through maintenance plans in MS SQL Server 2012

I have setup Automated backup in SQL Server 2012 Enterprise Database backup through 'Maintenance Plan'. I have also configure AlwaysOn High Availability to that server .There is 5 databases in the ...
2
votes
2answers
140 views

Corruption in mariadb binlog

I have an installation with mariadb version 10.0.21. I need to backup the binlog file every 5 minutes to TSM, but as the binlog is being written every second, i am afraid of the file getting ...
1
vote
1answer
158 views

SQL recovery model for ADFS deployment

We have "AdfsConfiguration" and "AdfsArtifactStore" databases for our ADFS deployment. I keep running into disk space issues due to the full and transaction log backups being taken on the server. ...
2
votes
1answer
1k views

Issues with mysql enterprise backup, assertion failure on restore

I'm trying to restore a backup to a new server, but having some issues with corruption. The source server has a 2.5T table which is very active. I copied the latest backup over to a new server and ...
2
votes
3answers
113 views

Regarding Backup and Restore Strategy

I have some questions regarding backup and restore strategies. I want to take backup and restore of large databases approx. 60 to 70 GB and it is a critical database on SQL Server. Backup schedule ...
1
vote
2answers
31 views

Restoring Postgres from only base backup taken with wal-e

I have a postgres base backup taken via wal-e. Is it possible to restore and start the DB with just the base backup? I cannot use the restore_command in recovery.conf since the wal files are archived ...