Deleted Database

Accidently deleted a db and my backup is two weeks old...any way to recover
the db. It was a quirky thing, I was in query analyzer and I must have right
clicked and hit delete... I have a quirky laptop keyboard...anyway...is there
anyway to restore the deleted .mdf file? I am a relative newbie to this so
any help is appreciated.
Thanks...
Larry
Not through SQL Server or any of its tools. Post to a Windows forum to see if there exist any
undelete options. If you do manage, you can then try sp_attach_db of the database files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"LarryF" <lawrencef14@.hotmail.com> wrote in message
news:5D55BD15-A94F-49C6-8032-4BCF77B129C4@.microsoft.com...
> Accidently deleted a db and my backup is two weeks old...any way to recover
> the db. It was a quirky thing, I was in query analyzer and I must have right
> clicked and hit delete... I have a quirky laptop keyboard...anyway...is there
> anyway to restore the deleted .mdf file? I am a relative newbie to this so
> any help is appreciated.
> Thanks...
> --
> Larry
|||thanks, i thought that was the answer...
Larry
"Tibor Karaszi" wrote:

> Not through SQL Server or any of its tools. Post to a Windows forum to see if there exist any
> undelete options. If you do manage, you can then try sp_attach_db of the database files.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "LarryF" <lawrencef14@.hotmail.com> wrote in message
> news:5D55BD15-A94F-49C6-8032-4BCF77B129C4@.microsoft.com...
>
>
|||When a file is deleted there is a record still kept on the hard drive.
Depending on the size of the database file it might have been actually
deleted from the hard drive but a small database < 1GB has a good chance of
still being there.
Google "undelete" and you'll find a number of tools out there that can
recover the file.
Good luck.
"LarryF" wrote:
[vbcol=seagreen]
> thanks, i thought that was the answer...
> --
> Larry
>
> "Tibor Karaszi" wrote:

Deleted Database

Accidently deleted a db and my backup is two weeks old...any way to recover
the db. It was a quirky thing, I was in query analyzer and I must have righ
t
clicked and hit delete... I have a quirky laptop keyboard...anyway...is ther
e
anyway to restore the deleted .mdf file? I am a relative newbie to this so
any help is appreciated.
Thanks...
--
LarryNot through SQL Server or any of its tools. Post to a Windows forum to see i
f there exist any
undelete options. If you do manage, you can then try sp_attach_db of the dat
abase files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"LarryF" <lawrencef14@.hotmail.com> wrote in message
news:5D55BD15-A94F-49C6-8032-4BCF77B129C4@.microsoft.com...
> Accidently deleted a db and my backup is two weeks old...any way to recove
r
> the db. It was a quirky thing, I was in query analyzer and I must have ri
ght
> clicked and hit delete... I have a quirky laptop keyboard...anyway...is th
ere
> anyway to restore the deleted .mdf file? I am a relative newbie to this s
o
> any help is appreciated.
> Thanks...
> --
> Larry|||thanks, i thought that was the answer...
--
Larry
"Tibor Karaszi" wrote:

> Not through SQL Server or any of its tools. Post to a Windows forum to see
if there exist any
> undelete options. If you do manage, you can then try sp_attach_db of the d
atabase files.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "LarryF" <lawrencef14@.hotmail.com> wrote in message
> news:5D55BD15-A94F-49C6-8032-4BCF77B129C4@.microsoft.com...
>
>|||When a file is deleted there is a record still kept on the hard drive.
Depending on the size of the database file it might have been actually
deleted from the hard drive but a small database < 1GB has a good chance of
still being there.
Google "undelete" and you'll find a number of tools out there that can
recover the file.
Good luck.
"LarryF" wrote:
[vbcol=seagreen]
> thanks, i thought that was the answer...
> --
> Larry
>
> "Tibor Karaszi" wrote:
>