Hello folks,

In our company we're used doing daily database backups. Recently we suffered a crash and we had to do a restore. Fortunately we had quite some information on the crashed system (sp_help_revdatabase) since we were forced to re-create the database in exact the same way as it was created before. We did this and the restore was succesfull, but dbcc newalloc reported error 2558 on four tables (total of 23 tables). By re-creating a clustered index on these tables the error disappeared.
I'm wondering whether you're not better of taking table backups (e.g. create a cursor that selects all the tables from sysobjects where type ='U' and dumps them to tape). When a crash happens, you re-create your database from scripts and restore your tables one-by-one. Is my feeling that a table backup is more robust right?