| Author |
Topic |
|
Michael Voronov
Starting Member
5 Posts |
 Posted - 2008-04-25 : 09:39:16
|
| 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
30421 Posts |
Posted - 2008-04-25 : 09:45:18
|
What is the command you type and run in QA to attach the database?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-25 : 11:39:42
|
| How can you say defective ? Post the complete files? Is it MDF? you must be confused with Backup files? |
|
|
|
Michael Voronov
Starting Member
5 Posts |
Posted - 2008-04-25 : 16:27:51
|
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. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-25 : 16:46:25
|
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" |
|
|
|
Michael Voronov
Starting Member
5 Posts |
Posted - 2008-04-25 : 17:08:06
|
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 & *.ldf3. I haven't backup files. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-25 : 17:17:08
|
You could try to only attach the MDF file.What happens then?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-25 : 21:47:58
|
| >> The file you've specified is not a valid SQL Server database file.Where did you get those files? |
|
|
|
Michael Voronov
Starting Member
5 Posts |
Posted - 2008-04-26 : 01:56:58
|
| 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. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-26 : 10:16:01
|
| Looks like those files are corrupted based on error in your first post. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-26 : 11:26:07
|
| Don't you have any backup in place? |
|
|
|
Michael Voronov
Starting Member
5 Posts |
Posted - 2008-04-28 : 06:42:41
|
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. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-28 : 14:17:56
|
| 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 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 14:21:22
|
| 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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
Restoration of defective database