timscronin
MIS
I am running log shipping to 2 different servers. Server A is my primary, Server B is a failover and the monitoring server, and Server C is my second failover at a remote site. I run the following script to keep the log history table from becoming bloated
declare @date datetime
set @date = dateadd(day,-30 ,convert(datetime,convert(char(10),getdate(),101)))
exec sp_delete_backuphistory @date
I run this on the primary server, should I also run it on the failover servers?
declare @date datetime
set @date = dateadd(day,-30 ,convert(datetime,convert(char(10),getdate(),101)))
exec sp_delete_backuphistory @date
I run this on the primary server, should I also run it on the failover servers?