Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snowman
Starting Member
3 Posts |
 Posted - 2010-05-15 : 09:15:49
|
| Hi, I'm new here but I'm hoping someone can give me some help with a MAJOR problem I have. In a nutshell my server crashed for my business and I lost my main database file after replacing a raid drive and running chkdsk/f. I had a backup copy of the database from 4/1/10 that I tried to restore and I get an error message that says "The media family is incorrectly formed" etc. This is the only backup copy I have left of my database that's recent. Is this file corrupt and if so is there anyway to fix it? I was running Server 2000 with SQL 2000. I'm trying to restore using Server 2003 and SQL 2000. I'm not a programmer or IT guy so please be easy :) |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-15 : 10:17:07
|
| The backup is damaged and not restorable. You may (emphasis MAY) be able to restore it on a SQL 2005 or SQL 2008 server using the CONTINUE_AFTER_ERROR option. It depends how severe the damage to the backup is. Even if it does restore, there will be data lost. How much and what, no way to tell.You're sure it previously was a SQL 2000 server? This is an error that may appear when trying to restore a 2005 or 2008 backup to SQL 2000.--Gail ShawSQL Server MVP |
 |
|
|
snowman
Starting Member
3 Posts |
Posted - 2010-05-15 : 10:27:46
|
| Yes it was done on SQL Server 2000 but I've booted my server from an IDE disk that's running Server 2003 for an OS instead of Server 2000 now. |
|
|
|
snowman
Starting Member
3 Posts |
Posted - 2010-05-15 : 10:28:49
|
| Can anything be done by a data recovery company or am I out of luck here? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-15 : 12:43:56
|
| I'm not talking about the OS. That's totally irrelevant here. I'm talking solely about the version of SQL Server. SQL Server 2000, SQL Server 2005 or SQL Server 2008. No idea about the data recovery. Unless they know how to read a SQL backup file, it's not likely they'll get anything out. Most data recovery services are about reading damaged drives. Try if you want, they're not generally cheap.--Gail ShawSQL Server MVP |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-15 : 13:22:57
|
Anything that can be rescued off the old disk?Copy of the MDF / LDF? (It would help if you had a copy before trying to restart SQL [and discovering that you had a problem] - did anyone take a complete system backup at that time, for example?Any database backup files on that disk? (rather than what you are currently using which, perhaps, was restored from tape?Are you:1) backing up the database direct to tape (e.g. using BACKUP EXEC)2) Backing up the database to a file, and then backing up that file to tape?And/or 3) Are you backing up the MDF/LDF direct to tape (either in addition to the above, or instead of)They are all long-shots, but knowing the answers to them might give us some options.I would try restoring an older backup, to make sure that you can. It might be that some data can be rescued from latest backup, but you might want to "merge" that into an earlier, more complete, version.When all this is done/sorted pls come back for some suggestions on bolting the stable door properly  in future |
|
|
|
|
|
|
|
|
Corrupt backup file from SQL 2000