Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.
13
votes
1answer
548 views
Sql Anywhere 11: Restoring incremental backup failure
We want to create remote incremental backups after a full backup. This will allow us to restore in the event of a failure and bring up another machine with as close to real time backups as possible ...
9
votes
3answers
2k views
Is it possible to restore sql-server bak and shrink the log at the same time?
We have a bak file from a client that we have transferred to our developer offices for problem investigation. The backup is currently 25GB and the restored database is about the same size however it ...
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, ...
7
votes
3answers
136 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 ...
7
votes
1answer
5k 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 ...
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 ...
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 ...
6
votes
3answers
604 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.
...
6
votes
2answers
293 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 ...
6
votes
1answer
313 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 ...
5
votes
1answer
192 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 ...
5
votes
1answer
4k 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 ...
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 ...
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 ...
5
votes
2answers
798 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 ...
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 ...
4
votes
4answers
241 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?
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 ...
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 ...
4
votes
1answer
483 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 ...
4
votes
2answers
98 views
Database stuck in restoring and snapshot unavailable
I tried to restore my database from a snapshot. This usually took around a minute to complete the last couple of times. When I did it today, it didn't complete for around 30 minutes and the spid was ...
3
votes
5answers
1k views
Can I restore a database to a point of time without backup?
I have an SQL 2005 database with logging set to FULL but without any backups. Is it possible to restore it to a point of time?
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 ...
3
votes
1answer
582 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 ...
3
votes
1answer
81 views
Backing up file groups with restore to earlier backup
I have a task: I have created a database with a filegroup lamb that has a few tables.
I need to extract a csv into a table in a filegroup named lamb and back up that filegroup.
Then extract another ...
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
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 ...
3
votes
2answers
572 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 ...
3
votes
1answer
58 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 ...
3
votes
2answers
221 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 ...
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:-
...
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 ...
3
votes
1answer
737 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 \
> ...
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, ...
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 ...
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 ...
2
votes
2answers
118 views
Can I open a SQL Server 2008 R2 database in SQL Server 2008 R2 Express?
This question has probably been asked a dozen times but I couldn't find them here or at SO.
Can I attach/restore a SQL Server 2008 R2 database to my local SQL 2008 R2 Express instance?
2
votes
2answers
36 views
Can I restore an uncompressed differential backup after a compressed full backup?
If we enable compression on database backups (because the database backup size is huge) but don't enable it on differential which are relatively small in size, will a restore work? Because the full ...
2
votes
2answers
468 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 ...
2
votes
2answers
186 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 ...
2
votes
2answers
129 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
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 ...
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 ...
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 ...
2
votes
2answers
154 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 ...
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 ...
2
votes
2answers
450 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" ...
