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)
 Full DataBase Backup Problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-13 : 11:49:54
Eli writes "I made a database full backup , I checked the number of rows in a table prior to the backup and found 8138 records.

I backed up the database using BACKUP DATA mydb to e:\sqldata\mybackup.bak

I restored the backup to a different database using the RESTORE DATABASE with MOVE command and after the restore completed I checked the row number in the same table and there were only 7462 records.

What can be the reason for this difference ?

Thanks.

Eli"
   

- Advertisement -