Link to home
Start Free TrialLog in
Avatar of Bransby-IT
Bransby-IT

asked on

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.

User generated image
Where do I alter the databases which are being backed up?
ASKER CERTIFIED SOLUTION
Avatar of Anuj
Anuj
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve Wales
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bransby-IT
Bransby-IT

ASKER

When I right click or double click it just ges blank with the bold type "Full Backup"
Going forward, if I set the backup to Full All Database, will any new ones go in automaticaly?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?

User generated image
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.