Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.

learn more… | top users | synonyms (2)

1
vote
1answer
284 views

GUID as reason for MySQL import slowness

We faced MySQL restores DB VERY slow: ~3 min for 15 MB dump. This is a new dedicated server with a lot of RAM. We were told the most possible reason is GUID is uded as primary key in many tables: ...
2
votes
1answer
585 views

Correcting the imported latin1 data to be utf8

I restored my drupal site database from a backup but after i finished i discovered that the Imported data was symbols like this قوانين كرة because the backup was taken using latin1 charset ...
1
vote
1answer
2k views

Solution to error NID-00135 in Oracle 10g, Solaris 10

We are trying to build a test version of a production database by restoring the production backup using RMAN and renaming the database to test. We've successfully restored and opened the database ...
5
votes
3answers
560 views

What is the easiest way to use a SQL Server backup to retrieve just a few rows?

I need to manually retrieve a few rows from a SQL Server 2008 database backup. Normally I create a new database, restore the database backup to the new database, and run my queries. The database is ...
4
votes
2answers
2k views

SQL Server Restore DB from MDF file, lost LDF and DB was not cleanly shutdown

My dev DB server was formatted by some admin without my knowledge. Thankfully I had mdf file kept in some other drive but ldf was in its default location. Since I don’t have DB backup I am now left ...
6
votes
1answer
18k views

Cannot connect to DB2 database after restoring an offline backup

This is for DB2 9.7 Enterprise Server Edition on AIX. I had a full, offline backup taken of several databases within our instance in a performance environment. I wanted to restore these databases to ...
2
votes
1answer
276 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?
6
votes
3answers
6k views

Restoring a database is not working

I have a database called FDB. I have created this database on my PC with SQL Server Express Edition and added one table. I made a backup of this database. The SQL Server version on the server is 2005. ...
2
votes
2answers
1k views

SQL Server: in what situation can snapshot restore be blocked after SET SINGLE_USER?

In my tests, i have the following script: USE master; ALTER DATABASE [TestDB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE [TestDB] FROM DATABASE_SNAPSHOT = 'TestDBSnapshot' In some ...
3
votes
2answers
2k 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
9k 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 ...
3
votes
1answer
3k 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
343 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
1answer
597 views

How can I restore a single record from a MySQL backup file?

Occasionally we have an issue where a record's previous data might get wiped while editing. We backup our database every night for issues like this, however sometimes I am not available to do a ...
5
votes
1answer
13k views

Repairing corrupt SQL Server database backup?

I'm looking at a problem for someone who was backing up to a cloud-based service. Apparently the customer's server crashed while it was performing some maintenance on the cloud-based service's ...
-6
votes
1answer
2k views

SQL Server 2000 to 2008 R2

When I try to restore a database abackup from a SQL Server 2000 to 2008 R2m, I get this error: Actually, I don't quite get it. What does the error actually mean? And how can I solve it?
0
votes
1answer
546 views

How do I restore a SQL backup, while excluding a specific table?

How do I exclude a specific table during a SQL backup RESTORE operation? My question is specific to restoring a backup sql file. I am using Putty and bash server.
5
votes
2answers
2k 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 ...
5
votes
2answers
941 views

Getting recovered db files to work on rebuilt server

I've had to rebuild my server and have tried to copy the database files from the old drive to /var/lib/mysql/. I have restarted apache and run 'show databases', this list all the databases. I have ...
1
vote
1answer
379 views

Same restore file (.bak), huge difference of execution duration time on various computers

First of all, the question is nothing to do with SQL performance optimization. I have a .BAK SQL Server backup, and have restored it on my computer. My computer: i7 2600 3.4GHz, 240GB SSD, 8GB RAM, ...
1
vote
3answers
340 views

What is this error about in sql server?

Trying to restore database, getting a dialog in SQL Server Management Studio You cannot select backup sets from different databases" Any idea why I am getting this error? BTW backup is from ...
4
votes
2answers
3k views

How do I rescue SQL Agent jobs from a set of detached master, model, mdb files?

I had a MSSQL (MSSQL 2008 R2) cluster that failed in a way that I couldn't bring it back up (long story, servers ended up in BSOD loops, I'm blaming Broadcom and myself). I've SQL backups, and even ...
2
votes
2answers
477 views

Looking for a way of moving millions of record without impacting the transaction log

I need to move around 10 million records out of a table into a new "optimized" table, but I need to keep the database online. What would be the best method in doing this without impacting the ...
2
votes
2answers
888 views

Need help in restore some rows into mySQL database frm myd myi

I am using one mySQL database for several sections of the website and one of the section is not working, when I go to the link of that section it gives the error "1146 Error @ Line 39: Table ...
2
votes
1answer
838 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 ...
0
votes
3answers
954 views

SQL Server restore sequence from multiple full, diff and log backups

