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)

4
votes
1answer
245 views

Full or bulk-logged recovery model?

My database is about 10 GB and I use full recovery model. Sometimes I have to add a lot of data at once and during that time, I change the recovery model from full to bulk-logged. What do you ...
6
votes
2answers
172 views

Understanding Backup Types

I have recently started a role as a junior DBA... Yesterday I created a new database for a co-worker and my boss asked me to make sure we get a backup plan on it asap. I didn't think much about it, ...
0
votes
0answers
25 views

MySQL Enterprise Backup

Hi I've been looking for MEB version 3.12. But it seems the Oracle's eDeliver does not have this version. The available version is 4.0.xxx. I need this older version because my MySQL server version in ...
4
votes
2answers
81 views

SQL Server backup medianame

If I make full/differential/log backups to disk under full recovery model it is important to specify MEDIANAME? Is it true that MEDIANAME is only for tape backups? If not, when and why should I ...
0
votes
1answer
25 views

SQL Server backup media set and file separation

SQL Server backup media set and file separation If I am going to do such a backup plan under full recovery model for a particular database Weekly full database backup Daily differential backup ...
1
vote
1answer
58 views

What can become a reason of database failure? [closed]

I'm the new one with SQL Server, so, please don't beat me. It's known that one of the best ways to protect your database from the failure is to make regularly scheduled backups. But my question is: ...
3
votes
2answers
1k views

Archive Logs filling up Flash Recovery Area (FRA) space

I got hired to fill a position of DBA that I wasn't quite ready to fill, and while the training is getting me there, I am running close to a potential issue. My oracle 11g database's Flash Recovery ...
5
votes
1answer
117 views

dumping database with “compressed data is corrupt” errors

I'm using pg_dump to dump a large (396 GB) PostgreSQL database: pg_dump --clean --create mydatabase After running for a day, a statement fails with ERROR: compressed data is corrupt and pg_dump ...
1
vote
0answers
20 views

How to restore InnoDB from files

here is the situation I fu*d up my mysql setup, before I did that I copied entire /var/lib/mysql directory to another location. Now fresh installation of mysql is back and I cannot restore my files. ...
0
votes
3answers
11k views

Can't backup a Postgres database: FATAL: Peer authentication failed for user “postgres”

I can connect to my database no problem remotely, either from PHP scripts on our webserver or using PGAdmin3. Unfortunately, when I try to run pg_dump backups locally on the server itself, I get: ...
1
vote
2answers
50 views

System Databases Integrity Check & Full Backup

