SQL 2008 Database Backup

SQL 2008

Under "Maintenance Plans" I have two backup tasks.

November last year I took a database off line.

I have noticed that the tasks are still trying to backup the old database.  
I have also noticed that it is not backing up my new database.

SQL Backup
Where do I alter the databases which are being backed up?
LVL 3
Bransby-ITAsked:
Who is Participating?
 
AnujConnect With a Mentor SQL Server DBACommented:
Double click the "Backup Database" object and edit.
0
 
Steve WalesSenior Database AdministratorCommented:
Right click on the Back Up Datebase (Full) box and select Edit.

There's a dropdown at the top of the edit box that's going to say "Selected Databases".

You can modify your selections in there.
0
 
x-menConnect With a Mentor IT super heroCommented:
right click the back up task, edit, add the new DB, and remove the old.

..or change to "all Databases"
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Bransby-ITAuthor Commented:
When I right click or double click it just ges blank with the bold type "Full Backup"
0
 
Bransby-ITAuthor Commented:
Going forward, if I set the backup to Full All Database, will any new ones go in automaticaly?
0
 
Steve WalesConnect With a Mentor Senior Database AdministratorCommented:
Yes, if you select "All Databases" then I believe all should be backed up automatically.
0
 
Bransby-ITAuthor Commented:
Hi sorry have an issue with the VM lun all sorted now.
OK at the moment its backing up "Specific Databases" when I go to the dropdown it gives me the following error?

SQL
0
 
Steve WalesConnect With a Mentor Senior Database AdministratorCommented:
Could be security related, not 100% certain.

How are you connecting to the database instance ?
On the server locally?
Remote access?

The only reference I've found so far is this one but it is about remote access to the server for management of a remote server.
0
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
Not sure why your connection is empty, when I look at ours it is filled in with "Local server connection".  Also, one of the options is "All user databases" which excludes the system databases.  And it does start including any new databases that get added to the server.  We have been using this backup planfor sevaral years now.backup plan
0
 
Ramesh Babu VavillaConnect With a Mentor Commented:
no maintenace plan will not take the backup of the databases which are offline.standby modes
0
 
Bransby-ITAuthor Commented:
Hi Team, thanks for the great help.

I have just deleted and reset new jobs up.
There were a couple of things I didnt like so I recreated them.

Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.