Skip to content

master-database.md

Latest commit

 

History

History
48 lines (33 loc) · 1.98 KB

master-database.md

File metadata and controls

48 lines (33 loc) · 1.98 KB
title Master database
description Learn about the master database in Parallel Data Warehouse.
author charlesfeddersen
ms.author charlesf
ms.reviewer martinle
ms.date 04/17/2018
ms.service sql
ms.subservice data-warehouse
ms.topic concept-article

Master database - Parallel Data Warehouse

The SQL Server PDW master database stores appliance-level login information and the database catalog. It is a SQL Server master database that resides on the Control node. As such, it provides similar functionality to SQL Server PDW as master provides to SQL Server.

For more information about system databases, see System Databases.

Limitations and Restrictions

The following list describes the operations you cannot perform on the SQL Server PDW master database.

You cannot:

  • Perform a differential backup of master.

  • Create user objects in master.

  • Change the collation of master.

  • Change the owner of master.

  • Drop or rename master.

  • Modify permissions to master.

  • Execute DBCC SHRINKLOG.

Related Tasks

Task Description
Create a full backup of master. Example:

BACKUP DATABASE master TO backup_directory;

For more information, see BACKUP DATABASE.
Restore the master database To restore the master database, use the Restore the Master Database page in the Configuration Manager tool.
View database catalog information. SELECT * FROM master.sys.databases;
View system-wide login and permission information. SELECT * FROM master.sys.server_permissions;

SELECT * FROM master.sys.server_principals;

SELECT * FROM master.sys.sql_logins;

Related content