I am implementing a backup procedure for our SQL databases running Microsoft SQL Server 2000 ? 8.00.2039 on Windows Server 2003 Enterprise Edition. I have done so through a DB maintenance job.
I am saving the backup as a file to a custom location on the same server. I also have the job verify the integrity of the backup and the backup jobs to write history reports.
The backups get verified with no errors and logs are written when the jobs complete. Something seems to be wrong though because according to the logs, the jobs are only taking a couple of seconds and the backup file size is only a few MB's when the database is several GB's. This is the case for all of about a dozen databases I am trying to back up. The file sizes vary from under a hundred MB's to the largest that is 10GB. The databases are all set to the Full recovery model and I am performing complete backups. Transactional logging is also setup and I am attempting to back them up completely as well.
I have even tried creating a permanent backup device pointing to a file location and manually selecting to backup the DB's to that device but get the same result. Everything else checks out and these databases are used constantly with no issues. The backups are also scheduled late night so as not to interfere with the user environment.
I am under the impression that the backups should reflect a similar size to the actual DB. Am I just being ignorant here or does it sound like something is wrong?
August 28, 2006 10:16 AM
February 3, 2009 3:56 PM