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
votes
2answers
3k views

Trouble recovering data from corrupted PostgreSQL tables

I'm trying to recover my database after a recent corruption of the same. Now I have two tables that are really giving me trouble. When I do select count(*) One table returns: ERROR: could not ...
0
votes
1answer
629 views

Is it possible to resume an interupted mysql import from a backup file?

I created a backup file of my database with phpMyAdmin and checked the following data dump option: include column names in every INSERT statement Example: INSERT INTO tbl_name ...
1
vote
2answers
581 views

Using an older MySQL binlog filename (with position zero)? Risks? Downsides?

Let's say I'm setting up a new slave. I start with a mysqldump after running mysql -e "STOP SLAVE", transfer that and restore it to the new server. If I didn't capture the BINLOG filename and ...
3
votes
1answer
546 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?
2
votes
3answers
2k views

How do you restore a particular table in MySQL?

One of our users has deleted a table by mistake. How can I restore only that table?
1
vote
1answer
149 views

SQL Server DB Restore Clustered to Single Node?

Can you restore a DB from a SQL Server 2005 Clustered Environment (Prod) to a single server (single node) (SQL Server 2005) in Dev/Sys? Cheers, Conor
6
votes
1answer
3k views

How large will a MySQL database be relative to the dump file?

I'm restoring a ~52GB dump to a MySQL database. The ibdata1 file has already exceeded the size of the dump file and the restore is still incomplete. Is there any way to estimate the final size of the ...
2
votes
2answers
895 views

Attach database from SQL Express 2008 Edition to SQL Server 2008 Enterprise Edition

My friend is stuck on moving a database stored in SQL Express 2008 Edition in a server (called server A) to SQL Server 2008 Enterprise Edition in another one (called server B). There are two SQL 2008 ...
1
vote
0answers
161 views

pg_dump dumps casts after views using them [closed]

My small but annoying problem is that the regular backups of a database of ours always list the user-defined casts after those views that would make use of them. For this reason I have to maintain a ...
5
votes
3answers
382 views

Restoring SQL DB from down SQL Server (on domain) to existing SQL server (not on domain)

If and when my SQL server goes down and takes too long to get back up, can I restore my DB on another SQL server and run my software from there (I can point which SQL server to run from)? Will all ...
1
vote
1answer
278 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: ...
1
vote
1answer
227 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 ...
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 \ > ...
2
votes
2answers
284 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
2answers
348 views

In Oracle, can we restore a database onto the same instance with a different name?

In SQL server I can restore a database onto the same instance with a different name. Eg: If there is a database DB_prod, I can take a full backup and restore it on the same instance with a different ...
4
votes
2answers
2k 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 ...
7
votes
1answer
9k 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 ...
1
vote
1answer
2k views

automating a database backup, restore and stored proc call

How do I create a process that will: backup Database A restore it as Database X (needs to be definable) then run a stored procedure against Database X. shrink and truncate its log file. Anybody ...
3
votes
4answers
568 views

SQL Server restore from transaction log

In SQL Server 2005, if you have a database with no backup - but it is running in full recovery mode - is it possible to "roll back" some deletes? If yes - how?
1
vote
2answers
7k 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
2answers
59 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 ...
-1
votes
1answer
292 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, ...
2
votes
2answers
709 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" ...
2
votes
1answer
453 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
859 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
2answers
147 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 ...
3
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 ...
0
votes
1answer
520 views

What network access do I need when I restoring files using RMAN?

I am restoring files from one server to another server using Oracle RMAN, what network accesses do I need?(between these servers) ftp? port 1521 should be open? or what? I appreciate your answer ...
1
vote
4answers
6k views
2
votes
2answers
3k 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 ...
3
votes
1answer
3k views

Restore Database from Network Drive

I not able to restore DB from maped Network Drive, Only from HDD initialized in Native OS, my enviroment is MsSql2008 on Win2008R2 Standard (as virtual in VMware ESX4.1), Win2008R2 Standard ...