Posts
Sort by recent activity
ERASEFILES = 1 ???
I want only one copy of backups on disk but with ERASEFILES = 1, the previous night's backups are NOT deleted. I could use ERASEFILES = 23h, but I have a lot of Agent jobs to edit...
In Enterprise ...
Encrypted passwords for restore
I have an Agent job that restores a backup of a production database to a development server every night. I would like to use an encrypted backup as the source, but I understand that I cannot use t...
Using variables with Restore command
I want to automate the restore of a database from the latest backup file in a directory with multiple backup files. I can determine the name of this file from msdb but I need to pass the name of t...