Suppose I have a lot of backups (may include full, differential and log backups) of a SQL Server database. I want to write a program that can generate a SQL script to take the database to its most ...
1
vote
1answer
416 views

Why is Mysqlcheck on 5.1.41 still showing as Innodb table corrupted after a table dump and restore?

I had a very large corrupt innodb table. mysqld would crash whenever I did a check table on it. I did a innodb-force-recovery=1 and did a dump of the table. No errors showed up. I dropped the table ...
3
votes
2answers
5k views

Move an Oracle database by moving the raw data files

I have a large Oracle database (~300 GB) and I need to move a copy of the database to a new environment in a short period of time. I was wondering if there is a way to just pick up the raw files ...
3
votes
1answer
484 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
3answers
653 views

Restoring SQL Server database backup file for read-only access - is it possible to skip the ldf file creation?

I need to read some data from a database given by its backup file. So, I issue the RESTORE DATABASE command, which creates two files - the database MDF file and the log LDF file. Is it possible to ...
2
votes
3answers
2k 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
2answers
285 views

Rename database object during restore

Is there a way to rename database objects such as tables, stored-procedures, etc, during a restore of a .BAK file to a new database?
3
votes
2answers
10k views

Why does restore take a long time?

Although, the database backup file is only 2GB, the restore can take up to 15-20 minutes even on a x64 12G RAM, i7 machine. When I backup similar sized backup files made from a different database, the ...
7
votes
1answer
12k views

How can I recover data from the LDF file?

We are using SQL 2005 Express Edition. We want to read the data from the LDF file in order to restore some deleted records. We tried using a trial version of ApexSQL which helped us a lot. Instead of ...
7
votes
2answers
60 views

Oracle 10g: Is it possible to designate a undo point?

I was wondering if it is possible to designate a point in time, then later "roll-it-back" to that state (undo DDL and DML changes). Maybe using a record of changes and then executing the reverse? Does ...
0
votes
1answer
315 views

Does SQL Server full restore set the differential base?

Differential backups are taken as the difference between the current state, and the last full backup called the "differential base". Does restoring a full backup reset the differential base? If so, ...
5
votes
4answers
2k views

What is a good way to verify that a restore completed successfully in SQL Server?

Right now, we test our SQL backups once a month by pulling the most recent backup file and restoring it onto a test database. If SQL Server says the restore is successful, we spot-check a few tables ...
2
votes
2answers
798 views

Restoring database always throwing exception

I am trying to restore some database backup file into the same database. The .bak file is creating problem always. When I select the .bak file from a network drive like "\\TestPC\ShareFolder\test.bak" ...
3
votes
1answer
1k views

Restoring SQL Server Database Command Line Error

I have a restore database script in a SQL file, and I'm trying to restore a backup generated from one DB to a new DB (that exists). That SQL file is being executed by SQLCMD on the command line. The ...
3
votes
1answer
5k views

MySQL Restore Large Dump

I have a dump file of a single table which is 7GB. I try to restore it using mysql -u root -p DB_NAME < .SQL FILE But I don't see any activities in task manager. CPU is 00 and RAM is 5,700 K. I ...
2
votes
1answer
486 views

how to restore database from other server - sql

I have backup database from server A. Then I want to restore it in server B. I have manage to restore it, but I cannot connect to it when running my VB program. I already change the configuration ...
2
votes
1answer
944 views

How to Backup and Restore Filestream Data

I am trying to backup and restore my database which includes a filestream filegroup. I backed up the database without the filestream filegroup and was interested to know what happens when you restore ...
1
vote
1answer
93 views

mysql server password change while restoring

I restored all database backup from another server's dumpfile to my machine. At the end my mysql server's password changed to that mysql server's password. Why it got overwritten? What i need to do to ...
14
votes
6answers
29k views

Restore mysql database with different name

How can we restore mysql database with different name from mysqldump file. I dont't want to open dump file and edit it. Any other better methods?
4
votes
1answer
2k views

Does my choice of pg_dump format impact restore speed?

According to the docs for my version of Postgres (8.4.2), pg_dump can "output in script or archive file formats." The script-formatted dump (4GB) takes 1.5 hours to restore, and I'm wondering if the ...
2
votes
1answer
871 views

BACKUP and RESTORE MySQL Database

I have very specific question. I have seen the instructions on how to backup and restore mysql database using SSH but they barely explain the process when backing up on one server and restoring on ...
1
vote
2answers
156 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 ...
2
votes
2answers
6k 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 ...
2
votes
1answer
226 views

Aborted restoring from back up Sql Server 2008

I started restoring from backup using (WITH REPLACE, RESTORE WITH RECOVERY) and realized that it was a mistake, so I stopped restoring. Now this db is unavailable and has a 'Restoring' status. Can ...
4
votes
3answers
1k views

Restore script in SQL server doesn't work in W7

I need a little help with a restore process, I can't find specific help in other similar questions, sorry if my question does not correspond. I have this script in my system: RESTORE DATABASE ...