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)

0
votes
1answer
26 views

Point in time restore fails - backup file from before the restore point not available (why does this matter)

I have tried to do a point-in-time restore of a database through the management studio gui, the point-in-time being yesterday morning (2016-04-12). This fails with the error "...cannot open ...
1
vote
1answer
20 views

mysql restore specific date data from a dump file

I have mysql [version 5.6] database dump file. I want to restore only one day data from that dump file. Anyone has any clue ?
0
votes
0answers
31 views

Restoring a mysql database from raw files found in a mysql folder

My webhost screwed me. The dedicated server I had had a failed hdd and I lost the drive. I backed up all files but not the databases. I was able to save some MYI and MYD files but no able to do a ...
0
votes
0answers
22 views

Here there is any way to read or open binary files that exists in Filestream enabled RBS folder?

There is a sharepoint content database configured with Remote BLOB Storage. if any user upload documents to sharepoint it saved in RBS folder as a binary file and it has reference to content database ...
1
vote
1answer
24 views

Problem when extracting the structure of DB2 (Back up Structure)

I want to extract the structure of a 9.7 DB2 database to use to clone it but some of the authorization statements are missing afterwards: I tried something like this: db2look -d dbName -a -x -o ...
0
votes
1answer
35 views

SQL database restore [closed]

I accidentally overwrite with existing database with new database while restoring in MS SQL Server 2008 R2. Actually the existing database contents were overwritten with the new database schema. ...
0
votes
1answer
21 views

How to restore a transaction log

