Restoring SQL databases 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 restore command to protect your Microsoft SQL Server 2012 and later versions.

About this task

The following code samples illustrate how you can issue the restore command to recover all or part of one or more SQL databases.

Procedure

To restore all or part of a SQL database on Windows Server Core, issue the following command from a Command Prompt window:
```
tdpsqlc restore database_name backup_type [other_options]
```
To create a full database restore of databases DB_01 and DB_02, and to replace the existing databases with the database objects that are recovered from the Tivoli® Storage Manager server, issue the following command:
```
tdpsqlc restore DB_01 group=DB_01_group1
```
To restore the filegroup DB_01_group1 that belongs to the DB_01 database, issue the following command:
```
tdpsqlc restore DB_01 group=DB_01_group1
```
To restore all the logical files that are in the DB_01 database, issue the following command:
```
tdpsqlc R DB_01 file=*
```