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)

2
votes
2answers
1k views

SQL Server 2008 R2: Restore latest backup to new database from script

We have a database for each major version of our system, for each customer, for both development and test. Like so: WHATEVER44_CUSTOMERA_DEV WHATEVER44_CUSTOMERA_TEST WHATEVER44_CUSTOMERB_DEV ...
1
vote
1answer
664 views

Restoring Oracle prod backup to test server with new database name

I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database ...
5
votes
1answer
267 views

Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups?

The Setup: Say we have a Database in Full Recovery Mode that does a nightly Database Backup, Transaction Log Backup, and Transaction Log Shrink. Now the Transaction Log grows so quickly during the ...
0
votes
1answer
746 views

Slow backup and extremely slow restores

I don't normally work with MySQL but with MS-SQL and am having issues restoring a dump backup of a 9 GB database. I converted it to MS-SQL and it takes a grand total of 4 minutes to restore but the ...
5
votes
4answers
3k views

SQL Server DB restore fails

I am trying to do a SQL Server database restore using this T-SQL code: ----Make Database to single user Mode ALTER DATABASE xyz SET SINGLE_USER WITH ROLLBACK IMMEDIATE ----Restore Database RESTORE ...
2
votes
2answers
18k views

How to take Oracle backup and restore?

I am coming from SQL Server background where SQL Server studio has a very easy way of taking database backup and then doing a restore. I have been using Oracle 11G express edition for past couple of ...
2
votes
1answer
706 views

How to restore a SQL Server database along with a standalone application?

I am new to Microsoft SQL Server. I mostly use MySQL and Firebird databases in my projects. I have a client who needs to restore some software after his computer crashed. All that is left is a pen ...
4
votes
2answers
2k views

Restore all applicable files in a backup device in T-SQL

I'm using SQL Server (2008 R2 in this case) and I am backing up my databases into backup devices (one per database). Every Sunday the device is overwritten with a new full backup, every night a ...
2
votes
2answers
357 views

When restoring a SQL Server DB from dump files on a remote NAS share, copy before restore or restore directly?

My team is considering backing up all DBs to an Isilon NAS and we're conducting time trials to see if the restore time from the NAS is quicker than performing a copy to local storage before restoring. ...
2
votes
3answers
2k views

Restoring an entire SQL Server database instance

I have a server that we will be completely reformatting then rebuilding. Everything will be rebuilt exactly as it is now - same filenames, same directories, etc. After SQL Server is installed, I ...
2
votes
3answers
7k 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 ...
8
votes
1answer
6k views

disable constraints before using pg_restore.exe

When I try to execute pg_restore.exe of a dump file from a database, it throws dozens of errors, all the same: ERROR: insert or update on table "someTable" violates foreign key constraint ...
7
votes
1answer
983 views

SQL Server considerations when backing up / restoring a database that uses replication

In the event that I need to restore a database involved in replication, what considerations to I need to keep in mind? Do I need to keep backups of both the publisher and the subscriber? Can I ...
2
votes
2answers
967 views

Why restoring a large sql file via SSH seems to quit partially through the process

