The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
26 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 ...
1
vote
1answer
36 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
1answer
132 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
1answer
136 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
47 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 ...
0
votes
1answer
489 views

No file access permissions after restore database

I have a strange phenomon. When I restore a SQL-Server 2012 database to a folder on my D-Drive, it gets restored just fine. I can access the database and basically it works fine. But when I check the ...
0
votes
0answers
106 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 ...
1
vote
1answer
604 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/ ...
0
votes
0answers
249 views

Mysql won't start after replacing data in datadir.

so I have a little problem. I had errors with our old system and was unable to backup the old databases properly so I went ahead and backed up the datadir which had all of the databases folders inside ...
0
votes
1answer
41 views

Problems restoring local instance in SQL Server 2008 R2 Express

I have set up a local instance in SQL Server 2008 R2. I have a database (called GD_LOCAL_TC) that I need to restore so I can begin working in it (right now it's empty). When I right click on ...
1
vote
2answers
70 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
1answer
377 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
127 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 ...
3
votes
2answers
8k 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
443 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
3answers
5k 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
357 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
128 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
120 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
1k 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
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
264 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
604 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
128 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 ...
1
vote
1answer
4k 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
452 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
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 ...
2
votes
2answers
109 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
109 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
167 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
118 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 ...
1
vote
2answers
3k 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
201 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
203 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
141 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
87 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 ...
3
votes
1answer
4k 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
463 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
551 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
766 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 ...
0
votes
2answers
416 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 ...
2
votes
3answers
333 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?
0
votes
1answer
211 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
4answers
890 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?
2
votes
1answer
397 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 ...
0
votes
2answers
1k views

Exchange 2003 NTBackup always fails

Running Exchange Server 2003, I run an online backup every 2 nights using NTBackup, the job succeeds and I can verify by check db properties in systems manager & logs in D:\Exchsrvr\mdbdata. I ...
1
vote
2answers
79 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
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 ...
0
votes
1answer
29 views

sql server 2005

how to restore deleted row from particular table .? i have tranct log file
1
vote
1answer
179 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 ...