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)

7
votes
1answer
125 views

Can SQL Server be configured to backup to a network share through a separate NIC?

We're in the process having our SQL Server instances backup to a network share, but our network admins want to try and divert the bandwidth from the backups through a different network segment. I was ...
1
vote
0answers
102 views

DB2 TSM Archivelog backups missing

New to DB2 on AIX currently running V9.7 Using TSM to backup the database with the command: db2 backup db (db name here) online use tsm include logs When I run the backup it finishes without ...
1
vote
1answer
161 views

DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?

I read about ROLLFORWARD option on link http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001978.html?cp=SSEPGG_9.7.0%2F3-6-2-4-106 but I could not find ...
0
votes
0answers
37 views

Timeout expired error when database is being backed up in SQL Server 2012

We have daily full backup scheduled at 8.30 AM. We are getting Timeout expired when we try to access a web page using the database being backed up. The web page has several select and few ...
1
vote
1answer
67 views

Database backup issue in SQL Server

For security reason I always took back up of my database. I took full backup in each month. And differential in each week. I used to save each back up file in different name. I lost my latest full ...
0
votes
0answers
22 views

Restore databases from prod to test server with data over say X days in SQL Server 2005

We've got a list from app owners to restore say 20 databases from a total of 100 available production server databases onto a test server on weekly basis. Moreover, they require it in a way that ...
1
vote
0answers
52 views

Backup terminating abnormally [closed]

Does anyone in the community know which SQL-Server 2014 CU will fix the issue of a backup terminating abnormally and causing a stack dump. This SQL-Server instance was an upgrade from 2012 to 2014 ...
0
votes
1answer
40 views

Maintenance plan to backup differentials hourly each to a new file name in SQL Server 2012

In addition to a nightly full backup, I'd like to set up an hourly differential backup maintenance plan in SQL Server 2012, where each differential backup file should receive a different name. It ...
1
vote
1answer
129 views

DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option

I do restore command of backup image which was made 03.03.2015 at 19:20: db2 restore database maxdb71 from "/data/archiveBackup" taken at 20150303192002 without prompting; Then I try to do the ...
1
vote
1answer
158 views

DB2 - question regarding RESTORE OFFLINE backup and Archive Logs

I configured last night DB2 to be in Archive Mode. I created required offline backup at 23:00 last night. First online backup will be created at Friday night. Archive logs now keep coming to the ...
-4
votes
2answers
476 views

Incremental backup in SQL Server [closed]

I got a task for backing up my clients data through internet. Client has about 50 GB of data there. So I need to back up the data and pass through internet, but it takes about 8 to 9 hours for this ...
0
votes
0answers
44 views

Restore database from tape error 15105, cannot open backup device

I'm using HP Data Protector software to backup my SQL databases. When i try to restore a database from tape i get the following error. When i click on script, it says this: RESTORE DATABASE ...
0
votes
1answer
71 views

Restoring SQL Server database on another box

I have a SQL Server database that is running these scripts to create backups. It's running full backups once a week, daily differentials, and hourly logs. These are being FTPd to another box where I ...
0
votes
0answers
49 views

PostgreSQL 9.3.5 database restore error : plpgsql already exists

I have a .net program to restore a PostgreSQL database backup. What it is doing is 1) Delete the existing database. 2) Create it again. 3) Initialize some variables/properties. 4) Restore the ...
0
votes
1answer
42 views

Is it possible to backup my ubuntu postgresql database by copying the /var/lib/postgresql/9.1/main file and pasting it back in?

A developer working on my server has fiddled with some settings and knocked my postgresql database offline. I've been messing with it for an hour and am considering just reinstalling postgresql fresh ...
3
votes
1answer
162 views

Transaction log backup file larger than expected?

I've recently taken over a SQL Server database that didn't have any transaction log backup routine running for at least 2 years. The first log backup was very large (3.8 gb on a 1.14 gb database) as ...
3
votes
1answer
67 views

Tool for quickly backup and restore a table

Is there a tool for quickly backup and restore a table's data, preferably to a csv file? It would be best if I could do it using batch. Run a .cmd file and data is backed up into a file with datetime ...
0
votes
0answers
81 views

Daily backup with mysqldump

