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.
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.
|Create a full backup of master.||Example:
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.||
|View system-wide login and permission information.||