March 22, 2008 at 5:41 pm
I have a backup from Saturday and the differential backups are all somehow not Microsoft Tape Compatible. And, there are no log backups. Is there anyway to dump all the data out of the mdf file and put it into a new database?
I really need some suggestions, this is a production database. Thanks in advance.
March 22, 2008 at 8:33 pm
Maybe you could explain the problem and we might have ways to help.
You can copy the database a few ways, but I'm not sure how that changes your backup process. You can backup and restore to a new database, tape not needed. Or you can detach the database, copy the mdf/ldf files, and attach both copies, using two names.
March 23, 2008 at 7:14 am
It is a small database with only a few tables. I ran DBCC CHECKTABLE with repair options and was able to query the data in the query analyzer. I saved the results as csv files since I couldn't bcp out the data. I plan on Restoring the Saturday backup and then importing data from the csv files into the tables. There is some loss of data in one table. The sat backup has more rows vs the repaired table so I plan on keeping the saturday data for that table.
The backup strategy will have to be revisited.
I purchased a tool online that helps repair data files. It is called Kernel for sql databases. It didn't do anything or I don't know how to use it.
Thanks for your help.
November 25, 2008 at 4:14 pm
There is another option . . . .
Set the SQL Server so that changes may be made to system catalogs (RC Server in EM, Properties, Server Settings). Update the status value for that database in sysdatabases to 32768, stop/start SQL Server service (DB now in emergency mode). Then, create a new DB and DTS the tables and views over to the new database.
November 25, 2008 at 4:36 pm
Lucas Davenport (11/25/2008)
There is another option . . . .Set the SQL Server so that changes may be made to system catalogs (RC Server in EM, Properties, Server Settings). Update the status value for that database in sysdatabases to 32768, stop/start SQL Server service (DB now in emergency mode). Then, create a new DB and DTS the tables and views over to the new database.
Have to make an assumption here that this is SQL Server 2005, based on the forum posted. SQL Server 2005 won't allow you to make changes to the system tables.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply