• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

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?
6 Solutions
AnujSQL Server DBACommented:
Double click the "Backup Database" object and edit.
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.
x-menIT super heroCommented:
right click the back up task, edit, add the new DB, and remove the old.

..or change to "all Databases"
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Bransby-ITAuthor Commented:
When I right click or double click it just ges blank with the bold type "Full Backup"
Bransby-ITAuthor Commented:
Going forward, if I set the backup to Full All Database, will any new ones go in automaticaly?
Steve WalesSenior Database AdministratorCommented:
Yes, if you select "All Databases" then I believe all should be backed up automatically.
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?

Steve WalesSenior 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.
Chris LuttrellSenior 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
Ramesh Babu VavillaCommented:
no maintenace plan will not take the backup of the databases which are offline.standby modes
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.
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now