Replies: 1 comment
-
I think that you would have to write a small cmd or PowerShell script for that. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
When I run the solution, I only get the most recent log file in my output folder. I log to table as well. Is it possible to have the log files appended with a date and time like the backup files? Here's the cmd I am running.
sqlcmd -E -S SQLEXPRESS -d maintenanceplan -Q "EXECUTE dbo.DatabaseBackup @databases = 'USER_DATABASES', @Directory = 'D:\Z\Database\backups', @BackupType = 'FULL', @verify = 'Y', @Cleanuptime = 168, @LogToTable = 'Y'" -b -o D:\Z\Database\backups\Maintenanceplan\Log\DatabaseBackup.txt
Beta Was this translation helpful? Give feedback.
All reactions