Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.
2
votes
2answers
278 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
838 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
343 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
78 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
861 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?
3
votes
2answers
562 views
Restore script in SQL server doesn't work in W7
I need a little help with a restore process, I can't find specific help in other similar questions, sorry if my question does not correspond.
I have this script in my system:
RESTORE DATABASE ...
1
vote
1answer
77 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
3
votes
1answer
833 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
487 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 ...
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 ...
1
vote
0answers
92 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
170 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
204 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
137 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 ...
0
votes
2answers
2k views
Opening a .backup file for PostgreSQL
I'm going to warn you that whoever explains this needs to talk to me like I'm five years old, because this is something way, way beyond my level of expertise.
In short, I have what I think is a ...
3
votes
1answer
721 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
179 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 ...
-5
votes
1answer
653 views
SQL Server 2000 to 2008 R2
When I try to restore a database abackup from a SQL Server 2000 to 2008 R2m, I get this error:
Actually, I don't quite get it. What does the error actually mean?
And how can I solve it?
6
votes
2answers
288 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 ...
2
votes
2answers
442 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 ...
1
vote
2answers
282 views
Restoring SQL Server database backup file for read-only access - is it possible to skip the ldf file creation?
I need to read some data from a database given by its backup file. So, I issue the RESTORE DATABASE command, which creates two files - the database MDF file and the log LDF file.
Is it possible to ...
7
votes
1answer
4k 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
690 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 ...
4
votes
4answers
234 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
2k 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
55 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
225 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
491 views
What is a good way to verify that a restore completed successfully in SQL Server?
Right now, we test our SQL backups once a month by pulling the most recent backup file and restoring it onto a test database. If SQL Server says the restore is successful, we spot-check a few tables ...
2
votes
2answers
449 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
267 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
497 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
117 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 ...
2
votes
1answer
526 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
172 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
2k views
How do I archive and restore selected tables using SQL Server?
How do I archive and restore selected tables using SQL Server?
2
votes
2answers
1k 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
1k 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 ...
3
votes
2answers
3k views
How can I backup & restore a single FILEGROUP in Sql Server 2008
Previously, on ServerFault I asked a question about backing up and restoring a Sql Server 2008 Filegroup.
Today, when I tried to RESTORE one of these FILEGROUP backups, I got the following error:-
...
