Yes, you do have a problem. My main database is about 4 GB and takes fifteen to twenty minutes to backup. Time is a function of Processor speed, available memory, and storage capabilities.
MSSQL has some known ‘gotcha’ settings. The most perplexing is the default selection in the backup properties to append instead of overwrite. Append as implemented is NOT an incrememtal backup it only adds new stuff. Incremental should remove items as they leave the database.
My procedure is to open “Enterprise Manager” – open local – open databases – right-click the database in question, and from the contect menu select all tasks – backup database. The ensuing dialog box shold be verified and selection made as follows – Looking at the correct databse. Selected overwrite NOT append. If this is the first time you need to add a item as the to be stored location. Be sure the correct item is selected. If you loaded the database from a backup, and then deleted the file, the item will still be there but the backup fails (sometime silently)as file/location not found. I always run the ‘verify data’ option. On new stups I run the backup manually before scheduling. Then I can verify a restore to the test server or if you only have one restore to a different name. Remember to select overwrite when you go back to set scheduling.