FREE MS-SQL Backup Tool, For Commercial and Personal Use.
System requirements: runs on Windows Server 2025, 2022, 2019 and 2016, Windows 11, 10, 8.1, and 7.
Default installation path:
C:\Program Files (x86)\Netstair Communications\NetstairBackupSQL
Important: If you use the C:\Program Files (x86) as your default installation directory folder, then you must assign modify permissions to 'users (computer name\users) to the installed folder. (see attached) ==>
Capture.JPG
Default Database File name that stores the databases to backup:
backupdb.xml
<?xml version="1.0" encoding="utf-8" ?>
<archives>
<Backup>
<FileName>ABC</FileName>
<sql-server>SQLEXPRESS</sql-server>
<db-name>ABCDB</db-name>
<dbu></dbu>
<password></password>
<Target-path>C:\temp</Target-path>
</Backup>
<Backup>
<FileName>ABC</FileName>
<sql-server>SQLEXPRESS</sql-server>
<db-name>XYZCDB</db-name>
<dbu></dbu>
<password></password>
<Target-path>C:\temp</Target-path>
</Backup> Leave blank the following if you wish to use the local account
<dbu></dbu>
<password></password>
Otherwise populate the value
<dbu>sa</dbu>
<password>{sa password here}</password>
Final Result: C:\Temp\ABC__DBNAME_YYYYMMDDSSXXXX.bak
Default Application Config File name to modify as needed.
NetstairBackupSQL.exe.config
<appSettings>
<add key="master-file" value="C:\Program Files (x86)\Netstair Communications\NetstairBackupSQL\backupdb.xml"/>
<add key="dbuser" value=""/>
<add key="dbpwd" value=""/>
<add key="dep" value="No"/>
<add key="delete-archives" value="Yes"/>
</appSettings>Change the <add key="compression" value="WIN"/> to <add key="compression" value="7z"/> if you wish to use 7z to compress your backup.
Change the value
FROM <add key="dbuser" value=""/>
To <add key="dbuser" value="sa"/> if you wish to use the the sa as your universal database login.
Change the value
FROM <add key="dbpwd" value=""/>
To <add key="dbpwd" value="sa password here"/> if you wish to use the the sa as your universal database login.
Change the value
FROM <add key="delete-archives" value="Yes"/>
To <add key="delete-archives" value="No"/> if you wish not to delete previous database backup.
FREE for Personal and Commercial use.
OR
Enjoy the Tool.