Take the 2-minute tour ×
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. It's 100% free, no registration required.

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?

Help me to resolve this problem.

share|improve this question
    
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
add comment

migrated from stackoverflow.com Mar 2 '13 at 15:18

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

1 Answer

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
add comment

Your Answer

 
discard

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