sql server msde: Our clients are using MSDE. Our VB application provides simple full backup
feature usng DMO. We have noticed that their recent backup size goes to 2GB.

to investigate, When backup taken from enterprise manager it is 60 MB. What
could be the rerasons?. The clients are doing hundered of inserts daily. but
the originam db size is not more than 100 MB.

When restored both backups it seems last 2 months of data is not there.

Need help? stuck

hi Abbas,
[quoted text, click to view]

are you sure the backups you take are not added to the backup media instead
of initializing a new one?
objBackup.Initialize = ?? {True/False}
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

You may need to change the "Action" property of Backup object to entire
database backup instead of incremental backup.

SQLDMO_BACKUP_TYPE enumarations for Action property are:
(from the Books Online)

SQLDMOBackup_Database 0 Back up the database
SQLDMOBackup_Files 2 Back up only specified files
SQLDMOBackup_Incremental 1 Back up rows changed after the most recent full
database or differential backup
SQLDMOBackup_Log 3 Back up only the database transaction log


[quoted text, click to view]