I'd like to take a current multi file sql backup and have the process run and create the 3 files but not in an appended fashion.
but with each days run being separated, or shown. the code I'm using is below but it only appends the backup into each files
not separated by date.
BACKUP DATABASE [IFS_FSM] TO DISK = N'C:\SQL_backup_tst\IFS_FSM_FILE1.BAK',
DISK = N'C:\SQL_backup_tst\IFS_FSM_FILE2.BAK',
DISK = N'C:\SQL_backup_tst\IFS_FSM_FILE3.BAK'
WITH NOFORMAT, NOINIT, NAME = N'IFS_FSM-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
T-SQL script to backup all user databases with time stamped backup file.
Open in new window