Restoring SQL Server databases on Windows Server Core

To restore Microsoft SQL Server 2012 and later version databases, use the restore command.

About this task

Use the following procedure to recover all or part of one or more SQL databases.

Procedure

To restore all or part of an SQL database on Windows Server Core, enter the following command at the command prompt:

tdpsqlc restore 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 file group. For example, 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, enter 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, enter the following command:

tdpsqlc restore DB_01 group=DB_01_group1

To restore all the logical files that are in the DB_01 database, enter the following command:

tdpsqlc R DB_01 file=*