I want a periodic MySQL database backup, but I don't have permission to access ssh. When I try to run mysqldump via command line in Plesk Scheduled Tasks, it only creates a blank file 0 kb sized. I'm ...
-1
votes
1answer
39 views

SQL Server database backup file is successfully created in a path but no such file path is available in my local machine

When I tried to take backup of SQL Server database, it was successfully created in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\ but no such path is available on my local ...
1
vote
1answer
43 views

Differntial back up: what happens to existing data?

Ok, this is a question borne purely from paranoia. But i want to ask all the same. If I make changes to a db, and then apply a differential back up at a later date, what happens to the changes I ...
1
vote
1answer
167 views

SQL Server differential backup LSN values

I'm looking at restoring databases on SQL Server and I'm not understanding something related to the LSNs. Here is a screenshot from the Restore Database dialog in Management Studio for a sample ...
3
votes
2answers
240 views

When does creating a .sql backup with mysqldump become too large?

Is there a limit to how large a database can be when executing a .sql backup using mysqldump, or will you run into server problems before that - will the server not be able to take such a large backup ...
1
vote
0answers
20 views

How to group SQL Server files for restoring database [duplicate]

I have a SQL Server database that is creating full backups once a week, differential backups once a day, and transaction log backups hourly. These are being FTP'd to another box, where I would like an ...
0
votes
0answers
155 views

Where is the SQLS database backup virtual device string stored in the system tables?

In my SQLS Server 2005 log, when backups occur, I see something like: Database backed up. Database: blahblah, creation date(time): 2011/08/11(15:49:19), pages dumped: 1, first LSN: 142:489:1, ...
1
vote
1answer
259 views

ONLINE BACKUP is not performed from the CRON Job on LINUX server (manually it works)

I made a script which executes successfully online backup when it is run manually by the instance owner. Script is the following (two lines originally). #!/bin/bash /opt/ibm/db2/V9.7/bin/db2 ...
3
votes
1answer
64 views

Full to Simple recovery mode during massive data update?

