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?

  • 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
  • 4
    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

| 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy