The tag has no wiki summary.

learn more… | top users | synonyms

5
votes
1answer
384 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?
5
votes
1answer
441 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 ...
4
votes
4answers
5k views

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 ...
3
votes
1answer
3k 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 ...
3
votes
1answer
127 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
2answers
5k 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 ...
3
votes
1answer
199 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 ...
2
votes
3answers
327 views

What's the best thing to do when you accidentally delete things from a database?

What's the best thing to do when you accidentally delete things from a database that you shouldn't, restore from a backup?
2
votes
5answers
14k views

I accidentally dropped my MySQL database in PhpMyAdmin, is there a possibility to recover my database?

I accidentally dropped my MySQL database in PhpMyAdmin, is there a possibility to recover my database?
2
votes
2answers
256 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 ...
2
votes
2answers
499 views

Sql Server 2005 database lost, How to recover all records. MDF/LDF size is same as it should be

Few months back, I installed a sql server 2005 on one of my client machine. I gave him a backup option to take backup timely but he never took any backup. Today he called me that "i m not able to ...
2
votes
1answer
355 views

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 ...
2
votes
1answer
61 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
107 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 ...
2
votes
3answers
4k 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 ...
2
votes
1answer
746 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
622 views

Can a Shadow Copy of SQL 2000 databases files be used as a restore?

I have a SQL 2000 SP2 instance (version 8.00.760) that is on a drive that gets regular shadow copies. Can a shadow copy be used to restore the database? It seems possible to stop the SQL service, ...
2
votes
2answers
1k views

restore content database in sharepoint server 2007

I have a site collection set up at web app running at port 80. I have made the backup of the site collection content db using stsadm.exe tool. Now, I want to restore that backup as a new content db of ...
2
votes
0answers
165 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 ...
1
vote
1answer
3k 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
2answers
57 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 ...
1
vote
3answers
503 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 ...
1
vote
2answers
78 views

Reinstalled Windows on my development box, forgot to backup any of my work in progress databases in SQL Server Express 2008? Can i recover anything?

Reinstalled Windows on my development box, forgot to backup any of my work in progress databases in SQL Server Express 2008? Can i recover anything? I still have the files from the old install. Where ...
1
vote
3answers
6k views

How to restore the SQL Server model database?

Since a few days ago, when I try to start the SQL Server service, it fails with the following error logged to the NT Application Log: An error occurred during recovery, preventing the database ...
1
vote
1answer
26 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
383 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 ...
1
vote
1answer
191 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 ...
1
vote
2answers
3k views

SQL Backup - Restoring to different data / log files - Changing file structure…?

I'm trying to restore a BAK of a database we have, onto new, better hardware. Here is a screenshot of the UI in Management Studio http://twitpic.com/wmtr8/full The existing db has an mdf, and ndf ...
1
vote
1answer
297 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/ ...
1
vote
2answers
1k views

Error code 1005 (errno: 121) upon create table while restoring MySQL database from a dump

I have a linux prod machine and a Win7 64bit dev machine. My workflow includes dumping the production MySQL database on the linux machine and restoring it in my local MySQL database on the windows ...
1
vote
1answer
162 views

why restoring database never finishes?

I have really wired problems here. I am using MS 2008 sql server at the moment. After I did a tail-log backup, the target database is automatically restoring and keeping on restoring. Does anyone ...
1
vote
1answer
315 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'. ...
1
vote
1answer
310 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 ...
1
vote
1answer
108 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 ...
1
vote
2answers
2k 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 ...
1
vote
1answer
87 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 ...
0
votes
4answers
680 views

How to create empty database from existing one (Mysql)

I have a mysql db with many tables. I'm starting a new farm which should contain empty versions of the same database tables. How can I efficiently create empty database based on existing one?
0
votes
1answer
43 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
3answers
115 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 ...
0
votes
3answers
85 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 ...
0
votes
1answer
204 views

Rebuilding a MySQL database from 160 retreived files with no name

I had a server crash and it took with it the hard drive. I put the hard drive in a USB enclosure, but the main partition would not mount because the partition was corrupted. I was able to see the USB ...
0
votes
1answer
1k 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 ...
0
votes
3answers
140 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
490 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
2answers
365 views

automatic mysql backup in windows server 2003 [closed]

someone Know and can recommend me an open source program or freeware software to realize automatics backups in mysql under windows server 2003. I need automatize a task every day. A shareware ...
0
votes
1answer
29 views

sql server 2005

how to restore deleted row from particular table .? i have tranct log file
0
votes
1answer
697 views

MySQL Server - Got error -1 from storage engine

I am currently trying to restore a MySQL table from the .ibd file. I have been following the instructions on the MySQL reference manual on how to use DISCARD and IMPORT TABLESPACE to replace the .idb ...
0
votes
2answers
975 views

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 ...
0
votes
0answers
9 views

SQL Server Express Application Deployment Via CD

Our company has an ancient home-grown Win-32 application which uses a SQL Server Express db. We have a salesperson at a remote office who has no reliable internet and I need a way to package this app ...
0
votes
1answer
30 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 ...