Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database-restore]

The tag has no usage guidance.

2
votes
2answers
119 views

windows server backup. how to restore msssql database

it's theoretical question. If i have a window server 2012 r2 which have mssql server installed. I add role windows server backup. So can restore the database which was backuped by windows server ...
0
votes
2answers
354 views

R1soft error “MySQL restore already occurring for running instance, cannot continue”

I am using R1soft backup tool on my server(cpanel) and trying to restore the database backup but it gives me the error "restore failed". Attaching logs error here: Protected Machine: MySQL restore ...
1
vote
2answers
374 views

RDS Mysql point in time restore fails - incompatible state

I have an RDS MySQL instance with MySQL version 5.7.19 for which a point in time restore failed with a status of "incompatible-state". Through experimentation I have determined that point in time ...
1
vote
0answers
235 views

Got a packet bigger than 'max_allowed_packet' bytes

MySQL Community-Server 5.6.39 RHEL7 Scenraio: Trying to process binary logs to restore the incremental backup and receive max_allowed_packet error. Turned off binary logs,restarted the database. ...
0
votes
1answer
504 views

Oracle 12c schema restore using impdp from a different server

I have created 2 EC2 instances in AWS. One acts as DB Server and one acts as client. Oracle 12c DB instance is installed on DB server and Oracle 12c instant client on client server. I have ...
0
votes
2answers
351 views

Can't restore Google Cloud SQL instance

I'm trying to restore my Google Cloud SQL instance to a backup from a previous date: gcloud sql backups restore 1504554300110 --restore-instance=[MY-DB-INSTANCE] Ultimately, it keeps giving an error:...
0
votes
1answer
1k views

SQL 2012 Restore Issue - Exclusive Access cannot be obtained

Situation - We have a Live_db database, and a Test_db database. I'm trying to Take a copy of Live to use as Test. A Backup of Live was taken. The existing Test database was deleted (closing ...
4
votes
1answer
487 views

Can I restore SQL databases from full Windows server backup if needed

I have scheduled backup and every day copies of: bare metal recovery system state system reserved local disk C:\ Backup is stored on iscsi disk. On local disk C are databases mdf with logs. In ...
0
votes
1answer
37 views

Oracle RMAN full backup due to gaps in ARCHIVE LOGs

I've recently recovered a Data Guard configuration. Simple setup that syncs from primary to standby using Data Guard. Because it's been on-line for a sustained period, some logs are missing and I ...
-1
votes
2answers
722 views

restored Wordpress site from DB, wp-login.php redirects to old domain

We have a Wordpress .sql backup which we restored on a linux box. Now we want to log in to the admin console and export the site as XML. Unfortunately, the wp-login.php redirects to the old ...
2
votes
1answer
9k views

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the innodb-force-...
1
vote
2answers
999 views

Restore deleted exchange 2007 public folder from backup .edb file

We are running a stand-alone instance of Exchange 2007 without replication of any kind. We do have nightly backups. A user deleted a public folder, and I need to restore that from one of our full ...
0
votes
3answers
14k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
1
vote
1answer
85 views

Why does SSMS Restore Database to another database not copy the current state of the “From” database?

When copying a database by using the Restore Database functionality in SSMS, why is it not a copy of the current state of the Database? After performing the Restore From Database Bar to Database Foo, ...
1
vote
2answers
1k views

How can I restore an Exchange 2010 mailbox to its original state after the mailbox has been deleted?

