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

3
votes
2answers
278 views

SQL database backups methods-tools-procedures

Currently, I am investigating some way to more efficiently backup 4 Production SQL Databases (3 different servers/instances) and would like to know if anyone else has had the problems we are having ...
3
votes
1answer
2k views

SQL Backups - Full vs Differential vs Log Shipping

I'm looking to refine our SQL backups utilizing Full, Differential, and Log Shipping. Currently, I am only performing full backups once at night. This process is taking so long that it is running ...
3
votes
1answer
133 views

Thoughts about Oracle backup procedure for 11.2 (beginner question)

Two days ago we "found out" that our old, not taken care of, horribly neglected, Oracle DB server was extremely important to our business. The only person who knew anything about this server was ...
3
votes
1answer
2k views

PostgreSQL Scheduled Database Backup

For scheduling a daily back up on a postgres database we execute the following command: 0 2 * * * /usr/local/pgsql/bin/pg_dump -Fp -b -U database_name \ > ...
3
votes
2answers
362 views

Archive a single giant table from a SQL 2008 database - filegroup backup?

I have an extremely large table (400GB data size, inside a 2.5TB database) that is no longer needed. Before we drop it, however, our client contract says we need to archive it to tape in case in needs ...
3
votes
1answer
289 views

Xen snapshots and live Innodb tables?

I am wondering if I can trust my host doing it's nightly snapshots with live Innodb tables. From what I have read: "Innodb is ACID-compliant, so you can "safely" use fs snapshot with Innodb tables." ...
3
votes
1answer
176 views

Create incremental/differential backups in ProgressDB

Is there a way to create incremental/differential backups in ProgressDB?
3
votes
1answer
98 views

Are database backups specific to the OS on which they are created?

I am trying to get a better understanding of the behaviors of database backups for Sybase (15.X) and Oracle (11.x) as it relates to the underlying OS. Is the backup file OS specific or can it be ...
3
votes
2answers
1k views

Removing Archive Logs after PostgreSQL PITR online-recovery

I'm using pgpool-II + PostgreSQL 8.4 on three servers: primary + standby1 + standby2. Replication mode is "on" Load balance mode is "on" (between primary and standby1) I followed the official ...
3
votes
2answers
23k views

Expired archived logs not deleted from RMAN catalogue

If I issue a LIST EXPIRED command in RMAN, I see a list of files with expired status, that is, they exist in the catalogue, but not on the disk (verified by ls). After issuing CROSSCHECK and DELETE ...
3
votes
1answer
50 views

Best Design for this “Sweepstakes” Project?

Hello there fellow developers, Merry Christmas first aff all, and i hope you will have a happy new year soon. :) I was having more or less a problem with an idea that came to my mind. I am currently ...
3
votes
1answer
103 views

selective undoing of commited transactions in PostgreSQL

I have inherited a small (<1M rows) PostgreSQL DB which contains complex business rules split across several tables. Updates are very light, reads not so heavy, but the data is extremely valuable. ...
3
votes
3answers
5k views

PostgreSQL: How to backup only One Schema from a database and restore it on another server

I have a database named "A" which has two schemas "B" and "C". I want to backup and restore Schema "B" on a different server? not sure how to do this as I am new to Postgres. Do I have to create a new ...
3
votes
1answer
368 views

how to verify mysql backup file

Is There any tool to verify the backup taken using mysqldump without manual restoration ? I have to take full backup daily so it is difficult for me to verify the backups daily by restoring them. As ...
3
votes
1answer
1k views

Is it possible to use 'restore UNTIL SCN' with rman and Oracle 9i in NOCATALOG mode?

I'm trying to do a hot backup with rman that I can copy to a USB drive so I can recover it on a new server. The backup was done two days ago and the restore database command was working on the same ...
3
votes
1answer
546 views

SQl Server 2008 R2 - sa can login but not access database

Up until this morning I had no problems accessing our database. This morning, something has changed and I can no longer access our database (called EMS_Main) using the sa login. I can log into the ...
3
votes
1answer
8k views

Error 9001, Severity: 21, State: 1 The log for database 'DB_NAME' is not available [closed]

