Skip to content

master-database.md

Latest commit

 

History

History
58 lines (44 loc) · 2.19 KB

master-database.md

File metadata and controls

58 lines (44 loc) · 2.19 KB
title master Database (SQL Server PDW)
author barbkess
ms.author barbkess
manager craigg
ms.prod analytics-platform-system
ms.prod_service mpp-data-warehouse
ms.service
ms.component
ms.technology mpp-data-warehouse
ms.custom
ms.date 01/13/2017
ms.reviewer na
ms.suite sql
ms.tgt_pltfrm na
ms.topic article
ms.assetid c71617c0-6689-4f52-81c6-58f4cf7c7377
caps.latest.revision 8
ms.workload not set

master Database

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;