Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.
0
votes
2answers
244 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
36 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. ...
2
votes
1answer
340 views
Ensure correct username when using pg_restore
I have just installed postgres 9.1.6 on a local Ubuntu server. Now I'm trying to restore a database dump from a database on Heroku. The local database is setup like this:
sudo -u postgres psql -c ...
3
votes
1answer
479 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 ...
3
votes
2answers
203 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 ...
-1
votes
1answer
328 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
493 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
223 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
...
0
votes
1answer
194 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 ...
1
vote
2answers
799 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
347 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
300 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
143 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. ...
1
vote
3answers
130 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
766 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
vote
1answer
1k 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
125 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
175 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
154 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
386 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
499 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
634 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
1answer
200 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
151 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
157 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
203 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 ...
0
votes
1answer
920 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
668 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 ...
0
votes
0answers
136 views
change database name controlfiles after restore?
I have restored database with the name DB to another database called DB01
it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it ...
1
vote
1answer
373 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
...
3
votes
1answer
856 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, ...
2
votes
1answer
1k 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 ...
4
votes
2answers
3k 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 ...
2
votes
2answers
288 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 ...
2
votes
2answers
903 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 ...
-1
votes
2answers
2k 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
200 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
1k 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 ...
3
votes
1answer
84 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
133 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 ...
8
votes
2answers
1k 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
895 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
348 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 ...
1
vote
0answers
95 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 ...
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 ...
5
votes
3answers
173 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 ...
2
votes
2answers
508 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
208 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:
...
4
votes
2answers
157 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 ...
5
votes
1answer
3k 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 ...