I have a SQL Server 2008 R2. I got a mail that the backup had failed, I opened the SQL log viewer and started browsing. And i found these two errors a bunch of times. error 1: Date ...
3
votes
1answer
901 views

Filestream database backup error

We have DatabaseA that has filestream files in it. We then have an archive process which first deletes files in DatabaseB (different server) and then inserts new files from DatabaseA into DatabaseB ...
3
votes
1answer
116 views

How do I back up On Premise Microsoft SQL Server 2008 to Azure cloud

I have a 50 GB hosted SQL Server database at SoftLayer. I want to do backups to cloud storage, as the SoftLayer managed SQL Server backups are ridiculously priced. Eventually we will totally move ...
3
votes
1answer
762 views

AG and SQL Backups

I am using always on in sql 2012 and have an AG setup. I would like to know if i were to backup the primary database and restore it would that be allowed without taking the cluster down etc. ...
3
votes
1answer
681 views

Wrong behavior in Backups

Checking my Native backup this morning something wierd happened. I will describe the problem here. 1) The msdb table backup set shows me the backup was done successfully. 2) The errorlog shows me ...
3
votes
1answer
2k views

Why is my postmaster process (sometimes) becoming unmanageable after a WAL base restore?

TL;DR: Un-stoppable, unusable postmaster is being spawned when Postgres is started right after restoring its data directory from a WAL base backup. Why? Context: We run postgresql 8.4, on CentOS 6, ...
3
votes
1answer
1k views

Script to Restore/Create SQL Server 2000 Database from Another Database's Backup

I'm trying to create a database, NewClientDB, by restoring another database's, OldClientDB, backup, d:...oldclientdb.bak. I've always done this via SQL 2000 Enterprise Manager, but the GUI keeps ...
3
votes
1answer
143 views

Does MySQL Enterprise Backup work across Operating Systems?

