Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

learn more… | top users | synonyms (1)

0
votes
2answers
18 views

What is the best way to backup logs and shrink logs in SQL Server 2008 r2?

What is the best way to shrink and backup our db logs? I have seen many DBAs that do it : ALTER DATABASE [mydatabase] SET RECOVERY SIMPLE DBCC SHRINKFILE(<log_file_name_Log>) ALTER DATABASE [...
0
votes
2answers
22 views

Transaction Log Backup Cleaning [duplicate]

If you back up your transaction log every hour through a maintenance plan, why does your log file continue to grow? I would think the system would delete or shrink the log after the backup. Is this ...
0
votes
0answers
12 views

Exadata: how to backup system before upgrade rpm packages?

My PCI scanned found some vulnerabilities on my Exadata. I must upgrade glibc package. Before that I want to backup the system not to ruin something. By which tool can I backup OS? I used acronis, ...
0
votes
1answer
136 views

SQL Server : how to decide if FULL backup or DIFFERENTIAL

The following scenario (on SQL Server 2008 R2 and 2012 servers) A co-worker of mine restored another DB into the one our process was trying to create a differential backup for. As I am currently only ...
1
vote
2answers
325 views

Cannot open backup device Error

I have a SQL Server Agent job that backs up a database on a remote server to a network drive. Linked Server, I believe is set up correctly but I get the following error: Msg 3013, Sev 16, State 1, ...
0
votes
0answers
13 views

NT SERVICE\MSSQL$SQLEXPRESS user cannot be found when added to network drive

For SQLEXPRESS 2016 I would like to backup/restore directly to/from network storage I have mapped to drive S:. SQLEXPRESS runs under the (virtual?) account NT SERVICE\MSSQL$SQLEXPRESS as it should, ...
0
votes
0answers
10 views

Java Library to Dump MySQL Database to File [on hold]

I am looking for a Java library to embed into a Java web application to enable backup of a MySQL database to a zip file. The first question would be why not use MySQL dump, this is an option that we ...
0
votes
1answer
28 views

MySQL Backups - Full vs incremental - innobackupex

So I'm implementing a backup strategy for our project and came across some text which I need absolute clarification, false positives are the death nell of IT. I am looking to do your typical backup ...
2
votes
1answer
470 views

mysqldump vs mysqlpump

I just heard about mysqlpump - it looks like it was released with MySQL 5.7, however MySQL 5.7 still includes mysqldump. They're both backup programs, but could anyone summarize the main differences? ...
0
votes
1answer
25 views

Why does restoring postgresql database from dump produce errors

I did the following commands: pg_dumpall --clean | gzip > db.gz gunzip db.gz psql < db I expected the third command (loading the database back) to just run with zero errors, but I got some ...
2
votes
2answers
20 views

Concurrent backups (full and transaction) and testing recovery model

My intent is to test my recovery model and setup log shipping to replicate a database on another server. I have a database called AdventureWorks on a primary sql server. Presently SQL Backup performs ...
0
votes
2answers
125 views

Which files in the “MySQL-5.0.27-win32” folder do i need to backup?

Ok, I am using a pretty old MYSQL "mysql-5.0.27-win32" and the file and the structure maybe different from the latest Mysql (mysql 7). Here is the current structure of of mysql-5.0.27-win32: In "...
1
vote
1answer
53 views

Percona: Backup preparation doesn't work (“cannot open ./xtrabackup_logfile”)

I've created a MySQL backup with PerconaXtrabackup tool via (thanks to this guide): innobackupex --user=backupmysqluser --password=xyz --compress --stream=xbstream ./ > /var/backups/db/firstBackup....
0
votes
1answer
22 views

RMAN Control File Information

I have daily full backups going on for my Oracle 12c databases on linux. Daily retention on disk is 6 days. This is what happens: Full backup happens at location /orcl_bkup/backup_full After ...
3
votes
1answer
759 views

How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?)

I have 2 seperate SQL databases on the same SQL instance. Database1 references tables on Database2 in its views and stored procedures. Everything was working fine until we had to create a fresh ...
1
vote
0answers
49 views

Progress of mongodump operation jams at a random point

We are executing remote mongodumps to backup collections. For some time now sporadically one of these dumps stops to progress any further and remains to log out the same amount of documents processed ...
3
votes
1answer
49 views

