Top "Database-restore" questions

restoring original MDF file from bak file

I've got a bak file (which is a backup database file for a SQL server express 2005 mdf file) and I …

sql-server database-restore
How can I pipe output of bzip to mysql to restore data directly from bzipped file into a database

For making a dump of a database directly in bz2 format, I tried zipping the dump file directly using pipes, …

mysql linux command-line pipe database-restore
Recover deleted record in SQL Server

I accidentally deleted a row in a table and want to restore it. I've found a solution here: How to …

sql-server sql-server-2005 database-backups database-restore
bak file not visible when trying to restore database

I am trying to run a classic asp project on visual studio and therefore I am trying to restore a …

sql-server database file-permissions restore database-restore
Remove (merge) SQL Servers' database secondary data file

I have a database backup for which SQL Server Management Studio says that it has three files in it: an .…

sql-server-2008 database-restore data-files
media family on device is incorrectly formed. SQL Server cannot process this media family

I am trying to restore a .BAK in SQL server but get the following error: Msg 3241, Level 16, State 7, Line 1 The …

sql-server backup database-backups database-restore
Database stuck in restoring state

Last night I had a database that had it's data and log files physically removed without first taking the proper …

database sql-server-2008-r2 database-restore repair
SQL Job Agent DB Restore fails with error #6107: Only user processes can be killed

We have an SQL Job Agent that runs in the "wee hours" to restore our local database (FooData) from a …

sql-server database-restore single-user
How do I recreate an FRM file for an MySQL InnoDB table with only the ibdata and *.ibd files?

This is a slightly different question than the related InnoDB repair questions I have seen on stackoverflow. Assume that I …

mysql database innodb restore database-restore
SQL-Server: Cannot be overwritten. It is being used by database

RESTORE DATABASE Tes FROM DISK = '{7522204E-0256-47B3-9864-137D6D1FD449}6' WITH MOVE 'Test' TO 'C:\…

sql-server database-restore