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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-21 : 10:28:12
|
| Amit writes "I have had a peculiar problem in the last 3 days, the tables from my database are getting deleted automatically. I first suspected some hacking and changed the password but even after that it has happened 3 times. Is there a possibility that it may be happening due to lack of space for the DB. Also could it be because I am trying to import the data from the same db using copy all objects from one db to another while the database is being used by the website.Please help !ThanksAmit Agarwal" |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-08-21 : 11:27:44
|
| If you run out of space, SQL Server will tell you that, so it is not due to the fact you are running out of space. I can imagine the flood of calls MS support would get if SQL Server did delete tables when the hard drive was full. The second possibility you have mentioned would cause other errors, I would doubt that it would delete tables, maybe data, but I'm not too sure about tables. Don't know what else to tell you unfortunately.*************************Someone done told you wrong! |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-08-21 : 12:00:51
|
| SQL PROFILER should be of use to you to resolve this.....you can use it to track objects being dropped.....Experiment with same and then keep it running until the problem is resolved....do note that PROFILER will/can use a lot of diskspae if you let the history build up too much or log too many events...(as well as affect performance....but for a short exercise will pay off) |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-21 : 15:44:56
|
| Amit,When you say the tables are getting deleted do you mean that they no longer exist in the database, or just that they are being emptied out?How are you importing/copying the objects? Are you sure your SOURCE and DESTINATION databases are set properly? Have you looked through all the options such as Append Data? |
|
|
|
|
|
|
Tables are deleted automatically