Hi,

I have a problem with OSQL restore command.

I am running MSDE 2000 on a Win2K Pro PC. Backup is done thru OSQL utility thru Win2K job scheduler.

I tested the backup and restore command right after installation. It was fine.

However, after 2 months when I ran the restore command, some of the data went missing. I notice that there is a different on the no. of pages and the file no. between the backup log and restore log.

Any idea what is happening?

Backup Log
Processed 1648 pages for database 'ACER', file 'ACER' on file 7.
Processed 1 pages for database 'ACER', file 'ACER_log' on file 7.
BACKUP DATABASE successfully processed 1649 pages in 8.852 seconds
(1.525 MB/sec).

Restore Log
Processed 1280 pages for database 'ACER', file 'ACER' on file 1.
Processed 1 pages for database 'ACER', file 'ACER_log' on file 1.
RESTORE DATABASE successfully processed 1281 pages in 7.768 seconds
(1.349 MB/sec).

Thanks.
Kok Siong