How can we take all the SQL SERVER Database Backup at once

First we need to create a folder in any drive to store the backup of database which we are going to take.

Here I have created a folder named “dbBackup” in my drive “C:\”

Copy the below code & paste it in your SQL Server Query Executer page:

DECLARE @DBName varchar(255)

Read the rest of this entry »