In our environment we are running Exchange 2010 with NetBackup 7 and Symantec eVault. We have global 25 year retention and no purging policies (insane, but that's what the boss wants). We use eVault ...
4
votes
1answer
4k views

MSSQL: Restore a DB to the latest file in a backup set

I have a MSSQL 2008R2 DB in SIMPLE recovery mode that is periodically backed up with BACKUP DATABASE MyDB to DISK = 'Z:\MyDB.cbak' WITH COMPRESSION This runs periodically, creating multiple ...
0
votes
1answer
252 views

Can you restore multiple Oracle databases with the same tablespace name?

I am in the process of setting up an Oracle instance for customer database restores. The vast majority of our customers use the same tablespace name for their databases, which leads to us needing a ...
1
vote
1answer
2k views

No file access permissions after restoring database

I restored an SQL-Server 2012 database to a folder on my D-Drive. I can access the database and everything seems to work, but when I check the file access permissions of the mdf and ldf files, there ...
0
votes
0answers
151 views

no access to preivous databases in mysql56 after password reset, but showing in data folder

i had problem with mysql (windows machine, mysql5.6) login because of power failure, after trying various solution, i did password reset for root. This helped me to login mysql using root account. But ...
3
votes
4answers
3k views

mongorestore from stdin

On a remote server I have a file which is the mongodump output compressed, let me say a file called mongodb.tar.gz. Inside mongodb.tar.gz there is a directory structure like this: dump/dbname/ dump/...
1
vote
2answers
171 views

MySQL transfer from backups

I had a server die and I have been trying to restore the data onto a new server. I had a mysql database. I have all the files stored in /var/lib/mysql. Each database had a database privileges ...
2
votes
1answer
1k views

MySQL ZRM restore failed with mysql error unknown command \0

I am restoring an incremental backup with ZRM server on mysql database. I am having blob data in the tables. The incremental backup not getting restored and giving mysql error unknown command '\0'. ...
0
votes
1answer
250 views

Recovering InnoDB

Bit of tough situation. Running MySQL 5.5 on Ubuntu 12.04. Looking to add some functionality to our internal site, I installed Kaltura. In doing so, my existing MySQL databases seemed to lose all ...
5
votes
2answers
33k views

Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”

Backstory Ubuntu died (wouldn't boot) and I couldn't fix it. I booted a live cd to recover the important stuff and saved it to my NAS. One of the things I backed up was /var/lib/mysql. Reinstalled ...
5
votes
1answer
752 views

MS SQL Server DB version without restoring?

Is there a way of telling which version of Microsoft SQL Server a database backup is from without restoring it?
2
votes
2answers
12k views

Recover MySQL tables from frm files

I'm desperate, and hoping some kind soul can rescue me! I'm dealing with restoring a completely crashed server. Everything is back up except for there's an issue with one domain which uses MySQL (no ...
1
vote
1answer
754 views

Recovering/Rebuilding MySQL .FRM, .MY* files from IBDATA1

I recently had an incident in which several MySQL files were wiped out (mostly from WordPress, but also a few of MySQL’s own files). The IBDATA1 file is unaffected, but several .frm are gone as are a ...
0
votes
1answer
173 views

PostgreSQL 9.1 won't restore because “a user is connected”

I'm transferring a database as part of transferring a website. I've not used PostgreSQL before, so assume that I don't know much about it (I primarily use MySQL). We cannot directly connect the ...
0
votes
1answer
192 views

selectively import “record sets” from one mysql instance to another

I have a mysql server hosting a production database, and routinely I make snapshots of it, which we can also use as a staging environment. Sometime bad things happen, e.g. we delete a row (and all ...
2
votes
1answer
3k views

Restore SQL Server 2008 db without affecting users

When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA ...
2
votes
1answer
71 views

Copy a database from Denali CPT3 to SQL 2008 R2

Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a ...
2
votes
2answers
387 views

Hosting server's harddisk crashed [closed]

My hosting provider has told me that the server harddisk that I am currently using is crashed and they failed to recover most of the data and they only managed to recover some files or folder from the ...
1
vote
3answers
1k views

Restore MySQL Databases from File backups, not MySQL Export

I've got a Windows Server and I get Windows Server Backup to backup all the files every day. I don't however have a system image so I cannot use that. I've tried just copying the database files into ...
3
votes
1answer
144 views

SQL Server backups - transferring between instances

I work in a development shop where we primary use SQL Server for our day-to-day development and testing. Sometimes issues occur on someone's machine, often a labtop, that I would like to reproduce on ...
3
votes
3answers
13k views

How to restore a file system level copy of a PostgreSQL database (not dump) to a different PC

I am new to PostgreSQL. I have to recover a database which was running in widows XP machine. I have the zip folder of postgres. I have extracted postgres installation in a different PC and started a ...
1
vote
3answers
1k views

What's the most efficient way to reclaim disk space after deleting lots of data from a database on Sybase ASE 15?

As I understand it, based on some research but zero real-world experience with Sybase ASE, the only way to reclaim disk space once it's been allocated to a database is to export that database, create ...
0
votes
1answer
3k views

How do I restore MySQL .frm .MYD .MYI files in OS X Lion [duplicate]

Possible Duplicate: How to restore mysql database from the physical files? I received a bunch of these types of files and haven't a clue as how to restore the database on my Mac. I've found ...
2
votes
2answers
121 views

Restoring a SQL database in a production environment as an update mechanism

I'm a sysadmin who has recently been landed with some SQL DBA responsibility. Not reluctantly I might add, this is a world I'm very much looking to get immersed in. I am curious about one of the ...
1
vote
1answer
120 views

Remote restore of DB in MSSQL 2008

I have a remote MSSQL server meant to centralize SQL for development projects. I hand out DB's and access to developers as they need it. I do not want to give them access to filesystem in any way (...
2
votes
0answers
187 views

Exchange 2003 / 2010 Public Folder Restore or Sync Tool needed

What tools exist to restore public folder data? If nothing will assist in (exmerging) PF data, what tools exist to sync data between backup sets?... between forests? It seems that pfdavadmin was ...
0
votes
3answers
136 views

Mysql data recovery

The linux machine on which we have the mysql has crashed due to a power failure. This probably caused the mysql server to crash too and we are not now able to restore/backup/export the database from ...
2
votes
2answers
5k views

Unable to restore a Mysql database using an sql dump file

I am setting up a new project on my development system and am stuck with creating the database. I have a large .sql file to create the database with. At first I created an empty database called ...
3
votes
1answer
214 views

How do I remove an old SQL Server 2008 Express Database Instance

I am trying to restore a database over the existing one. This worked fine in the past, until all of a sudden, it doesnt. I have clearly, in the past, attached the same database file under a different ...
1
vote
1answer
349 views

MySQL Database Restore error

Getting the following error: ERROR 2006 (HY000) at line 530: MySQL server has gone away Which I get after running the following from the MySQL (5.1.53-community) command line: CREATE DATABASE ...
0
votes
3answers
214 views

Quickly revert an Oracle Database to a known state

I would like to use Selenium to test a web application but in order to do that successfully the tests must be run against a database at a known state. The recording and running of the Selenium tests ...
0
votes
3answers
95 views

Sql Server Database Restore with Management Studio

So I am performing a daily full database backup (midnight) and I am backing up the transaction logs hourly. All backups are done in separate files per database with timestamps. Now say if I want to ...
4
votes
1answer
7k views

Error restoring database from backup

I've got a backup of my SQL Server 2005 database that I want to put on my dev machine (much quicker to develop against than via writing queries through remote desktop.) I was able to restore this on ...
5
votes
1answer
682 views

Mysql disaster recovery

We just got a major disaster: somebody made an uncontrolled update on the production database, and obviously, the backup process is not working since a long time, so we got a major data loss. A 40 ...
0
votes
3answers
828 views

Restoring a backup SQL Server 2005 where is the data stored?

I have two Sql Server database instances on two different machines across the network. Lets call these servers A and B. Due to some infrastructural issues, I had to make a complete backup of the ...
0
votes
3answers
1k views

MSSQL 2008 R2- Restoring MASTER database from v10.00.1600 to v10.50.1600 fails with error

I backed up the master database on a machine with SQL Server 2008 version 10.00.1600. Then I turned on SQL Server in single-user mode on the new machine with SQL Server 2008 R2 version 10.50.1600 with ...