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 |
|
ejazmusavi
Starting Member
1 Post |
 Posted - 2011-12-30 : 04:59:00
|
| I have suddenly deleted a sql server databse file from Sql server management studio. and recovered it using a data recovery software. but now unable to open this database. the error is "aaa.mdf is not a primary database file error 5171". i need urgent solution plz. help me to solve this issue. it is very urgent |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-12-30 : 05:19:00
|
| Restore from backup is your first, best, option here. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-12-30 : 05:20:04
|
The file is corrupt. If there isn't a backup then you have to buy a recovery tool I think.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-30 : 06:13:51
|
| Restore from backup, that file is damaged. I don't think I've ever seen a database file recovered with any file recovery tool being usable afterward.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
SQL Server 2005 Database Recovery