| Author |
Topic |
|
ilimax
Posting Yak Master
164 Posts |
 Posted - 2007-11-28 : 15:04:50
|
| Accidantelly I dropped the whole table from SQL Server Enterprise Manager.Is there any way I can bring back my table. There was about 7000 records.Help please!!!Thanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-28 : 15:12:20
|
| Do you have backups?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-11-28 : 15:15:33
|
| Have you an form of backups that you can perform a point in time restore from or even a snapshot of the db that you can restore the table from that snapshot |
|
|
|
ilimax
Posting Yak Master
164 Posts |
Posted - 2007-11-28 : 15:18:36
|
| Our network administrator just told me he did not made backup last night. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-28 : 15:19:48
|
| Why aren't your backups scheduled? No one should have to manually backup a database each night.Why is the network administrator responsible for backups in the first place though?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
ilimax
Posting Yak Master
164 Posts |
Posted - 2007-11-28 : 15:24:52
|
| Actually SQL Agent was stopped for some reason. It is happened sometimes that we see agent is turnned off by itself ( or any other process stop the agent) Do you know what can stop the agent? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-28 : 15:27:18
|
| Check the Application Log in Event Viewer for the reason why it stopped.Don't have you monitoring in place to know when services stop either purposefully or unexpectedly? We use Microsoft MOM product to monitor such an event.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-11-28 : 15:36:01
|
| You could take an old backup and restore it to a different db or different server and get the records back that way. But you need to get your backup situation fixed asap though. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-29 : 02:38:26
|
| Or recover the table with third party tools. |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2007-11-29 : 17:05:21
|
| Can we recover just 2 table's for example from the db backup file using third party tools, if so what are those tools. Thanks. |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-11-29 : 17:18:05
|
| You could get lumigent log explorer and it can look at your log backup (or live log) and once you find the transaction that dropped the tables, it can generate the script to get it back (I think). Personally I think the best bet is to restore your backup from a day or two earlier to a different db or server and recover your tables that way. |
|
|
|
|
Dropped table