Backing up SQL Server databases on Windows Server Core

To back up Microsoft SQL Server 2012 and later version databases, use the backup command.

About this task

Use the following procedure to back up SQL Server databases to the Tivoli® Storage Manager server, or to take local VSS snapshots.

Procedure

To back up all or part of an SQL database on Windows Server Core, enter the following command at the command prompt:
```
tdpsqlc backup database_name backup_type [other_options]
```
where database_name specifies the name of the database, and backup_type specifies the type of backup such as a full backup. You can specify other options, such as the back up method. For example, to create a full legacy backup of SQL databases DB_01 and DB_02, enter the following command:
```
tdpsqlc backup DB_01,DB_02 full /backupmethod=legacy
```
For example, to create a full legacy backup of all databases on the SQL Server, enter the following command:
```
tdpsqlc backup * full /backupmethod=legacy
```
To back up a file group, enter the following command at the command prompt:
```
tdpsqlc backup database_name file_group
```
where database_name specifies the name of the database, and file group specifies the file group in the database. For example, to back up the filegroup DB_01_group1 that belongs to the DB_01 database, enter the following command:
```
tdpsqlc backup DB_01 Group=DB_01_group1
```