Could you tell me the reason why it is mandatory to restore the full backup with NORECOVERY option before restoring the transaction log? otherwise Transaction log is always grayed (Task -> restore -> ...
0
votes
0answers
97 views

Database as it is raw content

recently I asked my hosting company to give the backup of my database . I asked them to create a new database and import backup to that database. But they reply cannot dump database ...
0
votes
0answers
12 views

Restore database exported with database_to_xml

I've exported a database to a XML file using the database_to_xml command found in documentation. Now I want to perform the opposite task. I want restore the database from an empty one using this XML ...
0
votes
2answers
48 views

UnShrunk SQL Server database restore which is larger than available disk space

I cannot restore a Microsoft SQL Server database due to lack of hard drive space. The original database was 1.6TB and approximately 1.4TB was deleted from it and a backup was taken without shrinking ...
3
votes
2answers
87 views

Restore Database with Move Failure

I am attempting to automate restoring .bak files on a secondary database in the case of a primary server failure. Both servers are SQL server 2014. Here is a sample SQL script: USE master GO ...
1
vote
1answer
106 views

Restore accidentally truncated table

I truncated the wrong table, but I have a backup made an hour before the incident. I am trying to restore but at 30% I get the error: Restore of database 'msdb1740' failed. (Microsoft.SqlServer....
0
votes
1answer
29 views

How to restore truncated MySQL table from binary logs?

I have a mysql server and while working on it I accidentlly truncated the wrong table. I do have a mysql dump wich I immediately used to restore my database structure, but I still miss some entries in ...
1
vote
3answers
690 views

Oracle 11g ORA-01190: control file or data file 1 is from before the last RESETLOGS

I am running Oracle 11GR2, Enterprise Edition Release 11.2.0.3.0. I got one of my Test DBs corrupted today. Luckily, I have 2 weeks of backups in the Net Backup server, so I thought, "This is easy, ...
0
votes
0answers
24 views

mysql backup does not restore complete

I have big mysql database back ( 2.5 G as .sql file ) I restore this backup on ubuntu and it restored full complete with out any problem But when I restore it on windows with xampp use below command : ...
0
votes
0answers
10 views

mysql backup does not restore complete

I have big mysql database back ( 2.5 G as .sql file ) I restore this backup on ubuntu and it restored full complete with out any problem But when I restore it on windows with xampp use below command : ...
0
votes
1answer
76 views

Restore deleted record from a table

I got a call today from the platform owner, there was a bug in the code and some records got deleted over 2 weeks (3 records every day on average). He gave me a list with the records and when they ...
0
votes
1answer
52 views

SQL Server Backup - move to new server - Media Failure

I've got a server in the UK with SQL Server 2008. It's very locked down firewall-wise. We want a local duplicate of the DB to test and build a new report. Backing up the relevant DB, and then ...
1
vote
3answers
79 views

Restore multiple databases quickly - practicing disaster recovery

I am currently working administering a SQL Server 2014 Standard Edition instance for Sharepoint 2013. We started 5 month ago with ~25 DB's and now we have 60 in total. So the databases in use are ...
1
vote
0answers
41 views

Why does my differencing virtual disk grow so much after restoring a differential SQL Server backup?

Inspired by RedGate's upcoming SQL Instant Clone, I'm using virtual disks to store my test database and gain fast clones via differencing disks. I created a 30 GB VHD and restored a 18 GB database ...
0
votes
1answer
74 views

Restore Database Wizard not launching

I'm using SQL Server Management Studio 2012 and trying to use the 'Restore' functionality to copy an existing database into a new one. This is something I've done a dozen times before, but I'm ...
0
votes
1answer
53 views

Is it possible to restore a database from 10.50.4033 in 10.00.1600

I did one project for my last year exam I want to restore a database. Is it possible to restore a database from v10.50.4033 to 10.00.1600. If yes, how is this possible.
3
votes
3answers
115 views

Improve Restore Speed

I have a ~3GB backup file from our QA database, and a daily diff (~500MB). For data complexity reasons, some of our developers like to use regular backups from this database, and so we have a process ...
0
votes
0answers
34 views

pg_restore -c option

I am trying to restore a database from a previously created back up file: pg_restore -U myUser --port 5432 -d mydb -c -O --verbose backupFileName some defaults are taken from .pgpass file. Due to ...
0
votes
1answer
43 views

Backup chain for DBs restored from a different server

When a DB is restored from a different server (say, Test is refreshed with Prod), the info on the differential base is brought with the backup. So, the SQL instance will keep relying on the backup ...
0
votes
2answers
76 views

SQL Server database stuck in Recovery after Restoring .BAK to same instance

We've had an issue crop up a few times -- maybe we're not using 'best practices' to restore, but appreciate any advice. We run an IIS app with a SQL Server database, and sometimes we run two+ ...
1
vote
1answer
52 views

File permissions for SQL Server 2014 virtual account

I have two SQL Server 2014 instances installed on the same server - one for production, and one for development. I have set up a SQL Agent job that identifies the most recent backup from the ...
2
votes
1answer
72 views

Can I use an RMAN Backup of DB1 to replace DB2

I have a backup of an Oracle 11g database on Linux, that is a version that is 'prescrub' needed by other users. This is for an ACTIVE database that is now scrubbed, so I do not want to use it as the '...
1
vote
2answers
90 views

How to estimate REDO phase time during RESTORE

I am restoring database now and get it hang on 100% but still going (doing redo phase). I am thinking how to estimate time of completion for this phase. But because SQL have no build-in way to do it, ...
3
votes
0answers
44 views

What is Data Virtualisation?

I've just been asked whether our company should consider Data Virtualisation for our test environments. The benefits are given as: Screening of sensitive data Fast data refreshes in our test ...
0
votes
0answers
16 views

SQL Server users when restoring from older version to newer version WITH REPLACE

Let's say we have a SQL Server 2000 database with a user named user2000. We have a database called foo on SQL Server 2000, to which user2000 has been given access. We also have a SQL Server 2008 ...
0
votes
0answers
40 views

Rds snapshot restore time

As part of our blue greendeployment strategy we are snapshoting the prod RDS instance and then restoring this snapshot into a new instance applying db migrations after it and linking the Green ...
1
vote
0answers
74 views

Why does SQL Server's RESTORE VERIFYONLY command fail intermittently?

Our maintenance scripts run RESTORE VERIFYONLY WITH CHECKSUM after each database is backed up to our backup server. A few of the databases often fail with the error shown below. But if we re-run the ...
0
votes
0answers
78 views

MYISAM can't create table: Row size too large

We are having database in MySQL 5.1, we have taken the DB backup from MySQL 5.1 and trying to restore in MySQL 5.6. We are getting below error: ERROR 1118 (42000) at line 603: Row size too large. ...
3
votes
1answer
261 views

Error 909 restoring a database on Standard Edition

I ran into a problem with SQL Server 2012 Standard Edition (64-bit). I have rebuilt a system with the exact same specifications for software as it had been built previously (Windows 2012, SQL Server ...
1
vote
1answer
102 views

Between optimizing a 1-billion rows table and dump-restoring it, which would be faster?

Have multiple tables which had more than 1 billion rows. Archived and deleted many of them, now want to recover the disk space. Have option to either optimize the table, or dump the table and restore ...
1
vote
0answers
47 views

Trying to restore a db2 database but stops at roll-forward with error 'SQL1265N'

I'm trying to restore a backup that is older than the current database. The restore went ok, but the roll forward didn't giving the following error: SQL1265N The archive log file ".LOG" is not ...
3
votes
2answers
989 views

Unable to create restore plan due to break in LSN chain

My backup plan is: Full backup - once a day Differential backup - every four hours Transaction Log backup - every 30 minutes. All database backup are stored on my computer. I add some wrong ...
0
votes
0answers
96 views

How can I restore a MySQL dump faster on Windows?

I am restoring some InnoDB and MyISAM .sql files that are on the order of GBs (ranging from 1 GB to ~ 10GBs) and they are taking a day or longer to restore. The command I am using currently is: use ...
0
votes
0answers
94 views

Postgres, promoting slave to master issue

We had the following setup in place db01 -> Master Postgres 9.3 db02 -> Slave Postgres 9.3 Master data got corrupted (logically) and as soon as it was identified we shutdown the server. Dev team ...
1
vote
1answer
44 views

Restore from SQL Server 2014 Enterprise to BI

Is it possible to restore a SQL Server 2014 Enterprise database with table partitioning (Production) to a SQL Server 2014 BI Version (Test/Development) ? Of course I don't expect to use the table ...
4
votes
2answers
649 views

Restore database to point in time from full backup only

I have a database with recovery mode set to FULL. It's a dev database and I have two full backups dated 19th and 27th i.e. latest. One of the developer did some changes on 26th and I want to rollback ...
0
votes
1answer
28 views

Scenarios in which you might need to restore large number of databases at once?

I've seen several online sources mentioning that you should always have a restore script automated for the possible need to restore a large number of databases at once and quickly get back up and ...
8
votes
2answers
435 views

Shrinking a SQL Server Transaction Log

I’m currently having to deal with a SQL Server transaction log that has got out of control. Disclaimer: I’m not a dba and this isn’t my area of expertise so please bear with me. Currently I have a ...
0
votes
1answer
77 views

Lost connection to mysql while restoring dump. Is it safe to resume?

I was in the process of restoring an sql dump to a newly created RDS mysql instance on AWS. The dump was created with the following command: mysqldump --all-databases \ --single-transaction \ --...
0
votes
1answer
54 views

Restored database from .bkp file in SQL Server 2014 generates some strange errors [closed]

I have restored the well-known Northwind database and executed a trivial query: Notice the strange error "Invalid object name..." although the query has been executed successfully and both tables ...
1
vote
0answers
42 views

Backup creating fork_point

I have a powershell script that is restoring from production into a test availability group database. It copies the full and t-log backups from production to test, takes the target db out of the ...
16
votes
1answer
704 views

Restore Database using GUI - Wrong file to restore

I'm just messing around with the SSMS graphic interface and studying the options of the "restore" task. One thing that I noticed is when I click on "generate script", the first line of the query is: ...
3
votes
1answer
141 views

Unable to restore database because it exists, unable to drop because it does not exist

I've seen this mentioned a couple of times but none of the suggested solutions worked for me, so I'm posting a question together with a solution in hope that it helps someone else. During restore of ...
0
votes
0answers
36 views

mysqldump: restored by mistake with no backup

While trying to take a mysqldump on a database, we have by mistake run a restore command mysql -u -p abc.sql <abc.sql. This has resulted in the abc database going back to a state 5 days back when ...