Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to schedule back up in SQL Server 2005 with management option. I am unable to find database name while scheduling a backup with full option. Database name is not over there in selected area. What can be the reason?

share|improve this question

migrated from Mar 2 '13 at 15:18

This question came from our site for professional and enthusiast programmers.

Are you sure you're on the right instance? I'm guessing you're talking about a maintenance plan? – Thomas Stringer Mar 2 '13 at 15:23
Do you have enough privileges to backup the database? – Carol Baker West Mar 2 '13 at 17:11
Try out SQLBackupAndFTP tool. You can select SQL Server instance and databases for backup. Basic features are available in free version (and scheduler too). – Alexey Mar 8 '13 at 14:30

This link may help you to back up the data

share|improve this answer
I know how to take back up manutally but At time of scheduling the back up automatically, The database name is not there in list of all databases. what can be the reason? – user2126132 Mar 2 '13 at 8:43
search All files instead of .bak in the list. – Rithesh Mar 2 '13 at 9:03
Database name is not there, I am not looking for .bak file. I am schduling back up process thru which back up of database will be automatically done. – user2126132 Mar 2 '13 at 9:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.