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 |
|
Syed Ibramusha
Starting Member
6 Posts |
 Posted - 2009-03-28 : 07:56:05
|
| Helloi have one dowt,i has accitently delete table in database but i want now so how to recover the table form log file |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-03-28 : 13:26:34
|
| Look for Red Gate log rescue product. I believe you can use 14 days trial |
 |
|
|
Syed Ibramusha
Starting Member
6 Posts |
Posted - 2009-03-30 : 07:46:26
|
| hi,I Looked for Red Gate log rescue product. I can not success this workPlz send link for specific tool(Table recovery tool)Thanks Syed Ibramusha |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-30 : 09:00:56
|
| Do you run regular backups of the database? |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-03-30 : 09:18:41
|
| Do you have backups? What is the recovery mode of the database? If you don't have backups or the database is in "simple" mode, you appear to be out of luck....The first thing to do as a DBA is to ensure you have appropriate backups to meet your needs. "i has accitently delete table" is not an excuse - in reality it may be grounds for termination.Look up the log reader tool at:http://www.red-gate.com/products/SQL_Log_Rescue/index.htmGood luck!Terry-- Procrastinate now! |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-03-30 : 09:30:02
|
| http://www.red-gate.com/products/SQL_Log_Rescue/walkthrough1/step1.htmfrom here u get the free copy of that trial version.....and u also get to know how to do this??Thanks... |
|
|
|
Syed Ibramusha
Starting Member
6 Posts |
Posted - 2009-03-31 : 01:20:36
|
| I download Red gate SQL Log Rescue tool but it is some error occur Error is:No transaction or recorded in the database log.Re-run the project setting wizard you have choosen correct database and server compination(Note:After deleted i make backup database file, in this file i used for back up process. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-31 : 04:24:22
|
| A backup made after a deletion can not be used to restore a file already deleted. Do you have a backup made before the deletion? Do you run regular backups? If not set them up as soon as possible. |
|
|
|
|
|
|
Sql Server