{"id":57,"date":"2014-01-02T22:09:18","date_gmt":"2014-01-02T14:09:18","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=57"},"modified":"2014-01-02T22:09:18","modified_gmt":"2014-01-02T14:09:18","slug":"simple-step-by-step-database-mirroring","status":"publish","type":"post","link":"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html","title":{"rendered":"Simple Step by Step Database Mirroring"},"content":{"rendered":"
    \n
  1. Set the recovery model of the database to the Full Recovery model if not already set. You can make this change in SQL Server Management Studio (SSMS) on the Options tab of the Database Properties dialog. You can also manually make the change with the following command :\n
    \n
    \n
    Alter<\/span> Database<\/span> [Adventureworks] Set<\/span> Recovery Full<\/span>;<\/pre>\n
    <\/div>\n<\/div>\n
  2. Set the compatibility level of your database to level 90 or higher. Level 90 is SQL Server 2005 compatibility, and level 100 is SQL Server 2008 compatibility. You can set the compatibility level of your database in SSMS on the Options tab of the Database Properties dialog, or you can manually make the change with T-SQL. You can use the following commands to change your database\u2019s compatibility level.\n
    \n
    \n
    Alter<\/span> Database<\/span> [Adventureworks] Set<\/span> Compatibility_Level = 100;<\/pre>\n
    <\/div>\n<\/div>\n
  3. Copy all server logins from the principal server instance to the mirror server instance. First, run this script on your principal server :\n
    \n
    \n
    USE<\/span> master<\/pre>\n
    <\/p>\n
    GO<\/span><\/pre>\n
    <\/p>\n
    IF<\/span> OBJECT_ID ('sp_hexadecimal'<\/span>) IS<\/span> NOT<\/span> NULL<\/span><\/pre>\n
    <\/p>\n
      DROP<\/span> PROCEDURE<\/span> sp_hexadecimal<\/pre>\n
    <\/p>\n
    GO<\/span><\/pre>\n
    <\/p>\n
    CREATE<\/span> PROCEDURE<\/span> sp_hexadecimal<\/pre>\n
    <\/p>\n
        @binvalue varbinary(256),<\/pre>\n
    <\/p>\n
        @hexvalue varchar<\/span> (514) OUTPUT<\/span><\/pre>\n
    <\/p>\n
    AS<\/span><\/pre>\n
    <\/p>\n
    DECLARE<\/span> @charvalue varchar<\/span> (514)<\/pre>\n
    <\/p>\n
    DECLARE<\/span> @i int<\/span><\/pre>\n
    <\/p>\n
    DECLARE<\/span> @length int<\/span><\/pre>\n
    <\/p>\n
    DECLARE<\/span> @hexstring char<\/span>(16)<\/pre>\n
    <\/p>\n
    SELECT<\/span> @charvalue = '0x'<\/span><\/pre>\n
    <\/p>\n
    SELECT<\/span> @i = 1<\/pre>\n
    <\/p>\n
    SELECT<\/span> @length = DATALENGTH (@binvalue)<\/pre>\n
    <\/p>\n
    SELECT<\/span> @hexstring = '0123456789ABCDEF'<\/span><\/pre>\n
    <\/p>\n
    WHILE<\/span> (@i <= @length)<\/pre>\n
    <\/p>\n
    BEGIN<\/span><\/pre>\n
    <\/p>\n
      DECLARE<\/span> @tempint int<\/span><\/pre>\n
    <\/p>\n
      DECLARE<\/span> @firstint int<\/span><\/pre>\n
    <\/p>\n
      DECLARE<\/span> @secondint int<\/span><\/pre>\n
    <\/p>\n
      SELECT<\/span> @tempint = CONVERT<\/span>(int<\/span>, SUBSTRING<\/span>(@binvalue,@i,1))<\/pre>\n
    <\/p>\n
      SELECT<\/span> @firstint = FLOOR(@tempint\/16)<\/pre>\n
    <\/p>\n
      SELECT<\/span> @secondint = @tempint - (@firstint*16)<\/pre>\n
    <\/p>\n
      SELECT<\/span> @charvalue = @charvalue +<\/pre>\n
    <\/p>\n
        SUBSTRING<\/span>(@hexstring, @firstint+1, 1) +<\/pre>\n
    <\/p>\n
        SUBSTRING<\/span>(@hexstring, @secondint+1, 1)<\/pre>\n
    <\/p>\n
      SELECT<\/span> @i = @i + 1<\/pre>\n
    <\/p>\n
    END<\/span><\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
    SELECT<\/span> @hexvalue = @charvalue<\/pre>\n
    <\/p>\n
    GO<\/span><\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
    IF<\/span> OBJECT_ID ('sp_help_revlogin'<\/span>) IS<\/span> NOT<\/span> NULL<\/span><\/pre>\n
    <\/p>\n
      DROP<\/span> PROCEDURE<\/span> sp_help_revlogin<\/pre>\n
    <\/p>\n
    GO<\/span><\/pre>\n
    <\/p>\n
    CREATE<\/span> PROCEDURE<\/span> sp_help_revlogin @login_name sysname = NULL<\/span> AS<\/span><\/pre>\n
    <\/p>\n
    DECLARE<\/span> @name sysname<\/pre>\n
    <\/p>\n
    DECLARE<\/span> @type varchar<\/span> (1)<\/pre>\n
    <\/p>\n
    DECLARE<\/span> @hasaccess int<\/span><\/pre>\n
    <\/p>\n
    DECLARE<\/span> @denylogin int<\/span><\/pre>\n
    <\/p>\n
    DECLARE<\/span> @is_disabled int<\/span><\/pre>\n
    <\/p>\n
    DECLARE<\/span> @PWD_varbinary  varbinary (256)<\/pre>\n
    <\/p>\n
    DECLARE<\/span> @PWD_string  varchar<\/span> (514)<\/pre>\n
    <\/p>\n
    DECLARE<\/span> @SID_varbinary varbinary (85)<\/pre>\n
    <\/p>\n
    DECLARE<\/span> @SID_string varchar<\/span> (514)<\/pre>\n
    <\/p>\n
    DECLARE<\/span> @tmpstr  varchar<\/span> (1024)<\/pre>\n
    <\/p>\n
    DECLARE<\/span> @is_policy_checked varchar<\/span> (3)<\/pre>\n
    <\/p>\n
    DECLARE<\/span> @is_expiration_checked varchar<\/span> (3)<\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
    DECLARE<\/span> @defaultdb sysname<\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
    IF<\/span> (@login_name IS<\/span> NULL<\/span>)<\/pre>\n
    <\/p>\n
      DECLARE<\/span> login_curs CURSOR<\/span> FOR<\/span><\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
          SELECT<\/span> p.sid, p.name, p.type, p.is_disabled, p.default_database_name, l.hasaccess, l.denylogin FROM<\/span> <\/pre>\n
    <\/p>\n
    sys.server_principals p LEFT<\/span> JOIN<\/span> sys.syslogins l<\/pre>\n
    <\/p>\n
          ON<\/span> ( l.name = p.name ) WHERE<\/span> p.type IN<\/span> ( 'S'<\/span>, 'G'<\/span>, 'U'<\/span> ) AND<\/span> p.name <> 'sa'<\/span><\/pre>\n
    <\/p>\n
    ELSE<\/span><\/pre>\n
    <\/p>\n
      DECLARE<\/span> login_curs CURSOR<\/span> FOR<\/span><\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
          SELECT<\/span> p.sid, p.name, p.type, p.is_disabled, p.default_database_name, l.hasaccess, l.denylogin FROM<\/span> <\/pre>\n
    <\/p>\n
    sys.server_principals p LEFT<\/span> JOIN<\/span> sys.syslogins l<\/pre>\n
    <\/p>\n
          ON<\/span> ( l.name = p.name ) WHERE<\/span> p.type IN<\/span> ( 'S'<\/span>, 'G'<\/span>, 'U'<\/span> ) AND<\/span> p.name = @login_name<\/pre>\n
    <\/p>\n
    OPEN<\/span> login_curs<\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
    FETCH<\/span> NEXT<\/span> FROM<\/span> login_curs INTO<\/span> @SID_varbinary, @name, @type, @is_disabled, @defaultdb, @hasaccess, @denylogin<\/pre>\n
    <\/p>\n
    IF<\/span> (@@fetch_status = -1)<\/pre>\n
    <\/p>\n
    BEGIN<\/span><\/pre>\n
    <\/p>\n
      PRINT<\/span> 'No login(s) found.'<\/span><\/pre>\n
    <\/p>\n
      CLOSE<\/span> login_curs<\/pre>\n
    <\/p>\n
      DEALLOCATE<\/span> login_curs<\/pre>\n
    <\/p>\n
      RETURN<\/span> -1<\/pre>\n
    <\/p>\n
    END<\/span><\/pre>\n
    <\/p>\n
    SET<\/span> @tmpstr = '\/* sp_help_revlogin script '<\/span><\/pre>\n
    <\/p>\n
    PRINT<\/span> @tmpstr<\/pre>\n
    <\/p>\n
    SET<\/span> @tmpstr = '** Generated '<\/span> + CONVERT<\/span> (varchar<\/span>, GETDATE()) + ' on '<\/span> + @@SERVERNAME<\/span> + ' *\/'<\/span><\/pre>\n
    <\/p>\n
    PRINT<\/span> @tmpstr<\/pre>\n
    <\/p>\n
    PRINT<\/span> ''<\/span><\/pre>\n
    <\/p>\n
    WHILE<\/span> (@@fetch_status <> -1)<\/pre>\n
    <\/p>\n
    BEGIN<\/span><\/pre>\n
    <\/p>\n
      IF<\/span> (@@fetch_status <> -2)<\/pre>\n
    <\/p>\n
      BEGIN<\/span><\/pre>\n
    <\/p>\n
        PRINT<\/span> ''<\/span><\/pre>\n
    <\/p>\n
        SET<\/span> @tmpstr = '-- Login: '<\/span> + @name<\/pre>\n
    <\/p>\n
        PRINT<\/span> @tmpstr<\/pre>\n
    <\/p>\n
        IF<\/span> (@type IN<\/span> ( 'G'<\/span>, 'U'<\/span>))<\/pre>\n
    <\/p>\n
        BEGIN<\/span> -- NT authenticated account\/group<\/span><\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
          SET<\/span> @tmpstr = 'CREATE LOGIN '<\/span> + QUOTENAME( @name ) + ' FROM WINDOWS WITH DEFAULT_DATABASE = ['<\/span> + @defaultdb + ']'<\/span><\/pre>\n
    <\/p>\n
        END<\/span><\/pre>\n
    <\/p>\n
        ELSE<\/span> BEGIN<\/span> -- SQL Server authentication<\/span><\/pre>\n
    <\/p>\n
            -- obtain password and sid<\/span><\/pre>\n
    <\/p>\n
                SET<\/span> @PWD_varbinary = CAST<\/span>( LOGINPROPERTY( @name, 'PasswordHash'<\/span> ) AS<\/span> varbinary (256) )<\/pre>\n
    <\/p>\n
            EXEC<\/span> sp_hexadecimal @PWD_varbinary, @PWD_string OUT<\/span><\/pre>\n
    <\/p>\n
            EXEC<\/span> sp_hexadecimal @SID_varbinary,@SID_string OUT<\/span><\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
            -- obtain password policy state<\/span><\/pre>\n
    <\/p>\n
            SELECT<\/span> @is_policy_checked = CASE<\/span> is_policy_checked WHEN<\/span> 1 THEN<\/span> 'ON'<\/span> WHEN<\/span> 0 THEN<\/span> 'OFF'<\/span> ELSE<\/span> NULL<\/span> END<\/span> FROM<\/span> sys.sql_logins WHERE<\/span> name = @name<\/pre>\n
    <\/p>\n
            SELECT<\/span> @is_expiration_checked = CASE<\/span> is_expiration_checked WHEN<\/span> 1 THEN<\/span> 'ON'<\/span> WHEN<\/span> 0 THEN<\/span> 'OFF'<\/span> ELSE<\/span> NULL<\/span> END<\/span> FROM<\/span> sys.sql_logins WHERE<\/span> name = @name<\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
                SET<\/span> @tmpstr = 'CREATE LOGIN '<\/span> + QUOTENAME( @name ) + ' WITH PASSWORD = '<\/span> + @PWD_string + ' HASHED, SID = '<\/span> + @SID_string + ', DEFAULT_DATABASE = ['<\/span> + @defaultdb + ']'<\/span><\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
            IF<\/span> ( @is_policy_checked IS<\/span> NOT<\/span> NULL<\/span> )<\/pre>\n
    <\/p>\n
            BEGIN<\/span><\/pre>\n
    <\/p>\n
              SET<\/span> @tmpstr = @tmpstr + ', CHECK_POLICY = '<\/span> + @is_policy_checked<\/pre>\n
    <\/p>\n
            END<\/span><\/pre>\n
    <\/p>\n
            IF<\/span> ( @is_expiration_checked IS<\/span> NOT<\/span> NULL<\/span> )<\/pre>\n
    <\/p>\n
            BEGIN<\/span><\/pre>\n
    <\/p>\n
              SET<\/span> @tmpstr = @tmpstr + ', CHECK_EXPIRATION = '<\/span> + @is_expiration_checked<\/pre>\n
    <\/p>\n
            END<\/span><\/pre>\n
    <\/p>\n
        END<\/span><\/pre>\n
    <\/p>\n
        IF<\/span> (@denylogin = 1)<\/pre>\n
    <\/p>\n
        BEGIN<\/span> -- login is denied access<\/span><\/pre>\n
    <\/p>\n
          SET<\/span> @tmpstr = @tmpstr + '; DENY CONNECT SQL TO '<\/span> + QUOTENAME( @name )<\/pre>\n
    <\/p>\n
        END<\/span><\/pre>\n
    <\/p>\n
        ELSE<\/span> IF<\/span> (@hasaccess = 0)<\/pre>\n
    <\/p>\n
        BEGIN<\/span> -- login exists but does not have access<\/span><\/pre>\n
    <\/p>\n
          SET<\/span> @tmpstr = @tmpstr + '; REVOKE CONNECT SQL TO '<\/span> + QUOTENAME( @name )<\/pre>\n
    <\/p>\n
        END<\/span><\/pre>\n
    <\/p>\n
        IF<\/span> (@is_disabled = 1)<\/pre>\n
    <\/p>\n
        BEGIN<\/span> -- login is disabled<\/span><\/pre>\n
    <\/p>\n
          SET<\/span> @tmpstr = @tmpstr + '; ALTER LOGIN '<\/span> + QUOTENAME( @name ) + ' DISABLE'<\/span><\/pre>\n
    <\/p>\n
        END<\/span><\/pre>\n
    <\/p>\n
        PRINT<\/span> @tmpstr<\/pre>\n
    <\/p>\n
      END<\/span><\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
      FETCH<\/span> NEXT<\/span> FROM<\/span> login_curs INTO<\/span> @SID_varbinary, @name, @type, @is_disabled, @defaultdb, @hasaccess, @denylogin<\/pre>\n
    <\/p>\n
       END<\/span><\/pre>\n
    <\/p>\n
    CLOSE<\/span> login_curs<\/pre>\n
    <\/p>\n
    DEALLOCATE<\/span> login_curs<\/pre>\n
    <\/p>\n
    RETURN<\/span> 0<\/pre>\n
    <\/p>\n
    GO<\/span><\/pre>\n
    <\/div>\n<\/div>\n
  4. After that, run this procedure\n
    \n
    \n
    EXEC<\/span> sp_help_revlogin<\/pre>\n
    <\/div>\n<\/div>\n
    The output script that is generated by the sp_help_revlogin stored procedure is the login script. This login script creates the logins that have the original Security Identifier (SID) and the original password.<\/p>\n
  5. On server B, start SQL Server Management Studio, and then connect to the instance of SQL Server to which you moved the database.\n
    For complete documentation about copy login, you can learn it here http:\/\/support.microsoft.com\/kb\/918992<\/p>\n
  6. Backup your Database on principal server\n
    \n
    \n
    backup<\/span> database<\/span> Adventureworks <\/pre>\n
    <\/p>\n
    to<\/span> disk<\/span> = 'D:\\BackupMirroring\\Adventureworks\\AW.bak'<\/span> with<\/span> format<\/pre>\n
    <\/p>\n
    go<\/span><\/pre>\n
    <\/p>\n
    backup<\/span> log Adventureworks to<\/span> disk<\/span> = 'D:\\BackupMirroring\\Adventureworks\\AWLog.bak'<\/span><\/pre>\n
    <\/p>\n
    go<\/span><\/pre>\n
    <\/div>\n<\/div>\n
  7. Create Database Adventureworks at Mirror Server. And then restore it on Mirror Server\n
    \n
    \n
    restore<\/span> database<\/span> Adventureworks from<\/span> disk<\/span> = 'E:\\Adventureworks\\AW.BAK'<\/span> with<\/span> replace, norecovery<\/pre>\n
    <\/p>\n
    go<\/span><\/pre>\n
    <\/p>\n
    restore<\/span> log Adventureworks from<\/span> disk<\/span> = 'E:\\Adventureworks\\AWlog.BAK'<\/span> with<\/span> norecovery<\/pre>\n
    <\/p>\n
    Go<\/span><\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/p>\n
     <\/pre>\n
    <\/div>\n<\/div>\n
  8. Now that you have prepared your database, you can move on to setting up database mirroring by using the Database Mirroring Wizard.\n
  9. if you do not use a wizard or prefer to use T-SQL to create a database mirroring, please continue to Setting up Database Mirroring in SQL Server 2008 R2 using T-SQL<\/a><\/strong> <\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
    Set the recovery model of the database to the Full Recovery model if not already set. You can make this change in SQL Server Management Studio (SSMS) on the Options tab of the Database Properties dialog. You can also manually make the change with the following command : Alter Database \u2026<\/p>\n
     Continue reading<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[20],"class_list":["post-57","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-mirroring"],"yoast_head":"\nSimple Step by Step Database Mirroring - Suherman Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Simple Step by Step Database Mirroring - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Set the recovery model of the database to the Full Recovery model if not already set. You can make this change in SQL Server Management Studio (SSMS) on the Options tab of the Database Properties dialog. You can also manually make the change with the following command : Alter Database \u2026 Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-02T14:09:18+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Simple Step by Step Database Mirroring\",\"datePublished\":\"2014-01-02T14:09:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html\"},\"wordCount\":288,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"keywords\":[\"Mirroring\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html\",\"url\":\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html\",\"name\":\"Simple Step by Step Database Mirroring - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"datePublished\":\"2014-01-02T14:09:18+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Simple Step by Step Database Mirroring\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"http:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Simple Step by Step Database Mirroring - Suherman Blog","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":"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html","og_locale":"en_US","og_type":"article","og_title":"Simple Step by Step Database Mirroring - Suherman Blog","og_description":"Set the recovery model of the database to the Full Recovery model if not already set. You can make this change in SQL Server Management Studio (SSMS) on the Options tab of the Database Properties dialog. You can also manually make the change with the following command : Alter Database \u2026 Continue reading","og_url":"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2014-01-02T14:09:18+00:00","author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Simple Step by Step Database Mirroring","datePublished":"2014-01-02T14:09:18+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html"},"wordCount":288,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"keywords":["Mirroring"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html","url":"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html","name":"Simple Step by Step Database Mirroring - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"datePublished":"2014-01-02T14:09:18+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/simple-step-by-step-database-mirroring.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"Simple Step by Step Database Mirroring"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"http:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/57","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=57"}],"version-history":[{"count":2,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/57\/revisions"}],"predecessor-version":[{"id":429,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/57\/revisions\/429"}],"wp:attachment":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}