REM Script-System-Variables - do not change after this point! SET MailSubject=SQL Express Backup (INSTANCENAME/DESCRIPTION) REM max age the files can be in days before they get deleted SET SQLBackupPath=D:\Backup\SubFolderName-\\SERVER\SHARE\FOLDER-EitherLocalOrUNC REM local Path or UNC Path (must be accessible under the executing user!) I apologize for the inconvenience, this is a old script I never updated to have those settings in the header (more automated), I always just changed the OFF If you want to execute the SQLBackups as the Windows-User that is executing the script, you need to exchange the REM (remarks) for the following two lines further down in the scripts. This is all done in the SQLBACKUP.CMD file – the header section pretty much will explain all you need to know, from SQL Server to SQL-User and Password over Mail-Server to recipients. CMD send a email report – I used the SMTPSEND program from Michael Kocum ( ) for this since I already ad it flying around – you could replace the mail send option with another prepared SMTPSEND client, a VBS script or just remove it completely. CMD script and will perform the backup cleanup. VBS file that is controlled by the actual. CMD file that executes the actual backup and where you set the configuration/parameters and a. It creates the backups via SQLCMD commands and even does a clean up of obsolete files (files older than x days), almost like SQL Maintenance Plans do it. To work around this issue, I once wrote a script that automates this for each database found on a specific SQL server. But for the many times this is not possible, you will need to find another way to create those nice little. Now, you can have central SQL Servers with Agents have them backed up – and I recommend on doing so if possible. Even Windows internal databases, especially WSUS / Windows Update Services / Microsoft Update Services are in the end SQL Express like databases that do not have a SQL Agent. SQL Express is widely used but has huge downside, there is no SQL Agent available. Servers and equipment Toggle Child Menu.LDAP change reporting / synchronization Toggle Child Menu.IT Assets Database (EOL) Toggle Child Menu.IT Printer Management (EOL) Toggle Child Menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |