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 |
|
bushka
Starting Member
4 Posts |
 Posted - 2005-06-09 : 06:40:31
|
| I have Sharepoint services pointing to a MS SQL database, after trying to delete a empty document folder I ended up deleting a child site inside of Sharepoint.We have an offsite backup that copies the entire harddrive but it has not copied off the MDF and LDF files as they were in use, I should now have relied on this method I know realise. I am hoping that even though the child site was deleted that the data is still in the MDF file. What is so important is the shared documents in the site, this is all I need to get to prevent my head from rolling.Is there any way to extract doc and xls files from a MDF file, I could mount it on MS SQL but do not know of any tools to extract the files I need, is there possibly a way to restore the site from the files? I guess this is like asking if there us a way to turn back time. I somehow need to check the files to see if the docs are still there or if they were purged when the site was deleted.This is going to be very costly for me if there are no steps to recovery. Any help wpuld be appreciated to keep an admin in his job. |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-06-09 : 06:59:28
|
| The only thing that I can suggest if you still have the mdf and ldf files, would be to take a copy of all the current databases on the sql server, reinstall the child site, then restore the relevant mdf and ldf that relate to that site. Then if the data is still in the mdf it will reappear, and either way you will still have the mdf backed up to fall back on if that doesn't work.-------Moo. :) |
 |
|
|
bushka
Starting Member
4 Posts |
Posted - 2005-06-09 : 11:04:41
|
| OK, that does not work as the child site disappears when the MDF file is restored, it seems that the child site exists in the database too...Now is there any way to retrieve doc and xls files without the web front end for the database?I've been lucky in the fact that most of the needed files have been recovered from their copies in the Temporary Internet Files. |
|
|
|
|
|
|
HELP! Restore Documents