I have a large (~5GB) .sql file I am attempting to restore via SSH, it seems to quit in the middle of the restore process. When I come back hours later after issuing the command (the file has 7 ...
3
votes
1answer
233 views

sql server down bad things happens

Following Situation: You have a Database with very high transactions, the Database is about 4100 GBs The Recovery Modell from your Database is full Every week you make a full backup from your ...
1
vote
1answer
592 views

Error When Restoring Backed Up Tables

I followed directions from this page: http://serverfault.com/questions/271367/importing-data-from-myd-back-up-file I dropped the 3 files ( t2010_08.frm, t2010_08.myd, t2010_08.myi ) into my ...
0
votes
1answer
2k views

How To insert records in SqlExpress Database tables through sqlscript while installing setup?

I'm creating a database and all of my tables using SQL Server Express through SQL scripts. Now, I want to insert some records in tables like States (all states names), city (all city names). How ...
0
votes
1answer
3k views

Oracle big datafile restore fails using Netbackup (ORA-19511, ORA-27190)

I am restoring datafiles about 1000GB in size. I am using Netbackup as a backup server. After 2 hours reading Netbackup fails with the following error: 7/25/2012 3:27:50 PM - Error bpbrm(pid=1176) ...
2
votes
2answers
2k views

Relocate all files to folder checkbox unavailable sql server 2012

Using SQL 2012 Enterprise edition Following instructions here for restoring a backup: http://msdn.microsoft.com/en-us/library/ms186390.aspx#Restrictions I need to be able to rename the database ...
1
vote
1answer
573 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
324 views

Questions about PostgreSQL backup/restores

I've inherited a large PostgreSQL 8.4.7 database that is currently not being backup at all. The database itself I believe is around 100GB, I've been reading about the different methods to backup this ...
0
votes
1answer
626 views

Drop and restore PostgresSQL database without losing settings

This seems like a simple, easy question, but I'm very new to PostgreSQL administration and I'm not sure of the best way to do things. I have a PostgreSQL (9.1) database that somehow got corrupted ...
12
votes
1answer
8k views

postgresql: how do I dump and restore roles for a cluster?

Where are roles stored in a cluster, and how do I dump them? I did a pg_dump of a db and then loaded it into a different cluster, but I get a lot of these errors: psql:mydump.sql:3621: ERROR: role ...
2
votes
1answer
2k views

Reducing DB size while restoring

I have DB backup with size approx. 150 Mb. I am trying to restore it and getting an error: "System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the ...
1
vote
1answer
4k views

Oracle backup with RMAN Options?

I'm trying to learn RMAN but getting confused everytime I read Oracle docs! Can someone help me what are the differences and when to use the following? BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT ...
4
votes
3answers
1k views

Restore a SQL Server database to an offline copy

I have SQL Server Management Studio. I need to access a backup file (*.bak). How do I create a new database engine that is OFFLINE (running from my PC not the server) and then restore the database ...
3
votes
1answer
2k 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
2k views

How do I have RMAN treat my restored data files like they are originals?

I am planning a migration for this ancient-but-critical Oracle database from one Windows Server 2003 cluster to another. The database has many data files and they are all getting new paths on the ...
10
votes
2answers
19k views

Can I restore a SQL Server .bak files without SQL Server?

I have some large .bak files from a SQL Server 2005 dump. Can I restore these without using SQL Server, either to PostgreSQL, MySQL, or to flat text files? An open source solution would be most ...
3
votes
2answers
2k views

Would it be possible/wise to execute 2 parallel restores from a single backup?

Every night I create a backup (to disk) of a particular database. Subsequently that backup has to be restored to 2 different servers. These restores now happen sequentially and take about half an hour ...
3
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
2answers
6k views

Extract mdf & ldf files from backup file?

Is there a way to extract SQL Server files (.mdf & .ldf) from a backup file (.bak) to a physical location, without restore database? I need a restore query or script to restore files from bak ...
0
votes
1answer
860 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 ...
3
votes
1answer
3k views

Problem restoring a database in SQL Server

I am trying to follow the instructions on the following post: http://stackoverflow.com/questions/10299811/creating-new-database-from-a-backup-of-another-database-on-the-same-server To summarize; I ...
1
vote
1answer
2k views

while restoring mysql database, views changed into tables

I have a full database dump and i restored it. But in my new restored server all the views are appeared as MyISAM tables. In early times dumps were restored perfectly. can anyone help me to trigger ...
3
votes
1answer
613 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?
3
votes
1answer
316 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 ...
15
votes
2answers
5k views

Restore database excluding FILESTREAM data

Context We are developing a system with a large-ish database in the bottom. It is an MS SQL database running on SQL Server 2008 R2. The total size of the database is about 12 GB. Out of these, ...
3
votes
1answer
8k 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 ...
7
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 ...
1
vote
2answers
665 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
2answers
2k views

ERROR 1100 (HY000) at line 11084: Table 'search_index' was not locked with LOCK TABLES

I'm trying to import a mysqldump backup of a drupal database taken from a server running MySQL 5.0 (which will be upgraded to 5.5) onto my local machine running MySQL 5.5.23. The import fails with the ...
1
vote
0answers
60 views

SQL Server Database Size much higher than the backup size after restore [duplicate]

Possible Duplicate: Why is a .bak so much smaller than the database it's a backup of? The database backup size is around 120 MB but when I run Restore FileListOnly, I see that the data ...
1
vote
0answers
178 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 ...
3
votes
1answer
8k 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 ...
5
votes
3answers
458 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 ...
7
votes
2answers
352 views

Automation of backups of Large Number of Database

In a multi-tenant web application where a database is set up for each tenant, the database can be backed up and restored manually through a fairly conventional approach. I am considering this type of ...
2
votes
2answers
81 views

Data Backup and Restoring the same if requried in SQL SERVER 2008

In Multi-tenancy , Shared Database Shared Schema. How to take Tenant level backup and restored the tenant data when required? Can any one guide me or point me to the right direction. Thanks!!! NB: ...
2
votes
2answers
985 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
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: ...