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)

1
vote
5answers
282 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
317 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
824 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
315 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
82 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
253 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
62 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
206 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
91 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
200 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
713 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
97 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
93 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
557 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
79 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
517 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
135 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
268 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
207 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
219 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
98 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
119 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
527 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
93 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
188 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 ...
0
votes
2answers
576 views

can we transfer sql database backup from one server to another server directly?

I want to transfer sql database from one server to another server directly, instead taking back up of that database and copy that back up in another server and then restore it. Please tell me, Is ...
1
vote
1answer
793 views

Restore a WordPress database from .frm and .idb only

I had a WordPress website running a long while ago. I used WAMP server. Then, I uninstalled WAMP. Today I would like to work again on my website; all that remains of my database is this (I cannot find ...
2
votes
1answer
37 views

MySQL InnoDB restoration from hardware failure

One of my server went down due to old hardware failure on a old Dell server that's over 10 years old. I was able to recover the files and got it to a local machine. I want to restore a MySQL instance ...
2
votes
2answers
73 views

Copying a database that is in Retore status

I have a database that needs to stay in restore mode (NonRecovery), I receive a new group of log files that I receive daily that I have to post to it. How can I copy the database while it is in non ...
0
votes
0answers
245 views

How to merge exported SQL Data into restored DB updating only changed rows?

We've just moved two databases from Microsoft SQL Server 2008 instance to another using BACKUP DATABASE on the original system and then RESTORE DATABASE on the new one. Everything went fine but then I ...
1
vote
3answers
651 views

Finding Database Default Locations

I am working on creating a script to restore database from a backup file to default location of an instance, which is set away from system databases installation folder. Currently, I'm using to find ...
0
votes
1answer
406 views

SQL Server - Error 3202 during Restore

While attempting to restore a 4 TB MDF/data database with a 1.8 TB LDF/log file, I'm receiving the following error: Write on '???' failed: 1117 (The request could not be performed because of an I/O ...
0
votes
1answer
56 views

Restore back up strategy for history tables

I have historical/log tables which are: very large holds data that is not rarely queried only inserts are performed (constantly, very often) I want to either compressed them or move them to ...
0
votes
1answer
46 views

How to maintain database ownership restoring across domains?

I am working with a vendor who is developing a SQL Server database outside of our domain. Occasionally, they need to deploy a new copy of that database into our domain by backing up their database, ...
4
votes
1answer
1k views

SQL Server 2008 R2 Restore constantly hanging

I have a SQL Server 2008 R2 SP2 test server that I have to refresh the databases on fairly often, but every time I have to do a restore on, it will hang on me. I use a custom script to check the ...
0
votes
1answer
229 views

Save and restore specific tables

in an Oracle 11.2 Database, Enterprise Edition, we are running calculations divided into 3 different "modules". These modules can be started on their own, but not parallel, so in between users are ...
4
votes
2answers
2k views

SQL Server Restore DB from MDF file, lost LDF and DB was not cleanly shutdown

My dev DB server was formatted by some admin without my knowledge. Thankfully I had mdf file kept in some other drive but ldf was in its default location. Since I don’t have DB backup I am now left ...