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 |
mathewgeorge
Starting Member
1 Post |
Posted - 2005-04-10 : 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 databasethrough hex editor,...etc , ) A reply will be highly appreciated Thanks & Best Regards, mats |
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-04-10 : 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) |
|
|
|
|
|