Wednesday , October 17 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

 

Conclusion:

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

comments

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

Find all rows count and columns count in single database in sql server

In General for any database it contains lot of tables, if we want to find …