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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 77
  • Last Modified:

Will DB Backup's cleanup job will cause Paging ?

Hi All,

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

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

Regards,
0
GK GK
Asked:
GK GK
  • 2
  • 2
1 Solution
 
ste5anSenior DeveloperCommented:
Maybe.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Only if you have an huge history of backups but in generally should not.
0
 
GK GKAuthor Commented:
Thanks for update,

Please let me know how to clean backup history.

Regards
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
GK GKAuthor Commented:
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 problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now