Get your business online with free website builder (en)

How to Take BACKUP from SQL Database

Take BACKUP from SQL Database:

(1) Open SQL Management studio, as shown.

Microsoft SQL Server Management Studio

(2) Run as administrator, as shown.

run as administrator sql

(3) After that SQL server window open and select server and enter User Id & Password (*User id & Password is required when SQL server is open as SQL Server Authentication. If open as Window Authentication then User id and Password is not required.), press “CONNECT” button.

click on connect button for sql server

(4) Select Database from the list as shown.

select database from the sql database list

(5) Right-click on the selected database, options are displayed, as shown.

right click on demodatabase in sql

(6) After doing the above steps, select the “Back Up” option & press ADD button to define the path where the backup is saved.

press ADD button to define the path where the backup is saved in sql

(7) After that, a new window opens and press the “Assist” button and define the path where the selected backup is saved, as shown.

press the “Assist” button and define the path where the selected backup is saved in sql

(8) A new window open, select the folder and enter the name of the backup file and then press the “OK” button 3 times (because 3 new windows open for taking backup file.), as shown.

locate database files window open in sql

(9) In the figure, notice that backup is started executing. When it is 100% then the backup process is completed and you will find the database backup as per the defined path.

demo database completed successfully in sql

Use of ALIASES operator in SQL
Use of BETWEEN Operator in SQL
Use of IN operator in SQL
How to Install AL code extension in VS Editor
Getting Started with AL– Microsoft Docs

Leave a Reply