Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
3
votes
1answer
239 views
How can I restore SQL Server database to a custom location, if the backup file was renamed?
Suppose I have an SQL Server database called bubu and the respective backup file is bubu.bak.
If I want to restore it with the backing store in a custom location, I use the following T-SQL statement:
...
3
votes
2answers
3k views
How can I backup & restore a single FILEGROUP in Sql Server 2008
Previously, on ServerFault I asked a question about backing up and restoring a Sql Server 2008 Filegroup.
Today, when I tried to RESTORE one of these FILEGROUP backups, I got the following error:-
...
3
votes
1answer
86 views
SQL availability groups log maintenance
I have a AG with 2 nodes in a site in sync mode and 1 offsite in async mode. I'm having trouble understanding how the logspace is maintained in this scenario. For instance, I'm taking log backups ...
3
votes
1answer
89 views
SQL Database automatic back up
I have an SQL database - I need to back it up everyday (at a minimum) - preferably multiple times a day - automatically so it definitely gets done.
I'm running Windows which the SQL database is ...
3
votes
1answer
83 views
Backup and off-site restore setup
I've been reading a lot of threads about different backup options for MySQL and was hoping for some more insight so I can settle on one.
Our current situation is ~100 GB of InnoDB and MySAM data in ...
3
votes
1answer
161 views
Oracle 11, incremental backup goes wrong
Got a pretty big instance on a one-week backup cycle with an incremental (differential) strategy .. or rather, that's what it was supposed to be. Somehow the daily differentials seem to come out as ...
3
votes
2answers
178 views
Backup VLDB replicated database in SQL Server?
I have a problem with my backup strategy.
Currently I'm doing a Full Backup every night and transaction log backup every 2 hours to TAPE.
This used to work without problems, but the size of the DB ...
3
votes
2answers
525 views
Quick MySQL Backup
I have a database which is grown to 3GB and it has 3 MyISAM tables. And I have 4GB RAM. What will be the best (quick) way to backup this database without any performance lack.
Or mysqldump will work ...
3
votes
1answer
447 views
Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio
I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS instance using the master account I created when creating the database ...
3
votes
1answer
206 views
Backup a database with a huge number of tables
Is there a way to backup a PostgreSQL database with a huge number of tables?
An attempt with pg_dump for a database of about 28000 tables resulted in the following error message:
pg_dump: WARNING: ...
3
votes
1answer
1k views
Is Percona xtrabackup the right choice for my 500GB MySQL backup?
I have a MySQL db with 500GB, consisting mainly of Innodb tables, and one big (200GB) MyISAM table. My current backup strategy is copying the db files to an external harddrive. This causes a downtime ...
3
votes
1answer
232 views
Microsoft SQL Server 2008 R2 backup error
I'm trying to do a simple backup to an external disk and getting this error:
Backup failed for Server 'Server-name'
Additional information:
System.Data.SqlClient.SqlError: The media loaded ...
3
votes
2answers
143 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
716 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
198 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
227 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
98 views
Create incremental/differential backups in ProgressDB
Is there a way to create incremental/differential backups in ProgressDB?
3
votes
1answer
2k views
RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?
I have the following situation:
Backups of DB1(located on srv1 server) database are taken everyday at 1:00 AM.
I took backed up files(datafile,archivelog,controlfile,spfile) of 24/10/2011 and ...
3
votes
1answer
87 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
579 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
1answer
192 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
161 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
53 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
356 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
767 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
466 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
83 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
122 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
95 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
427 views
Quick MySQL Backup (1 file per table)
I asked a relevant question few months back and got answer with wide variety of options for backup.
But this time I have different scenario and I have got a database with 7 tables and 1 of them has ...
3
votes
1answer
9k 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
0answers
92 views
What are the best practices for backing up a secured SQL Server 2012?
I want to state right off the bat that I'm not looking for information on how to backup a SQL Server. I've got that taken care of.
I'm looking for some form of documentation that will tell me the ...
2
votes
3answers
626 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
3answers
375 views
How can you save all user-defined functions to txt files on your local hard drive?
I am running SQL Server 2008 and need to back up the UDF scripts/queries that I have created. How can this be done in a timely manner? I tried right clicking on the folder icon where the UDF are saved ...
2
votes
4answers
2k 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
4answers
85 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
2answers
75 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
3answers
148 views
Performance impact of Splitting Table across files
EDIT: I think the original question (below) was not worded very well, and probably caused confusion. The basic question is:
If I have a SQL Server 2005 database using a single .mdf file and I change ...
2
votes
2answers
98 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
358 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
122 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
161 views
Set Backup Compression on SQL Server 2008R2 on by default
I can't seem to find the option to set the server property that will enable compression on SQL database backup to be ON by default, so I don't have to manually set it every time.
Ca anyone point me ...
2
votes
2answers
1k views
Saving SQL Server backup file in multiple parts
I am taking daily backups of a SQL Server database. Right now the .bak file is about 2GB and it is growing day by day. There is a scheduled job is running which moves this .bak file from one location ...
2
votes
2answers
179 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 ...
2
votes
2answers
1k 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
130 views
How to compare the database of a backup from another environment
Has anyone had any luck with taking a backup (approx 30 tables) from an Oracle database's live environment, then loading a test environment with this backup and doing a comparison between the test ...
2
votes
2answers
48 views
How to backup IBM DB2 Database online?
I tried to backup the IBM DB2 (LUW) Database using this command:
./db2 backup database DBEMP to /home/user1/db2bkup
But I got this message:
SQL1035N The database is currently in use. ...
2
votes
2answers
115 views
Is it OK to use WITH INIT for my Transaction Log Backup to avoid having it grow too large?
I'm still struggling to understand SQL's backup jobs.
We currently have a SQL Server 2005 instance using the FULL recovery model.
We do a full database backup every week.
BACKUP DATABASE ...
2
votes
1answer
149 views
Only a single WITH MOVE clause should be specified for any logical file name
I'm trying to do a copy database by scripting a backup and restore. I have the backup procedure working correctly but I keep getting the error
Conflicting file relocations have been specified ...
2
votes
2answers
1k views
Restore Database script
I have a live database which i would like to create a backup and restore script that will take the "live" database every night, create a back, then drop the existing "testing" database (if any) and ...
