SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 deleted SQL Server database from the network.
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

mathewgeorge
Starting Member

1 Posts

Posted - 04/10/2005 :  08:27:04  Show Profile

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
1782 Posts

Posted - 04/10/2005 :  12:49:40  Show Profile
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)
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000