I`ve got a 50 Gb database, in which a table takes up 43 GB, and it's full of bad data(over 90%), and i plan to clean it. Database is in Full recovery mode. My plan is: 0 - take a backup for safety ...
0
votes
1answer
71 views

DB2 - What is the difference between online backup and AUTO_DB_BACKUP?

We would like to perform online backup. I see that there is one parameter AUTO_DB_BACKUP. I read this article on IBM link for AUTO_DB_BACKUP ...
0
votes
2answers
768 views

DB2 ARCHIVE mode - Can all archive logs be deleted after doing the FULL OFFLINE backup?

I am interested in one thing, if I understood correctly. DB2 is in Archive mode (online backups are made and archive logs keep coming which is OK). If I made offline full backup today and I know I ...
0
votes
1answer
88 views

How to delete the old backup differencial files?

I'm (trying) managing a large number of sql server instances among a number of machinces running SQL Server 2005 and 2008. Almost all the DB are in Simple Recovery Model. I'm doing full backups every ...
1
vote
1answer
31 views

Instant File Initialization on Backup drive

I know IFI (Instant File Initialization) is good to have enabled on SQL Servers. How about backup archive locations? We backup our DBs to a local SSD drive (so it backs up quickly), then throughout ...
1
vote
1answer
46 views

Percona: Do I need apply-log switch for a weekly full backup and hourly incremental?

I am planning a script to work on our percona. Our strategy is to do full backup weekly but incremental backups every day/hour. I have read innobackupex manual and got confused further as to whether I ...
0
votes
1answer
254 views

Best practice for archiving old data? [closed]

We are migrating 3 slightly different SQL databases into one (SQL Server 2008R2). We want to keep old databases "alive" for some period of time but once we've gone live we don’t want staff ...
1
vote
1answer
72 views

Shrink log file after configuring backups properly

I had a database that was working in FULL recovery mode but never had transaction log backups done. The consequence of that was the fact that the log file kept growing and now its 10 GB in size. I ...
1
vote
1answer
77 views

Backup a remote database, from my machine, to another server (SQL Server 2008)

I'm trying to backup a database, of a remote server, from my machine, to another server. SERVER1 >>> BACKUPSERVER \ / \ / \ / ...
0
votes
2answers
71 views

Is possible to backup database online using rsync?

Some people tell me that the backup database on-the-fly using rsync is possible. I think it is possible but not safe because some log, buffer... is not flushed. Database is being recovered from the ...
1
vote
1answer
52 views

SQL server compress backup for lower version databases

Recently our development team migrated couple of sql server 2000 Databases onto SQL2K8R2. Now we creating the backup strategy, and just had a doubt, that: 1) Compatibility level of those DB's still ...
0
votes
0answers
26 views

Does automated backup performance suffer if backup completion time exceeds the backup window?

Is there anything "special" about the Amazon RDS Automated Backup Window, or is the backup window merely an arbitrary timespan in which the backup is expected to complete? That is to say, if I have ...
0
votes
0answers
82 views

Restore MySQL DB from mylvmbackup to .sql dump

Backups of MySQL innodb databases are taken using mylvmbackup and the resulting backup contains the whole mysql folder as per example below: ibdata1 ib_logfile0 ib_logfile1 mysql/ mysql_upgrade_info ...
1
vote
1answer
111 views

Oracle Hot Backup Theory

After a hot backup, where all tablespaces are placed in backup mode seperately; i.e. alter tablespace user_data start backup; each datafile will have a different Checkpoint SCN in its header; with ...
3
votes
0answers
83 views

Database corrupt after restore and upgrade on another instance

Just wondering, if someone faced the same issue. We have got a SQL Server 2008 R2 (10.50.2789) and SQL Server 2014 (12.0.2000) and there is a process of backup on MSSQL Server 2008 R2 and restore on ...
0
votes
0answers
24 views

pg_dump in 1G VPS crashes

I'm trying to run pg_dump on a relatively small database (2G), but pg_dump keeps crashing with an out of memory error. du -h --max-depth=0 9.4 1.9G 9.4 The command: pg_dump -Fp -h "$HOSTNAME" ...
2
votes
2answers
122 views

Backup compression in SQL server 2008R2 and above

Recently we got a new server to take care of and found that there are two data drive: S: 1 TB where resides 10 databases(mdfs and ldf's, though they should be on different drives but that's how we ...
1
vote
1answer
966 views

pg_restore: [archiver (db)] could not execute query: ERROR: schema “public” already exists

I am using pg_dump / pg_restore to backup and restore a PostgreSQL database, but am getting some error messages (and a non-zero exit status) from pg_restore. I tried a super simple base case (outlined ...
0
votes
0answers
34 views

What exactly should I backup in MongoDB when using replica sets?

I have several instances of MongoDB replica set servers with a primary and a failover machine for each replica set. The primary machine makes daily backups by creating an LVM snapshot and copying all ...
1
vote
2answers
346 views

Restoring an Oracle Backup Properly

I've been trying to do a proper restore of a database for weeks now and I'm convinced that I'm doing something simple wrong. I took a cold backup of the database before an update to an application ...
1
vote
0answers
64 views

Setting up a new db-server with same name and ip. Backup/restore or detach/attach

I'm planning to set up a new Win 2012 server, with SQL server 2014 standard. This server is going to replace our current server, Win 2008R2, with SQL server 2008R2. The name and ip is going to be the ...
1
vote
0answers
134 views

Backup and FTP SQL Server databases

We plan to backup our SQL Server 2012 databases every night, FTP the backup files to our test servers and restore them. Then deploy the latest schemas to those databases. The reason for this is so we ...
0
votes
1answer
106 views

PostgreSQL SELECTs not returning correct result following recovery?

I took a copy of the current database from a live slave using pg_basebackup and recovered it to a brand new isolated computer following the instructions in the docs. Once the new database had started ...
0
votes
1answer
165 views

Rman controlfile and rotation

I got an Oracle 10g server with a bash script running every night which extract each datafile and create an rman script, which is launched from the bash script itself and make backups. CONFIGURE ...
0
votes
1answer
20 views

Is this normal binary logging behaviour - maintaining one ever growing file despite expire_logs_days?

I have a Percona MySQL DB running on a dedicated server. I have in my.cnf # REPLICATION # log_bin=/var/lib/mysql/binlogs/mysql-bin expire_logs_days=7 My issue is that the log file mysql-bin.000001 ...