Solved

SQL 2008 Database Backup

Posted on 2013-01-08
11
179 Views
Last Modified: 2013-01-09
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?
0
Comment
Question by:Bransby-IT
11 Comments
 
LVL 15

Accepted Solution

by:
Anuj earned 84 total points
Comment Utility
Double click the "Backup Database" object and edit.
0
 
LVL 22

Expert Comment

by:Steve Wales
Comment Utility
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
 
LVL 18

Assisted Solution

by:x-men
x-men earned 84 total points
Comment Utility
right click the back up task, edit, add the new DB, and remove the old.

..or change to "all Databases"
0
 
LVL 3

Author Comment

by:Bransby-IT
Comment Utility
When I right click or double click it just ges blank with the bold type "Full Backup"
0
 
LVL 3

Author Comment

by:Bransby-IT
Comment Utility
Going forward, if I set the backup to Full All Database, will any new ones go in automaticaly?
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 22

Assisted Solution

by:Steve Wales
Steve Wales earned 166 total points
Comment Utility
Yes, if you select "All Databases" then I believe all should be backed up automatically.
0
 
LVL 3

Author Comment

by:Bransby-IT
Comment Utility
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
 
LVL 22

Assisted Solution

by:Steve Wales
Steve Wales earned 166 total points
Comment Utility
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
 
LVL 26

Assisted Solution

by:Chris Luttrell
Chris Luttrell earned 83 total points
Comment Utility
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
 
LVL 10

Assisted Solution

by:sqlservr
sqlservr earned 83 total points
Comment Utility
no maintenace plan will not take the backup of the databases which are offline.standby modes
0
 
LVL 3

Author Comment

by:Bransby-IT
Comment Utility
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

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now