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

1
vote
0answers
681 views

pg_restore and psql asks password for restoring dump file

This will be probably extreme novice question but I want to restore a .backup dump file. I have tried the following command: pg_restore -i -h localhost -p 5432 -U postgres -d old_db -v ...
2
votes
1answer
156 views

Help with best practice of merging databases

Bad news, our website server (Windows 2003) crashed because of dead RAID controller. Luckily few hours later our backup server was up and website was live again. Hopefully tomorrow our original ...
-1
votes
1answer
278 views

How to merge data from 2 databases [duplicate]

I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
0
votes
2answers
229 views

Can I recover CDC tables from transaction logs?

Is there anyway to restore CDC tables from transaction logs? My basic understanding is that CDC reads these logs, and entries that are specially marked, are grabbed by CDC. Once this has happened ...
0
votes
1answer
821 views

Is it there anyway to restore updated records in Microsoft SQL Server 2008 R2?

We have an test database configured with our web application. Due to internal web application error the entries were get updated in the database. Is it there any way to recover the updated records? ...
1
vote
2answers
753 views

What's the best way to backup DB files via network on Linux and Solaris machines?

I wonder what the best way to backup files via the network. I have Solaris machines with Oracle 10i on a Veritas cluster. Machines are connected to EMC storage. The /data/oracle directory is mounted ...
6
votes
1answer
2k views

Restore a Database to a New database (T-SQL)

I have a database backup from a database, say SourceData which needs to be restored on another database, same schema, but different name (SourceData_1) using T-SQL. I don't know why I gets the ...
2
votes
2answers
2k views

Restoring differential backup from SQL Server 2005 to SQL Server 2012

We are migrating a client to a new server. Their old server has SQL Server 2005. I have attempted to perform a differential backup however I received an error about the LSN chain being broken. Please ...
2
votes
2answers
5k views

Restoring a database backup to a local machine in MySQL

I have downloaded my .sql file of my database server. It is in the D: drive of my Windows machine. I want to restore the back up in my this machine. I used: mysql database -u root < ...
7
votes
3answers
195 views

How can I verify that a full database restore reflects the exact source database in SQL Server?

