Skip to content

Latest commit

 

History

History
50 lines (36 loc) · 1.92 KB

master-database.md

File metadata and controls

50 lines (36 loc) · 1.92 KB
title ms.custom ms.date ms.reviewer ms.suite ms.tgt_pltfrm ms.topic ms.assetid caps.latest.revision author
master Database (SQL Server PDW)
na
01/13/2017
na
na
na
article
c71617c0-6689-4f52-81c6-58f4cf7c7377
8
BarbKess

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;