?
Solved

SQL 2008 Database Backup

Posted on 2013-01-08
11
Medium Priority
?
193 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 15

Accepted Solution

by:
Anuj earned 336 total points
ID: 38755767
Double click the "Backup Database" object and edit.
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 38755769
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 336 total points
ID: 38755772
right click the back up task, edit, add the new DB, and remove the old.

..or change to "all Databases"
0
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 
LVL 3

Author Comment

by:Bransby-IT
ID: 38755856
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
ID: 38755867
Going forward, if I set the backup to Full All Database, will any new ones go in automaticaly?
0
 
LVL 22

Assisted Solution

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

Author Comment

by:Bransby-IT
ID: 38756054
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 664 total points
ID: 38756136
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 27

Assisted Solution

by:Chris Luttrell
Chris Luttrell earned 332 total points
ID: 38756247
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:Ramesh Babu Vavilla
Ramesh Babu Vavilla earned 332 total points
ID: 38758065
no maintenace plan will not take the backup of the databases which are offline.standby modes
0
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38759714
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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

765 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