I run a script to backup my databases. The critical lines of code are:
OSQL -U sa -P password -S ServerName -Q "BACKUP DATABASE StoreOps TO DISK 'C:\RMS Backup\DailyBackup1.bck' WITH FORMAT, STATS
And a second line just like the first for database HQ and filename
The files generated are 107MB (Store Ops) and 196MB (HQ).
Recently I executed a 'no going back' query so I manually backed up my
database. I don't normally check the file size when I do this sort ofthing,
but last night my backup media (DVD-RW) ran out of space...
The HQ Admin-generated backup file is nearly 2GB!
Is my batch file working? Are my backups worth the disk space they consume?
I haven't had to restore from one in a long time, and I hope I don't have
to--but I still want a working backup.
- posted 13 years ago