Tables Have Been Deleted
-
I noticed that a couple tables seem to have been deleted from the database. The program recreates the tables if they do not exist when someone logs on. They are not critical but I would like to know what could cause them to be deleted. I have a single DTS Package that exports out of one of them, but otherwise, nothing touches those tables except the program (which cannot delete tables).
There are other DBAs here, but they do not touch my server.
I have also noticed that one of my critical tables has a create date of last month. This is strange since it still contains all the data. The other tables have various create dates even though they were all created at the same time (sometime in 2001).
Any explanations would be greatly appreciated!
-
'create date last month...' can be when you alter the table e.g. using EM. It has the tendency to use a ddl sequence of rename - create - insert - drop old. So you'll end up with a new create date.
Is the recoverymodel "full" or "bulk logged" - you could use log-analyser tools to find drop statements.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply