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 |
|
faraz
Starting Member
2 Posts |
 Posted - 2008-02-16 : 06:53:59
|
| Dear FriendsI need ur help.I have a database in sql server 2000 (running in windows 2003).I was connected to the database through vb6 application suddenly application generates an error that missing object name<Table Name>.then i opened the database and search that table but there is no table in the database (database is empty) i lost all my data.then i checked my mdf and ldf file size they were 120mb mdf and 300 mb ldf.I am superised that how can database drop all tables.Please help me.please tell me how can database drop all table silently.and if sql drops all table then how can i figure out that really database drop all table any clue to know.can i see that in any sql log file.how can i return back all my datai took a backup just 4 hour before. but in the mean time there were around 800 entries which were update in database. how can i get them back. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-16 : 07:10:57
|
| Did you have any failover built in such as : log shipping , clustering etc.?There are also some recovery tools , such as : Lumigent Technologies' Log Explorer , which let you explore the transaction log. The use of these tools is dependant on the Recovery model - if you had the db set at Simple , than the data will have been lost from the transaction log at the CHECKPOINTJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
faraz
Starting Member
2 Posts |
Posted - 2008-02-16 : 08:18:05
|
| YES there are also some recovery tools , but i want to know why it happening because it happens again today after 2 days.how can i track that sql drop all tables or anything eles happening.i am so warried abt my data because it will happen again with out alarming me.i just want to know can sql tells me that sql droped the table or sql did anything else.Please if know anything please help me. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-16 : 12:02:32
|
| You need to create a DDL trigger on your table so as log all DDL events and information of agents causing them onto a log table. Also you can configure the trigger to send you a mail whenever any DDl changes occur in table. use xp_sendmail extended SP for this.If you want to save data think about taking frequent transaction log backups also.Make sure you server is configured to have full recovery model. |
|
|
|
|
|
|
Sql Server Drop table