Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-restore]

80 questions
6
votes
2 answers

Recover mysql database - mysql/mysqldump gives "table . 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 with Linux Mint because I was on Ubuntu 10.0.4 this…
Matthew
  • 273
  • 1
  • 2
  • 10
5
votes
1 answer

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 millions rows table is now full of garbage. Does…
Alexis Dufrenoy
  • 235
  • 1
  • 3
  • 11
5
votes
4 answers

Is the master database backup crucial for restoring MS SQL server in the event where you have to restore from backup and build database server from scratch?

I have been advise by Commvault partner support to turn off the backup of the master database as the backup failed due to the log file being lock. The following is the advise given: "The message is caused by Commvault’s inability to backup the…
Imagineer
  • 815
  • 2
  • 10
  • 20
4
votes
1 answer

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 theory can I restore databases from full windows…
Carlo
  • 45
  • 1
  • 5
4
votes
1 answer

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 backups sets in the file. I want to restore the latest…
DrStalker
  • 6,946
  • 24
  • 79
  • 107
4
votes
1 answer

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?
SteB
  • 989
  • 6
  • 15
  • 31
4
votes
1 answer

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 one machine at work, so I know that the backup is…
Matt Dawdy
  • 429
  • 1
  • 9
  • 19
3
votes
0 answers

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. Backed up the current schema using. **mysqldump -u…
Avinash Pawar
  • 31
  • 2
3
votes
2 answers

Excessive space required for SQL Server .bak restore

I am trying to restore a SQL Server 2008 (standard edition) backup to my dev machine using the production database. I get an "insufficient free space" error when doing so. SQL Server claims that it needs 43 GB free to restore my db, but the .bak…
ep4169
  • 157
  • 2
  • 4
  • 9
3
votes
1 answer

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-recovery on all levels 1 to 6 and a whole lot of other…
FabioG
  • 81
  • 1
  • 1
  • 5
3
votes
4 answers

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…
freedev
  • 323
  • 5
  • 17
3
votes
1 answer

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 my machine. I therefore want to transfer their…
Mike Q
  • 197
  • 7
3
votes
3 answers

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 using initDB and created a new database, I was…
Muthuvel P
  • 33
  • 1
  • 1
  • 4
3
votes
1 answer

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 name and it now thinks that restoring a database…
Jimbo
  • 309
  • 1
  • 5
  • 16
3
votes
1 answer

If I have full backup (.bak) and 3 differential backups (.dif) how can I restore them to a new database?

I need to check some old data. I need to check data from last night compared to data today. I am going to use SQL Data Compare to do this but I need to setup a fresh database to restore the backup to so I can compare it against the existing…
MetaGuru
  • 896
  • 6
  • 22
  • 36
1
2 3 4 5 6