Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
1
vote
1answer
1k views
Difference between database dump (export) and database backup?
What is the drawback using only EXP command for a database dump (and considering it as a backup) instead of taking backups using BACKUP DATABASE command (via RMAN)? What is a difference between ...
1
vote
1answer
312 views
Postgresql WAL Archiving, How to do it properly?
Basically I have one (for now) mission critical postgresql database that I will need up to the minute recovery for, I've never implemented a working WAL archival before so I would like to know what 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 ...
1
vote
3answers
662 views
SQL Server 2005 Restore from Full and Differential Backup
I'm not a DBA, however I have been a developer for 10yrs and am competent.
I wish to move our corporate application to a hosted service and I need to copy the data. The data centre is too far from ...
1
vote
1answer
785 views
mysql db backup excluding specific tables
Are there any mysql scripts for taking a database backup, while excluding specified tables?
Also, what is the best way to take backup of a running mysql system?
Regards,
Praveen
1
vote
1answer
137 views
Copy database schema from SQL Server 2008 to SQL Server 2005 [duplicate]
Possible Duplicate:
Downgrading from SQL Server 2008 to 2005
Is it possible to copy the database schema from SQL Server 2008 to SQL Server 2005,
I don't need data from the tables, just ...
1
vote
1answer
126 views
Oracle Backup/Recovery architecture
When we write the following:
allocate channel ch1_tape type sbt;
set controlfile autobackup format for device type sbt to '%F';
restore controlfile from autobackup;
RELEASE CHANNEL ch1_tape;
By ...
1
vote
1answer
288 views
Oracle Backup and Recovery
My backed up archivelog file format is 'al_%U'. During recovery it shows the following error:
RMAN-06054: media recovery requesting unknown log: thread 1 seq 17 lowscn 671075
How to determine which ...
1
vote
1answer
58 views
How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?)
I have 2 seperate SQL databases on the same SQL instance. Database1 references tables on Database2 in its views and stored procedures. Everything was working fine until we had to create a fresh ...
1
vote
1answer
24 views
xtrabackup backup grants?
I'm using MySQL 5.5 + Opensuse 12.3 .
After face an issue with mysqldump (appear be a bug with OpenSuse Mysql distribution) I have looking for others backup solution.
I found the xtrabackup from ...
1
vote
2answers
37 views
Live backup without lock
In our company we have a lot of MySQL databases. Some of these are critical and we want to take a back-up of all databases. These databases can't be locked because the application can change these ...
1
vote
1answer
30 views
Best way to perform backups with filegroups and then restore those backups
Scenario:
Database consists of these file groups:
PRIMARY
xxTEST2
xxTEST3
xxTEST4
Database consists of the following files in those file groups:
xxTEST_RESTORE - Rows Data - PRIMARY - ...
1
vote
1answer
168 views
ORACLE restore - how to restore specific .bkp file?
I just started working with oracle and I have some issue.
My database is NONARCHIVELOG mode.
I made two backups:
they are at locations:
...
1
vote
1answer
119 views
Is storing archive logs on local disk and backups on vendor storage possible?
I am using DB2 9.7.
My LOGARCHMETH1 is set to VENDOR library. Example:
LOGARCHMETH1=VENDOR:/usr/openv/netbackup/bin/nbdb2.sl64
Is it possible to call the following backup command:
db2 backup ...
1
vote
1answer
87 views
DB2 online restore - “SQL1035N The database is currently in use.”
I am trying to do ONLINE RESTORE ROLLFORWARDING TO END OF LOGS AND COMPLETE. When I run this command I am getting error SQL1035N The database is currently in use. It does not allow any connections to ...
1
vote
2answers
240 views
SQL Server - backup / restore schema only (not a duplicate if that's what you're thinking!)
We have a DB on over 100 servers of which we want to backup / restore the structure of just 1 at a time to a specific UAT database. They're all called the same thing but vary in terms of schema - ...
1
vote
1answer
234 views
DB2 Online Restore but Without Roll Forward?
I read a lot of documentations for db2 restore but I could not find how to perform online restore from the last database backup but without roll forwarding of logs?
I will appreciate command ...
1
vote
1answer
125 views
MySQL Point in Time Recovery For Just a Single Schema?
Is it possible to simply restore a single schema and bring it to a point in time (Say three hours ago) without bringing the entire database back?
I can think of a lengthy method of backing up each ...
1
vote
2answers
164 views
MySQL Enterprise Backup error: Log scan was only able to reach xxxx
I use MySQL Enterprise Backup to make incremental backups, but when I apply a restore (copy-back), I can't remake a backup.
I get this error:
mysqlbackup: ERROR: Log scan was only able to reach ...
1
vote
1answer
248 views
PostgreSQL - How can I manage WAL archiving for different databases on a server?
I'd like to use WAL archiving for incremental backup of my database. But I have 2 databases on my server, and I can't afford the disc space for backup of both of them. So I only want to backup one of ...
1
vote
1answer
118 views
Access denied Error in MySQL and Drupal
We are trying to deploy a Drupal application on our production server.
We see this strange error Lost connection to MySQL server at ''Access denied root@ipaddres password(yes) after deploying.
We ...
1
vote
1answer
141 views
Failed to restore mysql database with zmanda
I want to setup a slave from my backup version of mysql using zmanda (it's a full backup).
I've followed this guide.
Result of mysql-zrm-reporter
backup_set backup_date ...
1
vote
1answer
885 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
320 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.
...
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 ...
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 ...
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 ...
1
vote
1answer
451 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 ...
1
vote
1answer
140 views
xtrabackup “failed to read metadata” [closed]
Doing a staging run setting up a new xtrabackup restore script I'm running into a somewhat cryptic error I can't readily google a solution for.
I'm working with an incremental backup design. During ...
1
vote
2answers
1k views
BACKUP failed to complete - with spaces, for no reason
Every day my database backup fails for some databases and does fine for others. I'm calling the backup through a Stored Procedure that runs scheduled in a job. Tonight I'm going to run the procedure ...
1
vote
1answer
273 views
Partial backup and restore using filegroups
I have a single database that I put all tables into with multiple schemas for the different products I have. I know I can't backup and restore just one schema, but if I move all tables for a schema ...
1
vote
2answers
117 views
Restore backup in order to write datafile sequentially in disk
I have just come to a new company and we have one database which was created with standard initial size and autogrowth parameters for data and log files (1 MB autogrowth for data / 10% for log).
The ...
1
vote
2answers
1k views
Can anyone explain to me the concept “incarnation” in Oracle database in an easy-to-understand way?
The Oracle documentation describe incarnation as:
incarnation
A separate version of a database. The incarnation of the database
changes when you open it with the RESETLOGS option, but you ...
1
vote
1answer
604 views
Maintenance Plan fails but the query it generates Runs
I have an SQL Server 2005 Enterprise Edition whose Maintenance plan fails constantly with the error:
backup MYSERVER (MYSERVER)
Backup Database on MYSERVER
Databases that have a compatibility level ...
1
vote
1answer
93 views
Backup / Restore Distributor
I have a database architecture with:
=> 1 distributor running on a dedicated instance of SQL Server 2005
=> 2 publishers running each on a dedicated instance of SQL Server 2000 and SQL Server 2005
=> ...
1
vote
2answers
254 views
Scheduled backup errors
I am trying to do the following. I have about 50 DBs and a network NAS that acts as backup machine. I have made an sql script(lets say backup.sql) with 50 lines each of these say "BACKUP DATABASE ABC ...
1
vote
0answers
23 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 ...
1
vote
0answers
63 views
SQL Server 2005 Unexpected Disk Usage during Backups [closed]
On our SQL Server 2005 SP4 server we have a maintenance plan in place which performs a full backup of selected databases on a nightly basis. The databases are configured in Simple recovery mode and ...
1
vote
0answers
58 views
How to backup a running SQL Server CE database with full data?
I need to move my running windows-based app (built in C#) to another machine, but I also need to transfer the whole data, how can I take a backup from the .sdf file and use it with the new installed ...
1
vote
0answers
160 views
Cannot remove .bak file
I have a java application that:
Reads a .bak file from a windows fileshare and restores it in SQL Server on a remote windows server
Does various modifications on the database restored from the .bak ...
1
vote
1answer
168 views
How to run a cold backup with Linux/tar without shutting down MySQL slave?
I run the following before tar-ing up the data directory:
STOP SLAVE;
FLUSH TABLES WITH READ LOCK;
FLUSH LOGS;
However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
1
vote
1answer
882 views
Write lock during mysqldump even using --lock-tables=false
When I try to dump an online database using --lock-tables=false, others cannot update the table. Are there any methods to solve this?
As I am using MyISAM, does --single-transaction for InnoDB help?
...
0
votes
2answers
263 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.
...
0
votes
4answers
86 views
Shortest method to upload database to server
I have a SQL Server script file which ranges size of 3gb and I am in need to upload the script file to an external server.
i generated script for my 6gb database by following these steps
...
0
votes
1answer
99 views
Restoring a differential backup in SQL server 2005
I have created a full back up of my database by executing the line below in my application:
Dim Query As String = "backup database Ari to disk='G:\Documents and Settings\i\Desktop\BKAR\" & ...
0
votes
2answers
232 views
Row level restore with Oracle Recovery Manager (RMAN)
We're approaching the end of 2012 and I still find myself relying on database exports to maintain the ability to do row level restore operations. While this is a proven method, it sure would be nice ...
0
votes
1answer
670 views
Can we back up mysql databases by copying files?
I tried to reinstall mysql on my machine, but it keeps failing. Everytime it fails, it does this locking and that locking and future effort would fail again.
Finally I decided to do truly clean ...
0
votes
3answers
71 views
Where can I learn about MySQL master/slave, master/master, or clustering setups?
What are the best resources you've read or watched about setting up master/slave or clustering for database replication?
I don't know much about this. I have a database that is getting rather large ...
0
votes
2answers
212 views
Is command BACKUP asynchronous operation
I got strange delays when backed up a group of databases (20 more) in one scope (TSQL) to the same file location.
Is it possible that multiple backup operations are running at the same time? I have ...
0
votes
2answers
57 views
How does mysql transaction works?
I already know how to use transactions, what I want to know is how MySQL transaction handles data being processed...
For example, consider the following:
1. I have 2 databases (db1 and db2) ...
