Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL backup/mainenance plan

Posted on 2011-05-12
3
Medium Priority
?
388 Views
Last Modified: 2012-05-11
I have recently installed and setup SQL Server 2008 r2 on windows Server 2008 R2 and moved a single database to the new server. I have set up a mainenance plan to backup the database each night. However, even though I have setup the maintenance plan and subplan, with the backup task, and scheduled it to run each night, nothing ever happens. I don't even get logs in the maintenance plan history.
0
Comment
Question by:spiderwilk007
  • 2
3 Comments
 
LVL 81

Accepted Solution

by:
arnold earned 2000 total points
ID: 35748529
make sure the sql agent service is running.
When you use Sql server management studio, is the sql agent reflected as running?
If sql agent is stopped, the jobs do not run.
0
 
LVL 8

Author Comment

by:spiderwilk007
ID: 35748586
Man, I knew it was something small. I am testing it to run while I go to lunch if it runs you get the points!
0
 
LVL 8

Author Comment

by:spiderwilk007
ID: 35749412
That did the trick!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
How to deal with a specific error when using the Enable-RemoteMailbox cmdlet to create a mailbox in the cloud-based service, for an existing user in an on-premises Active Directory.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

572 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