How to Back Up an SQL Server Database Using Transact SQL

To back up an SQL Server database using Transact SQL, you can use the BACKUP DATABASE statement. Here are the steps:

1. Open SQL Server Management Studio and connect to the database you want to back up.

2. Open a new query window by clicking "New Query" in the toolbar.

3. In the query window, enter the following Transact SQL statement:

``` BACKUP DATABASE database_name TO DISK = 'backup_path\backup_file.bak' WITH INIT; ```

Replace `database_name` with the name of the database you want to back up and `backup_path\backup_file.bak` with the location and name of the backup file. For example, you can use `C:\Backup\MyDatabase.bak` as the backup path and file name.

The `WITH INIT` option specifies that the backup file should be overwritten if it already exists. If you don't include this option, you will get an error if the backup file already exists.

4. Execute the query by clicking the "Execute" button in the toolbar or pressing F5.

5. After the backup is complete, verify that the backup file exists at the specified location.

That's it! You have backed up your SQL Server database using Transact SQL. Remember to regularly back up your database to ensure that you can recover data in case of data loss or corruption.