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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Table truncated during a backup

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-13 : 19:24:26
Andy Anderson writes "I manually backed up a database by right-clicking on the database in enterprise manager and seleced all tasks and then backup. I backed it up to a file and selected all other defaults. The backup worked ok, however all of the tables were truncated. I did this to several databases and this only occurred on the last one. This is SQL Server 7. What could have caused this?"
   

- Advertisement -