{"id":2903,"date":"2022-03-08T15:28:22","date_gmt":"2022-03-08T08:28:22","guid":{"rendered":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/"},"modified":"2022-04-18T15:33:33","modified_gmt":"2022-04-18T08:33:33","slug":"sql-server-administration","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/","title":{"rendered":"SQL Server Administration"},"content":{"rendered":"\n<p>This SQL Server administration tutorial provides you with the knowledge and skills you need to administer SQL Server database servers effectively.<\/p>\n\n\n\n<p>This tutorial is for database administrators and developers, who want to administer SQL Server successfully. To follow the tutorial, you should have some fundamental database concepts. <\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\" id='basics'>Section 1. Basics <a href=\"#basics\" class=\"anchor\" id=\"basics\" title=\"Anchor for Section 1. Basics\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-system-databases\/\">System databases<\/a> &#8211; introduce you to system databases and their purposes.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\" id='backup-restore'>Section 2. Backup &amp; Restore <a href=\"#backup-restore\" class=\"anchor\" id=\"backup-restore\" title=\"Anchor for Section 2. Backup &amp; Restore\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-recovery-model\/\">Recovery model<\/a> &#8211; learn about SQL Server recovery models including simple, full, and bulk-logged.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-backup-types\/\">Backup types<\/a> &#8211; introduce to you three backup types including full backup, differential backup, and transaction log backup.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-full-backup\/\">Full backup<\/a> &#8211; show you how to create a full backup of a database.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-differential-backup\/\">Differential Backup<\/a> &#8211; learn about differential backups and how to create and restore a differential backup.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-transaction-log-backup\/\">Transaction Log Backup<\/a> &#8211; explain the transaction log backup and how to back up and restore a database from transaction log backups.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\" id='managing-logins-users-and-permissions'>Section 3. Managing Logins, Users, and Permissions <a href=\"#managing-logins-users-and-permissions\" class=\"anchor\" id=\"managing-logins-users-and-permissions\" title=\"Anchor for Section 3. Managing Logins, Users, and Permissions\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-create-login\/\">Create Login<\/a> &#8211; create a login account to log in to the SQL Server.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-create-user\/\">Create User<\/a> &#8211; create a new user in the current database.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-grant\/\">Grant permissions<\/a> &#8211; grant permissions on a securable to a principal. <\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-revoke\/\">Revoke permissions<\/a> &#8211; revoke previously granted permissions on a securable from a principal.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-alter-login\/\">Alter Login<\/a> &#8211; show you how to modify the properties of a login.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-alter-user\/\">Alter User<\/a> &#8211; rename a user, map the user with a new login account, or change the default schema of a user to another.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-drop-login\/\">Drop Login<\/a> &#8211; delete a login account from the SQL Server.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-drop-user\/\">Drop User<\/a> &#8211; remove a user from the current database.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\" id='managing-roles'>Section 4. Managing Roles <a href=\"#managing-roles\" class=\"anchor\" id=\"managing-roles\" title=\"Anchor for Section 4. Managing Roles\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-roles\/\">Roles<\/a> &#8211; learn about database roles.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-create-role\/\">CREATE ROLE<\/a>  &#8211; show you how to add a new role to the current database.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-alter-role\/\">ALTER ROLE<\/a>  &#8211; learn how to rename a role, add a member to a role, and remove a member from an existing role.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-drop-role\/\">DROP ROLE<\/a>  &#8211; walk you through the steps of removing a role from the current database.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\" id='database-mail'>Section 5. Database Mail <a href=\"#database-mail\" class=\"anchor\" id=\"database-mail\" title=\"Anchor for Section 5. Database Mail\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-mail\/\">Database Mail<\/a> &#8211; configure Database Mail and send email messages to users using SQL Server Database Engine.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\" id='blocking-deadlock'>Section 6. Blocking &amp; Deadlock <a href=\"#blocking-deadlock\" class=\"anchor\" id=\"blocking-deadlock\" title=\"Anchor for Section 6. Blocking &amp; Deadlock\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-blocking\/\">Blocking<\/a> &#8211; understand the blocking in SQL Server.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-deadlock\/\">Deadlock<\/a> &#8211; learn about the deadlock and how to simulate a deadlock in SQL Server.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\" id='table-partitioning'>Section 7. Table Partitioning <a href=\"#table-partitioning\" class=\"anchor\" id=\"table-partitioning\" title=\"Anchor for Section 7. Table Partitioning\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-table-partitioning\/\">Create a partitioned table<\/a> &#8211; learn about table partitioning and how to create a partitioned table.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-partition-existing-table\/\">Partitioning an existing table<\/a> &#8211; show you how to partition an existing table. <\/li><\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\" id='database-snapshots-contained-databases'>Section 8. Database snapshots &amp; contained databases <a href=\"#database-snapshots-contained-databases\" class=\"anchor\" id=\"database-snapshots-contained-databases\" title=\"Anchor for Section 8. Database snapshots &amp; contained databases\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-database-snapshot\/\">Database Snapshot<\/a> &#8211; learn about the database snapshots and how to create a database snapshot for the reporting or testing purposes<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-contained-databases\/\">Contained Databases<\/a> &#8211; introduce you to contained databases and how to create a contained database.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\" id='import-export-data'>Section 9. Import \/ Export Data <a href=\"#import-export-data\" class=\"anchor\" id=\"import-export-data\" title=\"Anchor for Section 9. Import \/ Export Data\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-bcp\/\">BCP<\/a> &#8211; learn how to use the SQL Server BCP utility to bulk copy data between an SQL Server instance and a file.<\/li><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-bulk-insert\/\">BULK INSERT<\/a> &#8211; show you how to use the BULK INSERT statement to load data from a file into a table.<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\" id='database-encryption'>Section 10. Database Encryption <a href=\"#database-encryption\" class=\"anchor\" id=\"database-encryption\" title=\"Anchor for Section 10. Database Encryption\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/sql-server-tde\/\">SQL Server TDE<\/a> &#8211; show you how to encrypt a database using the transparent data encryption technique.<\/li><\/ul>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>This SQL Server administration tutorial provides you with knowledge and helps you develop the skills you need to administer SQL Server database servers effectively.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":17,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2903","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server Administration<\/title>\n<meta name=\"description\" content=\"This SQL Server administration tutorial provides you with the knowledge and skills to administer SQL Server database servers effectively.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Administration\" \/>\n<meta property=\"og:description\" content=\"This SQL Server administration tutorial provides you with the knowledge and skills to administer SQL Server database servers effectively.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-18T08:33:33+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/\",\"name\":\"SQL Server Administration\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\"},\"datePublished\":\"2022-03-08T08:28:22+00:00\",\"dateModified\":\"2022-04-18T08:33:33+00:00\",\"description\":\"This SQL Server administration tutorial provides you with the knowledge and skills to administer SQL Server database servers effectively.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/sql-server-administration\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Administration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\",\"name\":\"SQL Server Tutorial\",\"description\":\"The Practical SQL Server Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Administration","description":"This SQL Server administration tutorial provides you with the knowledge and skills to administer SQL Server database servers effectively.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Administration","og_description":"This SQL Server administration tutorial provides you with the knowledge and skills to administer SQL Server database servers effectively.","og_url":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/","og_site_name":"SQL Server Tutorial","article_modified_time":"2022-04-18T08:33:33+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/","url":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/","name":"SQL Server Administration","isPartOf":{"@id":"https:\/\/www.sqlservertutorial.net\/#website"},"datePublished":"2022-03-08T08:28:22+00:00","dateModified":"2022-04-18T08:33:33+00:00","description":"This SQL Server administration tutorial provides you with the knowledge and skills to administer SQL Server database servers effectively.","breadcrumb":{"@id":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlservertutorial.net\/sql-server-administration\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlservertutorial.net\/sql-server-administration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlservertutorial.net\/"},{"@type":"ListItem","position":2,"name":"SQL Server Administration"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlservertutorial.net\/#website","url":"https:\/\/www.sqlservertutorial.net\/","name":"SQL Server Tutorial","description":"The Practical SQL Server Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlservertutorial.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/2903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/comments?post=2903"}],"version-history":[{"count":5,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/2903\/revisions"}],"predecessor-version":[{"id":3298,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/2903\/revisions\/3298"}],"wp:attachment":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/media?parent=2903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}