deleted SQL Server database from the network

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

deleted SQL Server database from the network

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-04-12 : 08:31:17

Mathew writes "Dear Sirs,

I have deleted SQL Server database from the network.
Then I created a database with same name.

Can I get back the old database ?
(will the newly created file replace the old file ? is there any other way to get back the database
through hex editor,...etc , )

A reply will be highly appreciated

Thanks & Best Regards,

Mathew"

mr_mist
Grunnio

1870 Posts

Posted - 2005-04-12 : 08:38:24

You can restore your database from the backup that you took just before deleting it.

-------
Moo. :)

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-04-12 : 08:50:30

my guess is that they didn't back it up... that's usually the thing...

Go with the flow & have fun! Else fight the flow

mr_mist
Grunnio

1870 Posts

Posted - 2005-04-12 : 08:52:32

Yeah. In that case I hear that data can be ressurrected from disks using tunneling electron microscopy.

-------
Moo. :)

jason
Posting Yak Master

164 Posts

Posted - 2005-04-12 : 11:37:16

Evil old Yaks.

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-04-12 : 21:37:34

That's kind of an interesting idea actually. I've never tried reading a hard drive with a hex editor to restore files I deleted without a backup, then wrote over with a blank file. I guess if you could get it to read the subspace distortion frequency, it might work if you caught it during the phase regeneration cycle.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-04-13 : 02:08:22

derrick that is impossible due to trans-flux bi-magnetic particle charges that happen
on the surface of the disk because of the magnetic friction between the surface and the read/write disk head.

Go with the flow & have fun! Else fight the flow

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-04-13 : 03:18:10

You can do this and it can be done SET based, no need for HEX editors


DECLARE @Date datetime, @Database varchar(100)
SET @Date = CONVERT(datetime,'19840101') --Date of deletion
SET @Database = 'MyDeletedDatabase.mdf'

SELECT *
FROM SpaceTimeContinuum STC INNER JOIN LocalSystemDisk LSD
	ON STC.StarDate = LSD.SystemDate
WHERE STC.StarDate = @Date AND LSD.FileSystem = @Database

Tip: Always use SELECT and test your statement 1st before using any other function

Andy

Beauty is in the eyes of the beerholder

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2005-04-13 : 15:04:54

Don't you need a UNION ALL of Time and Space? Or is a junction table sufficient?

And I love the fact that your system date is on LSD...

HTH

=================================================================
Every act of conscious learning requires the willingness to suffer an injury to one's self-esteem. That is why young children, before they are aware of their own self-importance, learn so easily; and why older persons, especially if vain or important, cannot learn at all. -Thomas Szasz, author, professor of psychiatry (1920- )

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-04-13 : 15:26:54

However this type of recovery may prompt a visit from a resident of Gallifrey. Due to its negative effects on the continuum without the use of the sash of Rasilon

Jim
Users <> Logic

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-04-13 : 23:45:46

The database should be easy to recovery by using a simple quantum wormhole (See BOL for use of OPENWORMHOLE with the QuantumWormhole data provider). Don't forget to include the SET WORMHOLE_COLLAPSE OFF and BEGIN TEMPORALLY DISTRIBUTED TRANSACTION statements.

However, the resulting introdution of data into a time where it was not meant to exist is not fully supported until SQL Server 2005, so it is possible that your timeline may collapse.

CODO ERGO SUM

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-04-14 : 06:46:34

quote:
Originally posted by Michael Valentine Jones

The database should be easy to recovery by using a simple quantum wormhole (See BOL for use of OPENWORMHOLE with the QuantumWormhole data provider). Don't forget to include the SET WORMHOLE_COLLAPSE OFF and BEGIN TEMPORALLY DISTRIBUTED TRANSACTION statements.

However, the resulting introdution of data into a time where it was not meant to exist is not fully supported until SQL Server 2005, so it is possible that your timeline may collapse.

CODO ERGO SUM

That is f*ckin class!!!!

Why didnt i think of that

Beauty is in the eyes of the beerholder

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-04-14 : 17:57:16

One of my fellow professionals (haha) was wondering about Yaks.

We need a yak anomaly.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-04-15 : 01:51:25

quote:

Can I get back the old database ?

No, you can't take it back unless you have a backup safely stored somewhere and has not been deleted

though it'll be interesting if you'll find a tool and post the link here, we'll appreciate it

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources