Solved

SQL2008 Maintenance Plans Question

Posted on 2013-01-09
2
225 Views
Last Modified: 2013-01-09
SQL 2008

I have created two Maintenance Plans on my new SQL Server.
1 Full Backup 13:00
1 Full Backup 18:00

This is how the old SQL Server has it backing up.

I have looked on the old SQL Server and there is a Job "SysPolicy_Purge_History"
it runs everyday at 02:00

MaintMaintmaintMaint
What is this doing?
0
Comment
Question by:Bransby-IT
2 Comments
 
LVL 3

Accepted Solution

by:
Crower earned 500 total points
Comment Utility
0
 
LVL 3

Author Comment

by:Bransby-IT
Comment Utility
Just what I required.
Thanks
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This video discusses moving either the default database or any database to a new volume.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

772 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

11 Experts available now in Live!

Get 1:1 Help Now