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 |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2002-01-10 : 02:59:48
|
| Hi, I deleted a table from my database, from Enterprise Manager.Is there any way to restore that table.As I dont have Backup for that DB.I feel like I lost that Table.The Table has important Datas.If there is any way pls let me know ...Thanks and Regards,Karunakaran |
|
|
nrafiq
Starting Member
9 Posts |
Posted - 2002-01-10 : 03:55:44
|
| Hi,I want to tell one suggestion to you.The Sql-Server BOL says like this.How to recover a database without restoring (Transact-SQL)To recover a database without restoring * The name of the database to be recovered.* The RECOVERY clause. ExampleThis example recovers the MyNwind database without restoring from a backup.-- Restore database using WITH RECOVERY.RESTORE DATABASE MyNwind WITH RECOVERYRafi |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-10 : 08:14:56
|
Restore with Recovery Option takes back to the Uncommited transactions.For any transaction to be uncommited it should be set in a batch egbegin trans ... Commit TransOtherwise, the SET IMPLICIT_TRANSACTIONS should be on ,the default is Off. When the Set Implicit_transactions is On ,just by disconnecting and reconnecting or a Rollback without a prior Commit trans should do the job. this all works fine with Query Analyser. but when you do any operation in Enterprise Manager it AutoCommits itself irrespective of the Set Implicit_transactions state too.So, i dont think there are any hopes of getting back your table Karuna.thts my opinion which can be wrong. Might be Our Guru's will comeup with a Master Stroke .This is what BOL has to offer.RECOVERYInstructs the restore operation to rollback any uncommitted transactions. After the recovery process, the database is ready for use. If subsequent RESTORE operations (RESTORE LOG, or RESTORE DATABASE from differential) are planned, NORECOVERY or STANDBY should be specified instead.If neither NORECOVERY, RECOVERY, or STANDBY is specified, RECOVERY is the default. The database version is updated for databases and transaction logs if RECOVERY is specified. For more information, see Creating and Applying Transaction Log Backups. HTH----------------------------Anything that Doesn't Kills you Makes you Stronger |
|
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-01-10 : 12:30:35
|
| In the future I would suggest looking at a product Like Log Explorer. It would allow you to recover a deleted table and even data from the transaction log. It doesn't actually rollback the data, it creates scripts that allow you to rebuild. I think Lumigent makes it. Hope this helps (atleast in the future)JamesH. |
|
|
|
|
|
|
|
|
Is it Possible to restore the Deleted Table