Backup SQL server db issue: delete old backup files
- by David.Chu.ca
I tried to use sqlmaint.exe tool to back up a database on a remote PC. Here is an example of backup:
sqlmaint.exe -S remoteSQLServer\SQLInstance -U username -P pwdxxx -D myDB
-BkUpMedia DISK -BkUpDB C:\MSSQL_Backups -DelBkUps 3days ...
Here I specified to delete backups older than 3 days. However, the job seems not deleting old bak files on the remote PC(where the SQL server sits). The remote PC has Windows 2008 Server. I also set the C:\MSQL_Backups as shared network drive for EnyOne as owner. My understanding is that the job will delete any bak files older than 3 days. Not sure what I missed?
By the way, the job runs at a box with SQL server 2005 installed.