The problem with testing is that one can never be sure (it may seem to work and then you find some thing changed later). A definitive statement from the vendor would definitely be helpful (I cannot ...
3
votes
1answer
301 views

Transactional versus Merge Replication (Restore backup after downtime)

I have the following transactional replication setup: Windows Server 2008 with SQL Server 2008 Enterprise Server A: Master, has a database with a table, publisher Server B: Slave, subscriber ...
3
votes
1answer
208 views

PostgreSQL synchronized commit performance

I'm setting up a pair of PostgreSQL servers. Because cash is short I can only afford one high class server and some crapy backup box. If the expensive high end box should catch fire, operations can ...
3
votes
1answer
248 views

Remote Database Backup [closed]

I am attempting to find a reliable service that does remote MySQL Database Backup. Price is no object, unless it's absurdly expensive. I understand this question doesn't really have an answer, and I ...
3
votes
1answer
91 views

I can backup my SQL Server 2008 R2 but can't restore from the very same folder

I ran a backup into a folder. The Network Service has full control access to this folder. The backup process didn't work until I granted that account full control. I try to restore that same file but ...
3
votes
2answers
168 views

Can I run concurrent backups of multiple read only filegroups?

I have 62 readonly filegroups in a SQL server 2008 enterprise database. Can I backup multiple read only filegroups at the same time? I would assume this to be the case but given this database is over ...
2
votes
3answers
5k views

Copy PostgreSQL data from one PC to another

I am migrating my server application from the existing system to another system. Unfortunately, the existing system is also the database server. It has data stored. Is it possible to copy this data to ...
2
votes
4answers
180 views

Using Mirroring for incremental backups?

We have a machine tool application that runs on a SQL server backend. These tools run all day every day and I am looking for a way to incrementally backup the database without any machine downtime. ...
2
votes
4answers
4k views

SQL Server: cold backup, shutting down services?

One of our collagues told me that they are doing "cold" backups for SQL Server so that they are shutting down services and then taking a backup somehow. I think this is all wrong! Am I right? I think ...
2
votes
3answers
308 views

Is it possible to have 2 backup plans for a single database?

Is it possible to have two backup plans ? allow sysadmins to have their own SQL Server 2008 set of backups for a database allow DBAs to have their own separate backup plan We have had issues with ...
2
votes
3answers
185 views

Reasons to Backup (or not backup) QA and Dev Databases

Pretty simple question: is it standard/best practice to backup dev and QA instances of the database? Assume that the schema information is kept in some form of source control.
2
votes
2answers
104 views

Advice about Backup Solution

Our database Server is being hosted by another company. They provide a file level backup that occurs once per day. They also allow for Log Shipping. My company is taking advantage of their ...
2
votes
2answers
127 views

How do I pull a backup of an oracle database so I can send it to a vendor

First of all, I know squat about Oracle databases. A vendor who is looking at converting our data from an older piece of software with an Oracle DB back-end wants a dump of our database to see what ...
2
votes
4answers
474 views

MySQL Database Poisoning: How to recover to a known state quickly

If you want to avoid database poisoning (ie want to recover back to a point-in-time quickly) which methodology do you prefer? Let me define data poisoning. You insert some things in your database ...
2
votes
2answers
204 views

Transaction Log Backups

I am working on backup+recovery scenario and I came across a situation where I could not figure out how I would have to deal with it. We have couple databases where sometimes there may not be any ...
2
votes
1answer
1k views

Multiple versions of SQL Server on the same development machine

I am consolidating some SQL Servers to simplify administration. I am thinking about a new VM with SQL Server 2005/2008R2/2012 each as a separate named instance on the same machine. This machine will ...
2
votes
2answers
59 views

Viewing the SQL of a view from a backup set

I have a full backup of my database from 4 days ago. It is a standard SQL 2008 .bak file. What I'd like to know is if its possible to view the SQL to a View that is in the database I backed up without ...
2
votes
1answer
4k views

Does mysqldump -all-databases include all objects

Does mysqldump -all-databases include all objects ? I have to migrate all databases to new server.
2
votes
2answers
162 views

Why isn't the transaction log getting truncated when taking a full backup?

In full recovery model, if we take a full backup, the log file is not truncated. It is done when we take a transaction log backup. Any particular reason of why it is done this way?
2
votes
2answers
1k views

Move (Restore) SQL Server 2005 database which does not exist before

I did not ready about this but found out after trying to restore a database from remote server and it wont restore if the database did not exist before. What I would do is create a .bak file ...
2
votes
2answers
2k views

SQL Server 2008, switching to simple recovery mode

Currently our transaction log is 50 GB; impressive huh? I want to switch to simple recovery mode and remove the transaction log entirely. Do I need to stop any user activity and detach the database. ...
2
votes
2answers
230 views

Backup of database X on SQL Server 2008 on server A - restore to SQL Server 2012 database Y on server B

I want to copy a SQL Server 2008 database to SQL Server 2012 with a different database name. Took a backup of 'production' and copied it to the SQL Server 2012 machine. Created a new SQL Server 2012 ...
2
votes
2answers
63 views

What is the purpose of BACKUP WITH NAME?

I looked at the Microsoft documentation (http://technet.microsoft.com/en-us/library/ms186865.aspx) and see that there is a WITH NAME option for backups. But it's not the name of the file (I specify ...
2
votes
3answers
12k views

SQL Server 2008 Database Restore Error - Cannot open backup device 15105

I am trying to restore from a backup and getting the following error Msg 3201, Level 16, State 2, Line 1 Cannot open backup device 'Z:\FULL_BACKUP.bak'. Operating system error 3(failed to ...
2
votes
2answers
250 views

Does RMAN in Oracle only copy the archive logs? What happens to the active redo log in case of failure?

If RMAN copy copies the archived redo logs when they are full, what happens to the current redo log in the event of a failure (hardware failure, etc.)? Isn't there always an active redo log that is ...
2
votes
2answers
10k views

How to take Oracle backup and restore?

I am coming from SQL Server background where SQL Server studio has a very easy way of taking database backup and then doing a restore. I have been using Oracle 11G express edition for past couple of ...
2
votes
2answers
277 views

Can I move a system database from one version of SQL server to another?

We are moving our databases from one computer running SQL Server 2005 to a different machine running SQL Server 2008. I am following the steps found here, in an attempt to copy over the master ...