?
Solved

Will DB Backup's  cleanup job will cause Paging ?

Posted on 2014-10-24
6
Medium Priority
?
65 Views
Last Modified: 2016-06-15
Hi All,

Will Database backup  cleanup job (maintenance plan)  cause paging issue in Server ?

Server: Windows server 2008R2
DB:SQL Server 2008R2

Regards,
0
Comment
Question by:GK GK
[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
  • 2
  • 2
6 Comments
 
LVL 35

Expert Comment

by:ste5an
ID: 40401271
Maybe.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40401715
Only if you have an huge history of backups but in generally should not.
0
 

Author Comment

by:GK GK
ID: 40418957
Thanks for update,

Please let me know how to clean backup history.

Regards
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40419104
If you are using native maintenance plan then you should have a History Cleanup Task. Otherwise you can delete the backup history by running the following command:
EXEC msdb.dbo.sp_delete_backuphistory  @oldest_date

Open in new window

0
 

Accepted Solution

by:
GK GK earned 0 total points
ID: 40432544
Dear All,

We found the issue, There are two Server monitoring services are running in the server, One of monitoring service causing the paging issue.

Regards
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Determining the an SCCM package name from the Package ID
A small collection of useful tips and tricks for Windows 10 users that I decided to write as a result of recent questions that were asked and answered at Experts Exchange. Two short video tutorials included. Enjoy..
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

752 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