April 29, 2004 at 6:49 am
Thanks. No we do not have the files. I suspected there wasn't much we could do. At the moment we are exploring recovery of files from the harddisk in order to attempt recovery. We are at least fortunate that there wasn't a whole lot of activity on the server when the problem was realized and we shut it down soon afterwards. Thanks again for your time in responding.
April 29, 2004 at 7:00 am
Do youo still have the physical files? or those were deleted also? If those exist, just do an attach DB. If the physical files disapeared, I don't see any way you can get that DB back.
A sysadmin could have an anser for files deleted and how to restore them afterwards, though. Sorry about that and finding the culprit could be quite a task! Good luck
April 29, 2004 at 8:54 am
Bruce,
It looks like you editted your post instead of Replying to the post. (The first post in the thread is a response to the second post in the thread).
If this is what happened, please don't edit your post unless you are correcting information. Just click on the Reply button. Now no one knows what your original question was.
-SQLBill
April 29, 2004 at 9:03 am
Oops! You can tell I'm a Newbie by editing my original post and wiping it out. At any rate, I may not have the text exactly but this is the gist of my original posting.
One of our databases has been deleted and we forgot to set it up for backups. What a bonehead maneuver. Is there any SQL Guru out there that has a magic pill we could take in order to recover it? Any information is appreciated.
Thanks,
Bruce
April 29, 2004 at 12:04 pm
You aren't going to be able to recover it via SQL. Even if you could backup the transaction log, you need a full backup to begin the restore.
You MIGHT be able to find a file recovery program and recover the disk(s). When a file is deleted, it's not really deleted. It's usually just marked as deleted. This is why federal organizations and companies that have sensitive data follow specific procedures when getting rid of computers (drill through the hard drive, crush it, or just run a program that writes 0's and 1's randomly over the disk - this last part is usually done multiple times before the drive can be considered 'cleaned')
-SQLBill
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply