Tuesday , June 19 2018
Home / DataBase / SQL SERVER / Backup all databases in SQL Instance with one script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the data after a failure. A backup of SQL Server data is created at the level of a database or one or more of its files. sql server provides a script to take backup

Here is the script that will allow you to backup each database within your instance of SQL Server.

Note : You will need to change the @path to the appropriate backup directory, and above script will be create DBname_YYYYDDMM.BAK as filename in the selected directory



We hope you find the tip as helpful,  I hope you liked the article. Please share your valuable suggestions and feedback in the comments.

Print Friendly, PDF & Email

Give us your valuable feedback


About Murali

Hello everyone I am Software Developer having 3+ years of Experience in Microsoft Technologies and Others. My skills :- Asp.net, C#,Ado.net, SQL SERVER, web services, windows Service,Windows applications,HTML,CSS, JavaScript,JQuery,AnjularJs

Check Also


dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart

dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, …

%d bloggers like this: