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 - 2006-08-08 : 07:40:15
|
| marc@blitzen.ns.ca writes "Hi Guys,I need help restoring my MS SQL.My back-ups failed so I don't have true back-up files to use. I do have a complete backup of my hard drive that works. How can I use this backup to add the databases back to my SQL, when I go in and try to attach a database I see a few of my older DBs but I don't see any of my newer ones to add.Is there one "master" file that would hold all my latest data?Or am I screwed?Thanks,Marc" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-08 : 13:12:53
|
| Yes it sounds like you are screwed. If your system backup was taken prior to the newer databases being created, then there is no way to recover these.Tara Kizer |
 |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-08-10 : 19:57:46
|
| Hi MarcIf you have a full backup of your harddrive, you should be able to find mdf and ldf. If you can't find in the mdf and ldf it might be storing to other than default location which it happens to me. Hope this help.Thanks |
|
|
|
|
|
|
MS SQL Restore Help Needed