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
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 ...
2
votes
2answers
78 views
Incremental backups - differences
What is the differene between:
BACKUP INCREMENTAL LEVEL 0 DATABASE;
and
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
? I read some manuals, but I don't get the idea beacuse of my poor ...
2
votes
1answer
258 views
How to write a shell script to check the mysql database backup status.
I have mysql production databases running in main server(Linux) and from this server every night the backup is taken into local server.
Now i want to find a shell script to check if all the databases ...
3
votes
1answer
78 views
Is it imperative that I backup my index files?
I have a few different instances (SQL 2000, 2005) with indexes placed in a separate filegroup. Do i need to ensure that this group is backed up, or will it be rebuilt by a restore of of the database?
0
votes
2answers
261 views
Creating a test database from Production database (different machines & servers)
I'd like to set up a test database on a separate server. Production database is MS SQL Server and the test server is a *nix box so I'd like to have the test server running either PostgreSQL or MySQL.
...
3
votes
1answer
123 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 ...
2
votes
1answer
180 views
What happens if we copy neo4j's data folder while the server is running?
If my neo4j server is running and I copy the data folder using copy/rsync folder, what are the chances of data corruption?
3
votes
1answer
443 views
MySQL Server Backup
I was wondering if there was any way of making a backup of an entire MySQL Server at regular intervals to a specific location. (If the version is required I can get it easily).
If there is, I must ...
1
vote
1answer
864 views
Full and differential restore with two backup files - SQL Server 2008
We are trying to establish a maintenance plan with 2 separate backups.
One full backup over the weekend and differential backups through the week. [the differential backup has a "_diff" appended to ...
1
vote
1answer
319 views
Backing up an Oracle 10G Express on Windows 2000 Server
Oracle 10G Express installed on Windows 2000 Server Enterprise Edition.
I am trying to automate backups and on Oracle's website I have found the following documentation.
...
4
votes
3answers
158 views
What methods are available to create a snapshot of an oracle database for testing purposes?
I am new to databases and have just been assigned to work with Oracle. We want to create a snapshot of the database for testing purposes that will allow us to revert back once we're done.
I'm a bit ...
5
votes
2answers
169 views
Performing data update operations while backing up a large SQL Server database
I have a large (in the tens of millions of records) database that I am going to perform a full database backup on.
However, the database is large enough that transactions can start before and during, ...
0
votes
1answer
560 views
How to Create Snapshot Backups in MySQL
I've seen a lot of people talking about snapshots backup, even I'm reading a book about mysql but nobody explain the code how to make a snapshots backup. This is what the book says:
flush tables ...
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 ...
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 ...
1
vote
1answer
2k views
Problem with View When Restoring a MySQL Backup
I have a database (InnoDB) with some tables, views and routines...
Periodically I do a backup using the command line:
mysqldump -u user -ppassword --routines db_name > backup.sql
But I have a ...
4
votes
4answers
552 views
Do I really need to keep .LDF files?
Each month we make an end of month snapshot of our production databse. These month end snapshots are strictly for reporting purposes, there are no inserts, updates or deletes ever done on them. Each ...
2
votes
1answer
502 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 ...
2
votes
1answer
117 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 ...
1
vote
2answers
323 views
Backup database and clean old backup question
Right now we have a maintenance plan which looks like this:
backup all databases
clean old backups (> 24 hours)
This job runs every day.
Every now and then this script crashes during backup step ...
3
votes
2answers
428 views
Difference between backup methods: Oracle and MySQL
I was reading that Oracle databases have cold, warm, full and redo backups.
Questions
How is it possible that MySQL doesn't have as many options?
I have read that MySQL has cold backups (it puts ...
1
vote
2answers
238 views
Oracle Databases - need to export nightly for backup/DR purposes
I know nothing about Oracle databases, so if my question's path seems odd, feel free to tell me the right way to do things.
I have 2 ways I see currently that I can backup a server running 3 Oracle ...
2
votes
2answers
320 views
In trying to setup back up device, net use command throws operating system error 53 when passing in a unc
So I'm trying to use XP_CMDSHELL to set up my drive for using a backup. I already have the drive mapped, but per ...
4
votes
3answers
672 views
RSync Database File Deltas in SQL Server 2008
Alright, I feel like this is a terrible idea, but I need some help understanding why this is bad:
I'm still working on implementing a disaster recovery/business continuity solution for our ...
2
votes
1answer
102 views
Availability Strategies in MS SQL Server 2008
I need some assistance in developing a backup strategy for my SQL Server deployments. Currently I have two classes of customer: Hosted customers, whose data is housed in our datacenter, and On ...
2
votes
1answer
175 views
Initial recovery Postgres with backup in sync commit mode
I've got a master and a slave postgres 9.1.3 database. I would like to init the backup database for the first time.
I did the following steps:
Stopped master
Copied all files to Slave
Create ...
3
votes
1answer
96 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 ...
4
votes
1answer
119 views
Copy a SQL Server 2000 database to another box without interrupting the backup chain
I have a small-but-important MS SQL Server 2000 database that I'd like to copy to a development box. I understand that the usual way to do this is to make a copy of a full backup file, and restore ...
1
vote
2answers
118 views
Is this an appropriate development environment MySQL backup strategy?
I'm a web developer and I use primarily my own laptop at work. We use an SVN repository for our project codebases, and deploy our changes to an internal development server for testing.
Our system ...
2
votes
1answer
119 views
SQL Server asks for 100GB for a dump with 1GB
Is it acceptable that SQL Server asks for 100GB free disk space to restore a 1GB dump file?
If no, what should be parameterized?
2
votes
2answers
265 views
Notification mail not sent on failure
Currently we are having problems with our backups, specifically disk space issues. On investigation it seems the notification mail isn't being sent when the job fails. This is a weird issue as a ...
1
vote
2answers
446 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 ...
0
votes
2answers
2k views
Opening a .backup file for PostgreSQL
I'm going to warn you that whoever explains this needs to talk to me like I'm five years old, because this is something way, way beyond my level of expertise.
In short, I have what I think is a ...
5
votes
2answers
427 views
How to automatically stagger transaction log shipping to minimize bandwidth usage peaks?
The following question pertains to Microsoft SQL Server transactional log shipping (TLS).
We're using SQL Server 2008 R2 SP1, although the question is probably relevant for all recent editions.
...
3
votes
1answer
718 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 \
> ...
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 ...
6
votes
1answer
101 views
When you back up a database and scripts are running at the same time, at what point in time does the backup reflect?
If I run a SQL Server database backup via Management Studio and there are scripts running at the same time, does the backup reflect the point in time when the backup was started or when it ended? My ...
3
votes
1answer
452 views
How to backup a MySQL database without slowing the application?
I'm an application developer and wondering about our database backup strategy. Right now our sysadmins backup our database every 8 hours. I don't really know how the do it, but while the backup is ...
1
vote
1answer
69 views
Where and with what should I be looking for a good hardware backup tool?
Until now, I was doing my SQL Backups using USB Hard disk, and copying that to my local computer. After that, I went zipping and burning onto DVDs.
Now I want to push that on more professional and ...
6
votes
1answer
279 views
PostgreSQL Complete Database Backup
I've been trying to figure out how I can completely backup my PostgreSQL database.
I have not seen any resource that explains how to do a complete backup.
I am aware of the pg_dump and pg_dumpall ...
1
vote
3answers
141 views
Database growth causing issues sending backup over network
We take a full database backup on our primary SQL Server, and send that file over our network to a remote site where it is recovered on a backup SQL Server. We use this backup database for slow ...
5
votes
2answers
776 views
SQL Server backup, attach to BAK file?
I have a SQL Server database with a full text index. When I created the app that uses it, I made a backup of the database and I ship the .BAK file with the app. As part of the app install it does a ...
3
votes
2answers
199 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 ...
-4
votes
5answers
2k views
Safely deleting a SQL Server log file (.LDF)
I can make sure my app is in a consistent state.
I can rollback all the uncompleted transactions if any (just in case) it's ok
I can DETACH the database
What do I need the log file for after that?
...
1
vote
3answers
235 views
Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?
We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set ...
0
votes
1answer
56 views
Is it possible to tell the source of a backup?
I was wondering if it is possible to tell the difference between backups created manually and backups created through a maintenance plan.
There does not seem to be any way to discriminate them in the ...
1
vote
1answer
449 views
How can I change default backup location for oracle11g using RMAN?
I want to change to another drive due to lack of disk space.
How can I change the default location of backup files used by oracle to another drive using RMAN?
By default it's in the folder ...
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
1answer
231 views
Postgresql revert back database value
I have postgresql database.
My table name is tblvoippolicy. Now, problem is by mistake i have deleted some records from table.
When I get the data file using following commands.
select * from ...
3
votes
1answer
228 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."
...
