Hi!
I have a client installed on win 2012 R2 Srv.
I need to backup an MSSQ database before the backup so the dump file could include to the backups.
This is what my prefilebackup.bat have:
sqlcmd -S SQLSRV -i d:\scripts\all_database_backup.sql
Executing this file by hand works, dump all database to the d:\sql_backup folder (which is included to the backup directories)
The postfilebackup.bat have this:
del /F /Q d:\sql_backup*
Which would delete the temp sql dump files after the backup.
When i run the incremental or full backup from the server the prefilebackup.bat not run. It did not dump my databases. If i put any file or folder to the sqldump temp dir its deleted after the backup, so the postfilebackup.bat executed correctly after the backup, but the prefilebackup.bat not.
Any ideas why, i did miss something?
Thanks!
Peter