| Author |
 Topic  |
|
|
Michael Voronov
Starting Member
Russia
5 Posts |
 Posted - 04/25/2008 : 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
Sweden
29138 Posts |
Posted - 04/25/2008 : 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
Flowing Fount of Yak Knowledge
USA
7173 Posts |
Posted - 04/25/2008 : 11:39:42
|
| 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 |
|
|
|
Michael Voronov
Starting Member
Russia
5 Posts |
Posted - 04/25/2008 : 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
Sweden
29138 Posts |
Posted - 04/25/2008 : 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
Russia
5 Posts |
Posted - 04/25/2008 : 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 & *.ldf
3. I haven't backup files. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 04/25/2008 : 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
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 04/25/2008 : 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
Russia
5 Posts |
Posted - 04/26/2008 : 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
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 04/26/2008 : 10:16:01
|
| Looks like those files are corrupted based on error in your first post. |
|
|
|
sodeep
Flowing Fount of Yak Knowledge
USA
7173 Posts |
Posted - 04/26/2008 : 11:26:07
|
| Don't you have any backup in place? |
|
|
|
Michael Voronov
Starting Member
Russia
5 Posts |
Posted - 04/28/2008 : 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
USA
676 Posts |
Posted - 04/28/2008 : 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 |
Edited by - tosscrosby on 04/28/2008 14:18:24 |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 04/28/2008 : 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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/ |
|
|
| |
Topic |
|
Restoration of defective database
