IMG-LOGO

How to back up a database using SQL query in TSQL?

andy - 26 Feb, 2021 2348 Views 0 Comment

If you need to back up a database using SQL query in SQL Server. You can use the built-in function called 'BACKUP DATABASE'. In order to be able to successfully run the query. You need to ensure that the query is run under db_owner of the database (database owner) and also the location of the backup folder needs to have access permission.

Here is the error message if you try to back up the database into a drive location that you do not have access.

Here is the TSQL query to do a full backup of a database.


BACKUP DATABASE [mydatabasename]
TO DISK = 'C:/mydatabasename.bak'

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.

Related Articles

How to restore database using SQL query in TSQL?

If you have a database backup bak file extension and want to restore it using SQL query You can use the built in RESTORE DATABASE function Remember in order to be able to restore a database successfully You need to ...

How to get all table sizes in TSQL?

To get the information about how much space or size used by tables You can retrieve the size information by linking multiple tables in sys tables There are two tables that hold this information The first one is the sys ...