Solved

Will DB Backup's  cleanup job will cause Paging ?

Posted on 2014-10-24
6
29 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
  • 2
  • 2
6 Comments
 
LVL 33

Expert Comment

by:ste5an
ID: 40401271
Maybe.
0
 
LVL 46

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 46

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

895 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

16 Experts available now in Live!

Get 1:1 Help Now