Tool for Taking Backup of Multiple Databases

Although lots of free & Paid  tools  are available in the market for Database backup though them you can take you database backups in different ways. You can schedule backups and many things....

SQL Server provides many inbuilt capabilities which can be used to perform lot of tasks. But opening SQL Server tools and performing such tasks take lot of time and also computer RAM.

I have used the inbuilt features of the  SQL Server and .NET Framework 4.6.2 to create a small tool (32KB in Size) through which you can take back up of your databases in a single click.

This tool lists all your databases for the  Database Server and you can select the database(s) to take backup.

You can also select the file naming through the dropdown which shows the date and time of your backup.

Also if you are selecting multiple databases then this tool will create a zip file of the backups of the database which you can easily transport from one place to another.

Pre-Requesties:

The machine running this program should have .net framework 4.6.2 installed.

How to :

1. Download the exe (link is given at the bottom of this post).
2. Click on  the exe to execute the program (No installation is required.)
3. Fill in the server name and credentials (See below picture)
4. 
5.  After filling above details, click on the get databases button which will lists all the databases available in the selected Database Server.
6. Now select the databases for the Backups.
7. Click on  the "Backup Selected Database" button to backup the databases.
8. After the successful backup, it will popup the message with the path of the backup file.

See below snapshots for full demo

Also which you will open this application again, all the database servers you have used will be populated in the Database Server Name dropdown, so you dont have to input them again, Just click and save.

Microsoft Visual Studio Community 2017 is used to create this application and tested on windows 10 Pro with SQL Server Express (2008) Version.

Disclaimer: Although this application is created in such a manner that it will not harm anyone's machine but Author / Developer is not responsible for any damage on your computer after using this application. Please use it on your own risk.

Download the Program