Any disadvantage to automatically changing FULL backup on AlwaysON Secondary to COPY_ONLY?

I've been playing around with Ola's maintenance scripts recently, and they are absolutely great. However, I was considering one scenario and was surprised when I found it wasn't catered for. Maybe I'm ...
0
votes
0answers
22 views

Why does SQL Server Managed Backup create so many full backups?

I have a SQL Server 2014 database with Managed Backup configured to send regular backups to Azure storage. It's been happily churning out log backups for months now that provide full coverage for the ...
0
votes
1answer
121 views

SQL Server BACKUP WITH FORMAT

When doing a SQL Server database backup using the T-SQL BACKUP statement, does WITH FORMAT only wipe out the specified Media Set or does it wipe out all Media Sets 'associated' with the database? ...
0
votes
0answers
19 views

Is VSS Backup a better solution than the native backup?

Since i started to work as a DBA, i'm making normal backups ( with scripts, ad hoc and etc ). What would be the better solution for a backup? lets say I need to migrate a 2tb database to development ...
1
vote
1answer
220 views

mysqldump collation issues

I have tried my hand at building a shell script to backup our wordpress database using tar balls and chron jobs on a Debian environment. The problem I am facing now is that our wp database after ...
1
vote
0answers
41 views

SQL Server 2012 AvailabilityGroups - Preferred Backup Replica

I currently have a 2 node SQL Server 2012 HA Availability Group setup. Currently we have a number of SharePoint databases that exist in this availability group. I'm attempting to ensure our backups ...
0
votes
1answer
44 views

Restore of database failed .bak file SQL Server 2008

I have faced following error during restoring database: TITLE: Microsoft SQL Server Management Studio Restore failed for Server (Microsoft.SqlServer.SmoExtended) ADDITIONAL INFORMATION: ...
2
votes
1answer
121 views

backup to NAS using sqlcmd

I've been searching for possible duplicates before asking but can't find anything. The closest was Backup SQL Server To Nas but not exactly my case. We have a brand new Synology NAS configured, due ...
0
votes
2answers
22 views

PITR restore in postgresql

I need to perform incremental backups and restore those backups in postgresql. So in order to achieve this i setup wal-archiving as follows. wal_level = archive archive_mode = on archive_command = ...
0
votes
2answers
539 views

Extract one MySQL database from a FULL MYSQL Server backup file

I have a small shared windows server on which i'have installed MySQL 5.1 engine for hosting my user's mysql databases. I backup the complete MySQL databases each day by running this script as batch ...
10
votes
4answers
680 views

Using third party tools to backup

Is there any advantages to use Third Party Tools to make Backups ? I'm not referring one in particular but I want to know if someone using them to DB greater than 200 GB. Servers are mostly MSSQL ...
0
votes
1answer
323 views

WordPress MySQL writes during “Flush Tables With Read Lock” are rejected instead of being queued

I'm running into an odd issue when setting MySQL into a brief read-only mode for backup. Reads continue fine during that "read only" minute, but writes are just rejected instead of being queued to ...
0
votes
1answer
29 views

Incremental backup in postgresql in windows

