|
mathewgeorge
Starting Member
1 Posts |
 Posted - 04/10/2005 : 08:27:04
|
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,
mats |
|
|
Bustaz Kool
Flowing Fount of Yak Knowledge
USA
1430 Posts |
Posted - 04/10/2005 : 12:49:40
|
What exactly do you mean by "deleted"?
Did you execute a DROP DATABASE command from Query Analyzer? Did you delete the database using Enterprise Manager? Did you delete the database files?
If you have a database backup, you can RESTORE the database to a new name. Books online has details.
You will probably want to run RESTORE FILELISTONLY first to get the logical names from the backup device/file. Again, see BOL for details.
HTH
=================================================================
In order to improve the mind, we ought less to learn than to contemplate.
-Rene Descartes, philosopher and mathematician (1596-1650)
|
 |
|
deleted SQL Server database from the network.
Forum Locked