We are decommissioning our old SQL Server 2000 Ent. instance in favor of SQL Server 2008 R2 Ent. My planned migration path is: Terminate client connections (2000) Full Backup (2000) Restore (2008 ...
2
votes
1answer
124 views

Restoring a database back to a point in time before full backup was made

A problem with one of our database tables arose at the end of last week and I wanted to restore that database to a server in order to retrieve the table. We only have the last backup, and a full set ...
2
votes
1answer
142 views

Oracle Backup and Recovery Issue

I have backed up database located on Host1 and restored/recovered it on Host2. After a while, I backed up DB on Host1 again. Now I want DBs on Host1 and Host2 be the same using last backup. How can ...
0
votes
1answer
2k views

Restoring multiple differential backups SQL Server 2008 [duplicate]

Over the bank holiday the backups failed on a db the full has been restored and now I have several differentials to be restored on top. Could someone give best method or do I restore just ...
1
vote
1answer
142 views

MySQL: parallel restores at same time from backup files?

Slightly related to this question, but for MySQL: Would it be possible/wise to execute 2 parallel restores from a single backup? Is it possible/wise to do a parallel restore of two independent ...
1
vote
1answer
117 views

Does the SQL Server Backup Database Command also backup views from a Database?

I have a backup job (SQL Server Agent job) which will iterate through all of our SQL Server databases in SSMS, invoke the BACKUP DATABASE command to create a .bak file on a different server. This ...
0
votes
1answer
287 views

Restoring a differential backup in SQL server 2005 [duplicate]

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\" & ...
1
vote
1answer
384 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
3k 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 - ...
2
votes
2answers
717 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 ...
1
vote
2answers
276 views

Move named instance to another server

To be honest I'm not a DBA expert. I get asked by one of my clients in terms of moving a SQL Server development instance that is stored in the production server (source) to another server ...
2
votes
0answers
62 views

Is it possible to have a valid backupset with null position?

In database restore process I need to rely on position column exists in backupset record to restore the latest backupset. Restore the latest backup on the database I noticed sometimes position is ...
6
votes
2answers
13k 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 ...
5
votes
1answer
10k 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 ...
1
vote
1answer
886 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
3answers
3k views

Transaction log for SQL Server is too big

I have a database that has a 33 gb transaction log. It is caused by the fact that the database is in full recovery mode has been used for over 5 years prior to the first backup. I want to truncate ...
4
votes
1answer
72 views

SP for Restoring Database and performing other tasks on it

I am creating a stored procedure for our QA dept that will do the following: Accept specific inputs to generate a consistent name, restore a database (giving it the generated name,) set the db up for ...
2
votes
1answer
592 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 ...
2
votes
1answer
212 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
1answer
260 views

Restore InnoDB tables / database using only data files

I have MySQL Server 5.1.51 installed on Windows Server 2003 as Operating System and using InnoDB as database engine. I have run DROP DATABASE dbName statement by mistake. I have no backup of that ...
0
votes
0answers
389 views

Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio [closed]

I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS database instance using the master account I created when creating the ...
3
votes
1answer
298 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 ...
5
votes
2answers
705 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 ...
4
votes
1answer
1k views

Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio

I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS instance using the master account I created when creating the database ...
2
votes
2answers
297 views

Invalid data types in restore headeronly resultset

I'm trying to write a SQL Server script to iterate through .bak files in a directory and then restore them to our server. In doing so, I've created three temp tables: #Files to keep track of the ...
5
votes
2answers
1k 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
1answer
333 views

SQL Recover from .bak file with NOINIT

This will, hopefully, be a nice and quick question for someone out there. It continues from my previous question. I have a .BAK file that I'm trying to restore. The .BAK was created with the NOINIT ...
2
votes
1answer
493 views

Restore database from individual datafile backups

I had a script that backs up all the individual datafiles like: RMAN> BACKUP AS COMPRESSED BACKUPSET DATAFILE 'datafile<1>.dbf' So i have backupsets of all the datafiles. I'm confused as ...
1
vote
1answer
472 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 ...
0
votes
2answers
585 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 ...
1
vote
1answer
42 views

I have deleted a table, by exporting over the same table, and selecting the 'drop destination table before insertion'

I understand this might not be the best forum, but I could sure use some help right about now. If not, please suggest a forum where I can. I was trying to backup a table, by using the export wizard. ...
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 ...
1
vote
1answer
5k 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
2answers
596 views

How to wait for PostgreSQL to be startable / restorable?

I'm testing a PostgreSQL 8.2.1 to 9.2 upgrade on a virtual machine running a custom Linux distro. The upgrade procedure is as follows: Start the pg service Vacuum all DBs (not sure if this is ...
3
votes
1answer
914 views

How to wait between PostgreSQL DB restore and reindexing?

I've written a script to upgrade PostgreSQL from 8.2.1 to 9.2.1 on a Linux From Scratch distribution: Start the pg service Vacuum all DBs (not sure if this is needed) Backup with pg_dumpall Stop the ...
2
votes
3answers
5k 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 ...
-1
votes
1answer
988 views

Oracle XE: Transfer Database from Linux to Windows

our professor gave us a linux VM with a Oracle XE 11g Database. I want to transfer this Database to my Windows installation because I dont't want to boot up the VM for every exercise. Everything ...
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
0answers
521 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 ...
2
votes
1answer
39 views

How do I list the database files contained in a SQL Server 2005 backup file using T-SQL?

How do I list the database files contained in a SQL Server 2005 backup file using T-SQL? For instance: The restore process will create: bob.mdf bob.ldf etc...
2
votes
2answers
10k 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 ...