Error messages when attempting restore database

I get numerous error messages when attempting to restore my SQL2005 database. The first error message says "The SELECT permission was denied on the column 'backup_set_id' of the object 'backupset', database 'msdb', schema 'dbo'. I get this same error for about 30 other columns which I am not familar with such as media_set_id, catalog_media_number, etc. I accidently deleted a table from my database and asked DiscountASP to create a backup file for me to restore. I have been able to do restores before when I created the backup but I get these error messages when I attempt to restore from a backup created by Discountasp. They wouldn't help me with the problem so that is why I hope I can get some answers from this forum or else I am screwed out of 2 months worth of work.
Dave

 

Just to clarify? How are you trying to restore the database?

Make sure you're using the restore tool through the Control Panel, which is found when you go to the SQL 2008/2005 page, and then select the SQL Tool Suite. On that page, you can restore your database.

Give it a try, and let us know if you still have problems.

 

Thanks for your replies. I tried to do the restore throught SQL Server Manager Studio rather than the Control Panel. I will have to remember that the next time I do a backup or restore. In the meantime, I downloaded by backup file to my local computer and did my restore there and then uploaded the new database table back to the server. So I achieved my goal in a round about way but at least I now have a backup on both the server and my local computer. Thanks again for your replies.
Dave