Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.
5
votes
2answers
774 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
188 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 ...
1
vote
1answer
253 views
SQL Server: Simple database restore with overwrite
What I'm trying to do is backup one of our production databases and restore them as our dev database (overwriting what's been there).
That's how I back up:
backup database [authfx] to disk = ...
2
votes
1answer
139 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
141 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
232 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. ...
0
votes
1answer
483 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
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 ...
3
votes
2answers
186 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
403 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
625 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
312 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
461 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
...
2
votes
1answer
30 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...
1
vote
2answers
663 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 ...
4
votes
2answers
291 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 ...
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, ...
2
votes
2answers
141 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
113 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 ...
6
votes
3answers
531 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.
...
3
votes
1answer
767 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
222 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 ...
1
vote
3answers
655 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 ...
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 ...
1
vote
2answers
106 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?
1
vote
1answer
320 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 ...
1
vote
1answer
245 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, ...
2
votes
1answer
231 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 ...
1
vote
1answer
376 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 ...
1
vote
1answer
913 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
121 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
160 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 ...
1
vote
4answers
294 views
How do I restore a SQL Server 2000 database to a SQL Server 2008 instance?
How do I restore a SQL Server 2000 database to a SQL Server 2008 instance?
1
vote
1answer
349 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
153 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 ...
0
votes
1answer
594 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
179 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
147 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
800 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 ...
0
votes
1answer
191 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 ...
2
votes
1answer
624 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 ...
3
votes
1answer
571 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 ...
0
votes
0answers
131 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 ...
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 ...
2
votes
2answers
274 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
819 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
188 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
342 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 ...
