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 (2)

3
votes
2answers
3k views

ERROR 1100 (HY000) at line 11084: Table 'search_index' was not locked with LOCK TABLES

I'm trying to import a mysqldump backup of a drupal database taken from a server running MySQL 5.0 (which will be upgraded to 5.5) onto my local machine running MySQL 5.5.23. The import fails with the ...
9
votes
6answers
4k views

Migrate from SQL Server 2000 to 2012 without a 2005 or 2008 instance

I have come across three old databases sitting on SQL Server 2000 which I need to move to 2012. I believe the standard approach is to restore into a 2005 or 2008 instance, update, re-export and ...
1
vote
1answer
135 views

Fail to attach database : MSDTC Check status of transaction

I am attaching a database from a snapshot taken of the production database volumes. These databases will be anonymised and then restored to our DEV servers. Here is my attach statement: CREATE ...
3
votes
0answers
112 views

Restoring Postgres fixtures into a different database with different premissions

I've got an application called BigSense that uses two database users/rolls. One has full permissions and is used by my application to create/adjust table definitions. Then the application starts with ...
2
votes
1answer
5k views

pg_restore: [archiver (db)] could not execute query: ERROR: schema “public” already exists

I am using pg_dump / pg_restore to backup and restore a PostgreSQL database, but am getting some error messages (and a non-zero exit status) from pg_restore. I tried a super simple base case (outlined ...
0
votes
0answers
40 views

manual data migration/rescue MySQL version: 5.6.23

MySQL died and could not be started. So I transferred my database files via rsync to another server and restore from back up. Now I am trying to access my data with my updated records. mysql> use ...
0
votes
1answer
445 views

Restoring SQL Server 2012 DB - OPEN SYMMETRIC KEY SKey DECRYPTION BY CERTIFICATE NAME Not working

Database Admins, can you please help me out and let me know why my script is not allowing me to DECRYPTBYKEY once I restore my DB from a PRODUCTION BACKUP.... -- SET Staging to Single User Mode to be ...
0
votes
0answers
51 views

Cant Import mysql system DB from another server

Both Servers are the same in hardware, OS, and MySQL versions (5.6.11). One server has MySQL on it and on the other one I just setup a fresh instance. I want to import all of the data to the second ...
2
votes
1answer
117 views

Use transaction logs multiple times

Every night a full backup is made of all the user databases. Every 15 minutes, transaction logs are created. Today i succesfully restored a database with the use of transaction logs. I set the time ...
3
votes
2answers
149 views

What perfmon counters should I use to get the fastest restore possible on an idle system?

I have a development VM running Windows 2012-R2 and Sql Server 2014. I have one disk from a SAN holding the OS and SQL. My backup file is stored locally on the disk. I want to restore database as ...
2
votes
1answer
245 views

SQL Server Restore w/o “Closing Existing Connections”

By default in SSMS (2012/2014) when you choose to restore a database, the "close existing connections" option located in the is by default unchecked, is it possible to restore a database while ...
-1
votes
1answer
8k views

Restoring a backup of a database from SQL Server 2014 into SQL Server 2012 [duplicate]

Is it possible to load a backup of SQL server 2014db into SQL server 2012? Trying to import/restore is throwing backward compatibility issues. Thanks
1
vote
5answers
325 views

Getting Data Back after Wrong Data Restore in SQL Server

I would like to inquire if there is an possible way to return lost data that stored in a Sql server Database after making a wrong database restore? I know it is extremely hard to get a positive ...
2
votes
1answer
346 views

How to get back the PostgreSQL database to a specific point in time?

I was running a batch script in a PostgreSQL database which inserted values in different tables between 10:40 and 11:00. Later I came to know that the script was executed mistakenly. How can I get ...
2
votes
2answers
2k views

Restoring database between different version of SQL Server (SoftwareVersionBuild)

i have a question about restoring database from newer version of SQL Server to older, when version differs only in SoftwareVersionBuild. I know that's not possible to restore database from SQL Server ...
1
vote
4answers
4k views

restore could not start database

Restore failed for Server 'servername'. (Microsoft.SqlServer.SmoExtended) System.Data.SqlClient.SqlError: RESTORE could not start database 'ECP'. (Microsoft.SqlServer.Smo) The database is ...
0
votes
1answer
918 views

Is it possible to estimate the restore progress in SQL Server 2014 from pages read/written?

For context - SQL 2014 EE, we're doing tran log backups from our main production box and restoring to a R/O instance. The log is usually around 50GB. So I'm familiar with the structure of SQL Server ...
3
votes
3answers
336 views

How can I get SQL Server restore start and end time information?

SQL Server error log reports only the end of the restore (ah doc restore) How can I get the start time? Is it stored somewhere?
1
vote
1answer
86 views

Restore Database SET SINGLE_USER

I am in the process of writing a restore database script. I want to be able to connect as sa and run the restore script. When I run SET SINGLE_USER does this mean that my login is the only user ...
0
votes
1answer
39 views

Restore of db's on local locks me out of accessing other sites

Running my local dev websites on my Mac locally and when I am restoring a database via terminal, which the restore is running I cannot access anything that uses mysql, I get a broken pipe notice. Is ...
3
votes
5answers
2k views

Steps after restoring to a different server

We have a 30 GB Database on SQL Server 2008 R2 Standard Edition. Yesterday we backed up the database and restored it to a different Virtual Machine which has exactly the same specs as the previous ...
3
votes
1answer
258 views

I can backup my SQL Server 2008 R2 but can't restore from the very same folder

I ran a backup into a folder. The Network Service has full control access to this folder. The backup process didn't work until I granted that account full control. I try to restore that same file but ...
2
votes
1answer
2k views

When upgrading config servers to use WireTiger, the running config server with wiredtiger does not authenticate the existing pass and user?

In order to upgrade mongodb to 3.0.0, I am upgrading my config servers to use WireTiger. I followed the subsection of Change Config Server to Use WiredTiger. There are 18 steps. I run mongodump --port ...
0
votes
1answer
63 views

Restoring SQL Server 2000 database to SQL Server 2008

Is it necessary to restore system databases of SQL Server 2000 to SQL Server 2008, if I am restoring my other databases from 2000 to 2008?
2
votes
2answers
215 views

An easy way to select one db dump from multiple db MySQL dump

In an urgent situation another person made a backup of all the databases from my webserver to one *.sql file (MySQL dump). Now I have a ~700 Mb file with about 20 different databases. As I only need ...
0
votes
0answers
21 views

Can we add different log files for different databases in MySQL for recovering the queries?

I have a master master replication system for a single database. In mysql all the logs for a single database can be recovered through binlogs and relay logs. Now I'm adding another database for the ...
0
votes
1answer
92 views

Moving two databases from MySQL 5.1 [Prod] to MySQL 5.6 [Stage], not working [Windows]

I'm in the process of upgrading our production MySQL from 5.1 to 5.6, on a Windows Server 2008 R2 server. What I'm trying to achieve is to move 2 databases [say abc and xyz] from Prod server to a ...
1
vote
1answer
205 views

SnapManager Restore Wizard Slow

I don't know if NetApp SnapManager is a niche product. But the Restore Wizard is very slow, and I was wondering if anyone else had encountered this problem. I kill the SPID after 15 minutes of ...
1
vote
1answer
1k views

DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?

I read about ROLLFORWARD option on link http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001978.html?cp=SSEPGG_9.7.0%2F3-6-2-4-106 but I could not find ...
3
votes
1answer
2k views

mysqldump doesn't restore database. why not?

Why doesn't my restore operation work? I created a dumpfile for a database using: mysqldump -u root -p databasename > /home/databasename_bkup.sql I then opened the dumfile and confirmed ...
1
vote
1answer
792 views

DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option

I do restore command of backup image which was made 03.03.2015 at 19:20: db2 restore database maxdb71 from "/data/archiveBackup" taken at 20150303192002 without prompting; Then I try to do the ...
1
vote
0answers
100 views

Restore database from tape error 15105, cannot open backup device

I'm using HP Data Protector software to backup my SQL databases. When i try to restore a database from tape i get the following error. When i click on script, it says this: RESTORE DATABASE ...
0
votes
1answer
94 views

Restoring SQL Server database on another box

I have a SQL Server database that is running these scripts to create backups. It's running full backups once a week, daily differentials, and hourly logs. These are being FTPd to another box where I ...
4
votes
1answer
3k views

Restore master database from SQL Server 2008 R2 on SQL Server 2012

I have a process that restores all my backups on a centralized server for testing. I have recently upgraded this server to SQL server 2012, and now I am getting an error when restoring master from SQL ...
7
votes
1answer
614 views

Unable to restore (error 3456)

I have a situation that is not easy to figure out, and thought I'd ask on this forum if others might have suggestions. I'm running SQL Server 2008 R2 Standard SP3 on Windows Server 2008R2 Enterprise. ...
-1
votes
1answer
20 views

mysql database table corruption [closed]

Today when I opened MySQL database and I couldn't see very important table which were present/created about couple months ago. Yesterday I worked on it. Do you have some suggestions, how to get my ...
3
votes
1answer
80 views

Tool for quickly backup and restore a table

Is there a tool for quickly backup and restore a table's data, preferably to a csv file? It would be best if I could do it using batch. Run a .cmd file and data is backed up into a file with datetime ...
4
votes
5answers
4k 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?
1
vote
1answer
542 views

SQL Server differential backup LSN values

I'm looking at restoring databases on SQL Server and I'm not understanding something related to the LSNs. Here is a screenshot from the Restore Database dialog in Management Studio for a sample ...
1
vote
0answers
21 views

How to group SQL Server files for restoring database [duplicate]

I have a SQL Server database that is creating full backups once a week, differential backups once a day, and transaction log backups hourly. These are being FTP'd to another box, where I would like an ...
0
votes
1answer
136 views

Recovering Mysql - how to get a dumpfile from wampserver and none running db

I had the following: - Wampserver/mysql/drupal + batch file with auto backup by use of mysqldump. - Backup was distributed off and online. then : my laptop was stolen :-( and I need to recover ...
0
votes
0answers
280 views

MySQL Database Restore Failed With Obscure Error

I was importing a dump from another system into a MySQL database running on 64-bit Linux Mint when I got the error below.:- 12:42:37 Restoring Patient (Results) Running: mysql ...
0
votes
0answers
221 views

pg_restore certain tables only

I'm looking for a way to use pg_restore to restore a newly-created database from a dump file, but only certain tables from that file. (There are a lot of extra tables in the database that are slow to ...
0
votes
2answers
252 views

Recover data in a SQL Server table without backups [duplicate]

We are having a database without backup to restore. (we didn’t keep backups as client not having enough space in his SQL Server 2012). Unfortunately some data has been lost and we need to recover ...
-1
votes
1answer
103 views

full windows server backup with database files but not backed up through sql server

I am new to this and I have been backing up a windows sbs2011 server each night doing a full backup. The sql files are included but not backed up using sql backup program. Now one of the database ...
4
votes
1answer
6k views

Restoring a SQL Server 2012 database in high availability

I have a database which is in always-on high availability mode synchronized with another database on a different instance. How can I restore from a .bak file into the primary database using T-SQL? ...
1
vote
0answers
123 views

Setting up a new db-server with same name and ip. Backup/restore or detach/attach

I'm planning to set up a new Win 2012 server, with SQL server 2014 standard. This server is going to replace our current server, Win 2008R2, with SQL server 2008R2. The name and ip is going to be the ...
2
votes
3answers
543 views

How to restore a database then upgrade it in a single SQL script?

I'm trying to write some SQL that will restore a backup if the database doesn't exist, then run SQL on the database. It is used for installing a database we received from a 3rd party in the form of a ...
0
votes
1answer
95 views

Order to restore system and user databases

We are going to move an sql instance to a new physical server (SQL SERVER 2008 r2). The answer to this question explains how Agent jobs and ssis-packages will be moved by restoring the master and ...
0
votes
1answer
196 views

Orig DB = No Corruption, Backup/restore = Corruption?

We are setting up offline DBCC checkdbs on an offline server so we can still do our checks, but not interfere with production. When we backup the Master DB and restore it (even directly on a local ...