SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoration of defective database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Michael Voronov
Starting Member

Russia
5 Posts

Posted - 04/25/2008 :  09:39:16  Show Profile  Reply with Quote
Hi guys,

There is the following problem. I have files of database (SQL Server 2000) are defective.
Then I try to attach it SQL Server give me the following error:
"The file you've specified is not a valid SQL Server database file."
I don't know how users had spoiled it, but I need to restoration it. That is very necessary.

What is any solution of this trouble?

Thanks in advance, Michael

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 04/25/2008 :  09:45:18  Show Profile  Visit SwePeso's Homepage  Reply with Quote
What is the command you type and run in QA to attach the database?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 04/25/2008 :  11:39:42  Show Profile  Reply with Quote
How can you say defective ? Post the complete files? Is it MDF? you must be confused with Backup files?

Edited by - sodeep on 04/25/2008 12:43:49
Go to Top of Page

Michael Voronov
Starting Member

Russia
5 Posts

Posted - 04/25/2008 :  16:27:51  Show Profile  Reply with Quote
quote:
Originally posted by Peso

What is the command you type and run in QA to attach the database?




I use the visual interface Enterprice Manager.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 04/25/2008 :  16:46:25  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Tell us step by step how you are trying to attach the database.
Everything. Where you click, what you type and so one...



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Michael Voronov
Starting Member

Russia
5 Posts

Posted - 04/25/2008 :  17:08:06  Show Profile  Reply with Quote
quote:
Originally posted by sodeep

How can you say defective ? Post the complete files? Is it MDF? you must be confused with Backup files?



1. I suppose it. I wanted to say this files are damaged.
2. *.mdf & *.ldf
3. I haven't backup files.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 04/25/2008 :  17:17:08  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You could try to only attach the MDF file.
What happens then?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/25/2008 :  21:47:58  Show Profile  Reply with Quote
>> The file you've specified is not a valid SQL Server database file.

Where did you get those files?
Go to Top of Page

Michael Voronov
Starting Member

Russia
5 Posts

Posted - 04/26/2008 :  01:56:58  Show Profile  Reply with Quote
Users (customers) had told me that MS SQL Server had crashed and after that they had reinstall it. After, they have tried to attach the database which is worked before SQL Server wreck.
They tell me that they attach the more old databases and everything is ok. Therefore I suppose that this db is defective.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/26/2008 :  10:16:01  Show Profile  Reply with Quote
Looks like those files are corrupted based on error in your first post.
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 04/26/2008 :  11:26:07  Show Profile  Reply with Quote
Don't you have any backup in place?
Go to Top of Page

Michael Voronov
Starting Member

Russia
5 Posts

Posted - 04/28/2008 :  06:42:41  Show Profile  Reply with Quote
quote:
Originally posted by sodeep

Don't you have any backup in place?



I have very oldest backup, about 3 month. A lot of data will be lost if I can't restore this base.
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 04/28/2008 :  14:17:56  Show Profile  Reply with Quote
Without a good, clean backup, it's not going to happen, you will lose data. The only question is, how much? You can attempt, as was suggested by Peso, attach only the .mdf file and keep your fingers crossed. It you can at least get it online, you may be able to repair it with minimal data loss. First rule to abide by: take backups at least daily (all depends on the business' tolerance for data loss). Second rule: make sure you can restore the backups and know your data is there. If they're your customers, it's your responsibility to ensure that this is in place (at a minimum!), whether it's you creating the jobs or them (with your guidance). You're learning a very hard lesson. Good luck.

Terry

Edited by - tosscrosby on 04/28/2008 14:18:24
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37134 Posts

Posted - 04/28/2008 :  14:21:22  Show Profile  Visit tkizer's Homepage  Reply with Quote
I'd open a case with Microsoft PSS to see if they can help. It wouldn't cost you much to find out for sure if you are going to lose 3 months of data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000