Tag Archives: backup

SQL Script to find Expected Finish TIME for current running BACKUP / RESTORE

When SQL Server backup / Restore will be finished ? How long it will take to complete this backup or Restore ? What is expected time when SQL Server BACKUP / RESTORE will be finished? This question is asked by lot of time by DBA’s and we always answer them either based on past history [...]

Forfiles Utility

To delete old database backup files get acquainted with the ForFiles utility. The Forfiles utility (forfiles.exe) comes installed with Windows Server 2003 and later. It enables batch processing of files. In conjunction with a SQL Server Agent job, you can use this utility to delete old database backup files to remove dependencies on items such [...]