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?
Colin 't Hart
9,51015 gold badges37 silver badges44 bronze badges
asked Mar 2, 2013 at 7:31
user2126132user2126132
-
Are you sure you're on the right instance? I'm guessing you're talking about a maintenance plan?Thomas Stringer– Thomas Stringer2013年03月02日 15:23:00 +00:00Commented Mar 2, 2013 at 15:23
-
Do you have enough privileges to backup the database?Carol Baker West– Carol Baker West2013年03月02日 17:11:17 +00:00Commented Mar 2, 2013 at 17:11
-
4Try out SQLBackupAndFTP tool. You can select SQL Server instance and databases for backup. Basic features are available in free version (and scheduler too).Alexey– Alexey2013年03月08日 14:30:20 +00:00Commented Mar 8, 2013 at 14:30
1 Answer 1
This link may help you to back up the data
answered Mar 2, 2013 at 7:40
RitheshRithesh
-
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– user21261322013年03月02日 08:43:41 +00:00Commented Mar 2, 2013 at 8:43
-
search All files instead of .bak in the list.Rithesh– Rithesh2013年03月02日 09:03:37 +00:00Commented Mar 2, 2013 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– user21261322013年03月02日 09:08:23 +00:00Commented Mar 2, 2013 at 9:08
lang-sql