I am developing an application with postgresql as backend. So my requirement is to take the incremental backup either hourly or daily basis. I have gone through many related articles (like https://...
2
votes
1answer
45 views

Trying to restore SQL file from mysqldump, results in syntax error

I ran the following sqldump call in a MySQL 5.7 instance (Windows OS): mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=1 --routines -A > ~/dump.sql I ...
1
vote
2answers
128 views

Alternative for taking the backup of SQL DB's on backup drive

We just got new servers to take care of, regarding their backups, handed over by the company B who used to manage the backups, but they never did via any mant'ce plans or SQL jobs.They did that task ...
16
votes
4answers
29k views

How do I move SQL Server database files?

I have a database and want to move the .mdf and .ldf files to another location. But I do not want to stop the MSSQLSERVER service, and I do not want to export to another server. How can I do this?
1
vote
0answers
46 views

Backup command wait long for completion of CHECKPOINT

I executed simple query to backup my 189GB database on a server with 32GB RAM. BACKUP DATABASE DB_NAME TO DISK='D:\BACKUP\FILE1.BAK', DISK='D:\BACKUP\FILE2.BAK', DISK='D:\BACKUP\FILE3.BAK', DISK='D:\...
1
vote
1answer
199 views

PostgreSQL WAL recovery not working due to missing WAL

I am using pgBarman for PITR recovery. Now it's a bit of a crisis, because the Barman backup and the WAL archive seems like it cannot be recovered. We're running PostgreSQL 9.3.6 and latest stable ...
3
votes
1answer
50 views

How to Load Balance Availability Group

I have 2 Servers under SQL Server Cluster (Server 1, Server 2) 2 Databases configured with Availability Group (Database 1, Database 2) Server 1: Database 1 PRIMARY REPLICA Database 2 PRIMARY ...
9
votes
3answers
24k views

What is the use of “Backup set will Expire:” option while creating Backup Database task in Maintenance plan

While backing up the database, I would like to use "Backup set will Expire:" option to delete/overwrite old database backups. I am not able to use this option. Any advice on how to use "Backup set ...
0
votes
0answers
19 views

Necessity of backing up tail log when restoring transaction log?

I have a question about whether or not it is necessary to back the tail log up when performing a restore of a database in Full Recovery mode. I've sprawled for a good while now, and have gotten ...
1
vote
1answer
36 views

Scheduling backup jobs for an Availability Group

In a MS SQL Server 2014 AlwaysOn AG setup, I would like to schedule backup jobs for a given availability group. The ultimate goal is to have the regular backups run on the synchronized secondary and, ...
1
vote
1answer
33 views

SQL Backup with Mirror option in maintenance plan

I need to do backup ALL databases on an instance and put them in 3 different locations on our network, so i found that you can use backup with mirror, so I set that up. I have a maintenance plan ...
0
votes
1answer
143 views

PostgreSQL : Master-Slave replication strategy and solution for 3 servers.

We have currently 3 servers(X,Y,Z) running Debian X64, two of them host projects(Y,Z), which don't require that much database, as they serve more static content, but the third server(X) is largely ...
3
votes
2answers
131 views

Automating an SQL task on a monthly basis

At the start of each month I have to give a team a copy of the live database which is held in a backup from 1am each morning (D:\Backup) - We then copy this database elsewhere onto a dev server and ...
3
votes
4answers
85 views

Is mysqldump a “hot” backup kind?

I see in the documentation that the database backup tools are divided into four categories: hot backups, cold backups, physical backups and logical backups. I understand the the most important ...
0
votes
0answers
22 views

How can I open .SBF or .SBD files?

I need to read some .sbf and .sbd files but I don't find any software for it. I have downloaded FileViewPro but when I try to open .sbf file, appears an error. A lot of thanks for your assistance
0
votes
1answer
60 views

How to do 10 G Database recovery without archive logs but available redo logs, ctl files and .dbf files

My client's Oracle 10g database crashed abruptly on Win 2003 NT. The oracle was installed on C drive and redo logs, ctl files and .dbf files were in D: It was unable to backup C: but successfully ...
3
votes
1answer
31 views

Issue with running multiple mysql commands in a bash for loop

I try to restore some .sql backups using a shell script with a for loop. I run by bash command.sh 'password' using the command.sh below. However, when I typed it out, it didn't run and instead, mysql ...
1
vote
1answer
49 views

How to restore MySQL databases from database files?

Our MySQL on Ubuntu 15.04 stopped working after we moved the computer to a new location and kept giving the missing socket file error. We couldn't really fix it after trying sudo apt-get install -f ...
1
vote
2answers
453 views

Recommendation about mysqldump?

I have approx 90 GB sized database, and I need to schedule a mysqldump backup. How long will it take to perform a full hot backup approximately? I'm asking because I've never had to backup a database ...
0
votes
1answer
34 views

Is it possible which documents couldn't be dumped using “mongodump”?

I am removing historical data from a collection in MongoDB (3.2), but first I need a backup of it. The choice has fallen, a simple combination of: mongodump --db myDatabase --collection myCollection ...
3
votes
3answers
306 views

Hyper V replication - vs - sql replication solutions

I need to establish an offsite copy of a number of production servers, including SQL server. Hyper V replication has been chosen as a simple solution (all servers are virtual). This is to supplement ...
1
vote
2answers
304 views

SQL Server hangs during backup on EC2

Once and then our SQL Server will "hang" during its weekly full backup. When this happens, external connections start to timeout. The symptoms are: Connections timeout The sqlservr.exe process sits ...