hi all An mdf file was detached and then deleted and now its been found that the mdf is not on any backups. I still have the ldf file. is there anyway or restoring the mdf using the ldf file or is the db gone for good? any help would be greatly appreciated thanks S_Surfer
With mdf and without ldf, there is a way but not with only ldf file. Anyway wait for others members opinions.
ok i have found the MDF but its about 2 years old. the LDF is up to date. can I update the MDF using the LDF?
Don't think so. You can attach mdf without ldf and start from there. BTW: What do you have in "any backups"?. I mean what was the backup strategy?
it was a full backup using arcserve backup but it looks like that the backup application was not configured to backup the SQL databases on the serevr, it was only set to backup the files in the directory that hosts the databases but as the SQL server was online, the Dbs were not backed up.
Well, try to attach mdf and ldf. If you can't do it, attach mdf only, create a new ldf and start from there.
are you sure there are no native backups that were scheduled on the SQL side? could if be you are only aware of one type of backups while there were sql server backups going on and storing elsewhere?
