Declare @sql varchar(250),@retention tinyint

set @retention=2

set @sql='Exec master.dbo.xp_cmdshell ''DIR D:\sql_backup\*'+ substring(convert(varchar(15),getdate(),104),7,4) + substring(convert(varchar(15),getdate(),104),4,2)+substring(convert(varchar(15),getdate()-@retention,104),1,2) +'*.bak /s'''

print @sql

Exec (@sql)

Declare @sql varchar(250),@retention tinyint

set @retention=2

set @sql='Exec master.dbo.xp_cmdshell ''DIR D:\sql_backup\*'+ substring(convert(varchar(15),getdate(),104),7,4) + substring(convert(varchar(15),getdate(),104),4,2)+substring(convert(varchar(15),getdate()-@retention,104),1,2) +'*.bak /s'''

print @sql

Exec (@sql)

By memory consumption i mean every time i am getting alerts that SQL SERVER IS CONSUMING 100% OS MEMORY..Very frequently i am getting such alerts.

We are changing it bcz of some security reasons in our environment.

Through Enterprise Manager we have already done that number of time.

But i am curious to know if we...

Select Database right click-> Tasks -> Shrink database -> click OK

Thanks for the kind advise...:)