I have an SQL Server 2008 and for maintenance solutions I use Ola Hallengren scripts. Recently, out of 15 databases I have on this server, I made two changes in three of them (not system databases, ...
0
votes
1answer
26 views

What service that lets you create records/data into an immutable database storage system that cannot be deleted?

I'm not sure if this exists or not, but is there a database storage system that is immutable, whereby it cannot be erased or be altered without someone knowning? Use case would be for public data that ...
-2
votes
1answer
57 views

I have created a zip file using 7z for backup but its taking time to open [closed]

I have created a zip file using 7z for backup but its taking time to open. Any possibility of making fast. Please suggest me.
1
vote
3answers
49 views

Should a MySQL slave used for backup also be used to service read-only requests in a production environment?

Based on best practices, I'm wondering if we should have at least one slave that's used solely as a backup server, without servicing any forward-facing requests from users. For example, if we have a ...
2
votes
3answers
185 views

Automated regular tests of your backups

I was doing some investigation on how other DBAs go about performing automated regular tests of their database backups to ensure recoverability in case of disaster and I'm quite disappointed at what ...
1
vote
2answers
62 views

Checkpoint during Backup

Can database process make automatic checkpoint when I'm in process of copying files during ALTER DATABASE BEGIN BACKUP; and ALTER DATABASE END BACKUP; You can assume that process of copying ...
2
votes
2answers
61 views

Index Defrags during a Full Database Backup

What are the performance drawbacks when running an Index Defrag during a Full Database Backup? Is there a way to pause/stop an Index Defrag when a backup starts? I utilize Reorganize when frag is ...
1
vote
1answer
87 views

Why the backup file size is much larger than the restored database [closed]

I got a 18.3 GB .bak file, when restored, the database size is about 78 MB, including logs (54MB). restore filelistonly from DISK = N'E:\xx.bak' BackupSizeInBytes 23068672 0 I understand that the ...
1
vote
0answers
37 views

Backup creating fork_point

I have a powershell script that is restoring from production into a test availability group database. It copies the full and t-log backups from production to test, takes the target db out of the ...
1
vote
2answers
58 views

My Ola Hallengren nightly backup job failed but It works fine when I execute the job manually by right clicking

I have been using Ola Hallengreen maintenance plan . It has been working great for longtime . Recently one of my nightly backup job failed repeatedly with an error: Sqlcmd: Error: Microsoft SQL ...
1
vote
0answers
58 views

mongodump monitoring (with exit codes)

This is how we monitor backups with mongodump. Exit code and mail if not 0. Mailing is reliable in our environment. mongodump -h $RANDOM_SECONDARY -u $BACKUP_USER -p $BACKUP_PASSWD --out ...
2
votes
1answer
83 views

Why SQL Server Express 2012 take automatically backup in “Virtual Device” without virtual device configuration?

I have noticed that after migration of SQL Server 2012 Enterprise to SQL Server 2012 Express, every day it shows "spurious" virtual backup after taking manual backup of database. When I execute this ...
1
vote
0answers
47 views

Export sql azure DB as bacpac file without including data for certain tables

When I export a sql azure database as data tier application from sql server management studio I get the option to tick off certain tables but then these tables are not included in the resulting file. ...
2
votes
1answer
37 views

Backup on both secondaries or a dedicated backup secondary

In my current replica set setup, I have a a primary and 2 secondaries (both a normal secondaries - priority 1 on each, no delay, no hidden). Note that reads and writes are only against the primary. ...
5
votes
1answer
225 views

Run Transaction Log backups only during Work hours?

Currently we have a number of databases that are in full recovery model. This is a conscious decision. We also run the transaction log backups every 15 minutes. But we run the transaction log ...
15
votes
3answers
886 views

Database disaster prevention [closed]

My database is larger than 250GB. I make scheduled backups with a third party Tool. Are schedule database backups the best way to protect SQL Server database from corruption? Or can you recommend ...
1
vote
1answer
63 views

SQL Server Backups on DataDomain

Our sysadmins keep pushing us to use data domain and DD boost for taking our SQL Backups. Has anyone successfully used this solution? I know what Brent Ozar says about Data domain and sql backups. ...
14
votes
5answers
17k views

.bak file not visible in any directory in SSMS

I have a .bak file created today by someone else, manually created through SSMS 2008 R2. I'm trying to manually restore the database, unfortunately the file isn't appearing when I go to browse it. I ...
-1
votes
5answers
249 views

I do not understand SQL Server Transaction Logs

I understand that a Microsoft SQL Server Database has two components: A database file A transaction log file Whenever I make a change to a table, does it get written to both the database file AND ...
15
votes
4answers
6k views

Is it possible to backup and restore part of a database in sql-server?

We have a sql-server 2005 database that we regularly transfer from our client site to ours. This takes a long time because we don't have a direct connection and have to transfer the file over their ...
3
votes
2answers
55 views

Enabling SQL Instant File Initialization when Restoring to a Network Path

We have a large Read Only SQL DB (SQL 2012) that we’re restoring to a NAS as a current duct tape solution. I had wondered why the restore process seemed to be hanging. Part of my guidance along the ...
1
vote
0answers
47 views

Database Restore info not logged to msdb..restorehistory

I have 4 databases on a secondary server two of which are using Sql Server log shipping and two of which are using a "manual log shipping" config (there are just 2 primary databases). Both ...
1
vote
1answer
54 views

SQL Server Database backup regressed to historical date

I have the following code snippet that takes backup of my production database every night - use My_database go checkpoint go use [My_database] go DBCC SHRINKFILE (N'my_db_log', 500) go backup ...
1
vote
1answer
41 views

Copy database to a remote server on daily basis

I need to replace the copy of my PROD db in a DEV system on a daily basis. The problem is that I haven't enough space in my DEV system to restore the PROD db. Is there any way to create a shrinked ...
2
votes
1answer
33 views

Replace content of only one table with new version (should disable foreign keys?)

I have 2 tables. 2nd has foreign keys to reference 1st. I need to replace the whole content of the 1st table with the new version from another database. The new version satisfies all constraints and ...
2
votes
1answer
51 views

Backing up database with missing datafile

Is there a way to backup a Oracle 12c database which has a missing datafile? I dont have backups. Database is running in archive log mode. One of the data files is physically missing from the disk. ...
2
votes
1answer
111 views

How do you configure Postgres 9.4 for incremental backups and hot standby?

I want to set up Postgres to do incremental backups. I'm using PostgreSQL 9.4 on Windows with a database that weighs about 1GB and has a growing 10000 records each day. I understood that the steps ...
0
votes
2answers
3k views

Backup plan for MySQL NDB cluster databse not innoDB

I have a Database which will grow more than 250GB all data is in NDB engine(2 datanodes) and no other mysql engine used for data store. What are the best approaches or plans for MySQL Cluster NDB ...
3
votes
1answer
99 views

Mongodb incremental oplog Dump not working

I am not able to take an incremental oplog dump. I am not getting any error messages the connection happens fine and also there is a operation recorded(shows up in db.currentOp()), but still nothing ...
3
votes
1answer
817 views

SQL Server 2012 - Large backup file size

We have the following setup: Once a week (Sunday at midnight), a full database backup is performed. A new BAK file is created for this purpose, let's call it Backup1.bak. From then, a transactional ...
2
votes
1answer
232 views

SQL Backup issues / Operating system error 995

Last night backups of some databases failed. Backups are being performed using CommVault. Below is error message in SQL Server logs 01/05/2016 ...
1
vote
1answer
74 views

Simplest filesystem backup of Postgres database

Situation: A backup system performs filesystem-level daily backups on a server containing a large but fairly static PostgreSQL 9.2 database. The filesystem backups are incremental and generally take ...
-1
votes
2answers
65 views

Database BackupSize has Changed after migration from SQL Server 2012 Exterprise to SQL Server 2012 Express [closed]

I would like to say that after migration of MS SQL server 2012 Enterprise to MS SQL Server 2012 Express. I have seen there is some subtle diffence in DB backupsize as well as in "LSN" of all ...
8
votes
2answers
191 views

How many backup devices is recommended to improve backup performance?

In order to improve performance of our SQL Server backups we backup to multiple backup files. On most blog posts about this topic they say to use multiple backup files but, is there a point where ...
1
vote
0answers
18 views

How to merge MySQL backup files (*.sql) [duplicate]

We have several MySQL backup files of a database in *.SQL format and we want to restore the database by using these files. However, as the sql files contains "DROP TABLE" definitions, running one ...
1
vote
0answers
17 views

Automatic incremental backup of MySql on windows

I have three Mysql Servers, Server-1, Server-2 and Server-3 all running on Windows. I have to configure Master-Master replication on Server-2 and Server-3. But Server-2 has to be a mirror of ...
4
votes
1answer
363 views

Oracle crashing on CentOS

Here is alert_XE.log: kkjcre1p: unable to spawn jobq slave process Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_cjq0_23146.trc: Process J000 died, see its trace file kkjcre1p: unable to ...
2
votes
1answer
80 views

SQL Server Database Migration - Backup/Restore while Original DB still in Production

I have a very large DB in full recovery mode. My SQL Server is 2008 R2. The thing is that I need to migrate to a new server while having the original DB still in production. Both backup and restore ...
4
votes
1answer
60 views

How to extract the structure out of DB2 (Back up Structure)?

Is there a way in db2 to take a backup of the database structure (Metadata) without actual data? My purpose is to pull structure (tables, views, indexes, triggers, procedures and functions) from an ...
-2
votes
1answer
56 views

Backup file from SQL Server 2012 to 2008 [duplicate]

I have a backup file of SQL Server version 2012 but I want to restore that backup on SQL Server 2008. Question: Is this possible ?