Creating SQL backups on Windows Server Core

In a Windows Server Core environment, you can operate Data Protection for SQL Server from only the command-line interface. You can issue the backup command to protect your Microsoft SQL Server 2012 and later versions.

About this task

To back up all or part of a SQL database on Windows Server Core, issue the following command from a Command Prompt window:

tdpsqlc backup databse_name backup_type [other_options]

To run 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

To run a full legacy backup of all databases on the SQL Server, enter the following command:

tdpsqlc backup * full /backupmethod=legacy

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