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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-10 : 07:51:37
|
| shaban writes "Hello sqlteam,I'm having very serious problem with one database. During restoring the database from backup file instead of choosing the right database from drop-down i have restored it over another database !!Then I stopped it, but then when I checked this database it has been deleted phisically from the disk ?! The status of this db is marked as Loading ... can somebody explain what happenned with this database - is it completely deleted? Because I tried to recover the data from disk with the 3rd party software GetDataBack - I found the mdf and ldf of this database but can not attach them, I think both are corrupted?? Does SQL server simply deleted them or corrupted as well? Can you help me on how to get this database back because I don't have backup of this database and is extremely important.Thanks a lot,shaban." |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-10 : 08:09:35
|
| As I understand it:When you restore a database SQL reserves the correct amount of space and then starts restoring.So ... the disk space your database was already using (MDF and LDF files) will have been used as the basis for the restore, and I reckon those files are now hosed.Kristen |
 |
|
|
Priya Rajagopalan
Starting Member
10 Posts |
Posted - 2005-10-10 : 08:17:48
|
| Hitry using this commad to restore your database back.Use MasterGosp_configure 'allow updates', 1reconfigure with overrideGoupdate sysdatabases set status = 16 where name =’databaename’'RegardsPriya |
|
|
|
|
|
|
resoring database over another one