• I use both of the above suggestions. The standard backup filename always contains the date and the SQL command that performs the backup contains WITH INIT to ensure the backup stands alone. I know this may not be applicable to all environments, but I like to keep things simple with one backup per file.