How to Backup all Database in SQL server using query

Why Database backup is important?

An error can arise when trying to write or read a file that is required to operate the database. This is called disk failure because there is a physical problem reading or writing physical files on disk. A common example is a disk head crash, which causes the loss of all files on a disk drive. So database backup is important.

Step 1:

First open the sql management studio.

Step 2:

Login the sql management studio using credentials.

                                       

Step 3:

Select the database tab in left side panel.

                                       

Step 4:

Click new query button in the left corner of the page.

                                       

Step 5:

Enter the all database query in the query page.

                                       

Step 6: 

Change the database storing location in the query.

                                       

Step 7:

Click execute for run the query

Step 8:

Finally query executed successfully

(All database backup Query)

DECLARE @name VARCHAR(50) -- database name
DECLARE @path VARCHAR(256) -- path for backup files
DECLARE @fileName VARCHAR(256) -- filename for backup
DECLARE @fileDate VARCHAR(20) -- used for file name

-- please change the set @path = 'change to your backup location'. for example,
-- SET @path = 'C:\backup\'
-- or SET @path = 'O:\sqlbackup\' if you using remote drives
-- note that remotedrive setup is extra step you have to perform in sql server in order to backup your dbs to remote drive
-- you have to chnage you sql server accont to a network account and add that user to have full access to the network drive you are backing up to

SET @path = 'D:\backup\'  --set your backup path

SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)

DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
WHERE name NOT IN ('master','model','msdb','tempdb')

OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @name

WHILE @@FETCH_STATUS = 0
BEGIN
       SET @fileName = @path + @name + '_' + @fileDate + '.BAK'
       BACKUP DATABASE @name TO DISK = @fileName

       FETCH NEXT FROM db_cursor INTO @name
END

CLOSE db_cursor
DEALLOCATE db_cursor

How to login in webmail

Steps for logging into webmail

The steps below will show you how to login to webmail. In this example, we are assuming the email address you want to check is user@example.com

STEP 1:

Visit example.com/webmail

webmail.xyz.com

                                       

STEP 2:

Enter your username and password, and then click OK.

User Name: username@xyz.com

Password: (password)

                                      

STEP 3:

You should now be logged in! Click on one of the three webmail clients and get started using your email!

Do I choose SquirrelMail, Horder, or Roundcube?

Now you have to click Mail dropdown list

                                          

 STEP 4:

Finally you get like this following screen

                                      

How To Share Network Folder and Security Permission

Step 1:

First you have create a folder in network location and Share that folder

Step  2:

Click the permission Button and give the permission authorized users and click checkbox for control of permission of users.

Step 3:

Right click the folder and select security tab in folder properties and select the advanced button

Step 4:

Select the Change permission button for user inheritance permission in object parents

Step 5:

Uncheck the inheritance permission for object parent's folder permission 

Step 6:

Now click edit option in permission of specified folder and added the authorized person select the which access you want to add the users

Step 7:

If unauthorized person access your folder they will get like this network error