sql server 2017 create mirror with error 927

本文描述了在Windows Server 2016环境下,使用SQL Server 2017和SSMS 17.9进行数据库镜像时遇到的927错误。详细记录了使用SSMS及命令行设置镜像的过程,包括primary和secondary服务器上的具体操作。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

env: Windows server 2016
        SQL Server 2017
        SSMS 17.9


SQL Server 2017 : SQL201702, SQL201703
Join AD: No
With Witness(見證伺服器): No


1.Execute database mirroring with SSMS 17.9
在使用SSMS建立database mirroring出現927錯誤,不論做幾次都是一樣的問題



2.使用command建立database mirroring
Database mirroring使用port:5022,可以自行調整。

在secondary:
command:

USE MASTER;
GO
ALTER DATABASE repltest02 SET PARTNER = 'TCP://sql201703:5022'
GO

在prumary:
command:

USE MASTER;
GO
ALTER DATABASE repltest02 SET PARTNER = 'TCP://sql201702:5022';
GO
--ALTER DATABASE repltest02 SET WITNESS = 'TCP://<Principal Server>:5024';
--GO

 

MariaDB [(none)]> use gpmall; Database changed MariaDB [gpmall]> source /root/gpmall.sql ERROR 1064 (42000) at line 1 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<!DOCTYPE html><html><head> <meta charset="utf-8"> <meta http-equiv="X-U' at line 1 ERROR 1064 (42000) at line 13 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'let locationHost = window.location.host' at line 1 ERROR 1064 (42000) at line 14 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'if ( (locationHost.indexOf('xfusion.com') > -1 || locationHost' at line 1 ERROR 1064 (42000) at line 21 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} </script> <script> window.devEnvName = 'hws'' at line 1 ERROR 1064 (42000) at line 26 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.header_url = 'is_global'' at line 1 ERROR 1064 (42000) at line 27 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.app_cookie_prefix = 'cftk'' at line 1 ERROR 1064 (42000) at line 28 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.oversea = ''' at line 1 ERROR 1064 (42000) at line 29 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.platform = 'devcloud'' at line 1 ERROR 1064 (42000) at line 30 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.appName = 'mirror'' at line 1 ERROR 1064 (42000) at line 31 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.globalVars = JSON.parse('{"Portal_devEnv_name":" hws","__POWERED_BY_DRAGO' at line 1 ERROR 1064 (42000) at line 32 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '</script> <script> window.devEnvName = 'Portal_devEnv_name'' at line 1 ERROR 1064 (42000) at line 37 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.inhuaweiEnable = String(window.platform === 'clouddragon')' at line 1 ERROR 1064 (42000) at line 38 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'localStorage.setItem('inhuaweiEnable', window.inhuaweiEnable)' at line 1 ERROR 1064 (42000) at line 40 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'localStorage.setItem('newVersion', 'true')' at line 1 ERROR 1064 (42000) at line 41 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.isNewVisionFeedback = localStorage.getItem('isNewVisionFeedback')' at line 1 ERROR 1064 (42000) at line 42 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'if (window.isNewVisionFeedback === 'false' || window.isNewVisionFeedback == null' at line 1 ERROR 1064 (42000) at line 44 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} window.isNewVersion = localStorage.getItem('newVersion')' at line 1 ERROR 1064 (42000) at line 47 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '</script> <style>@charset "UTF-8"' at line 1 ERROR 1064 (42000) at line 47 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'html{line-height:1.15' at line 1 ERROR 1064 (42000) at line 47 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-webkit-text-size-adjust:100%}body{margin:0}body{margin:0' at line 1 ERROR 1064 (42000) at line 47 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'padding:0' at line 1 ERROR 1064 (42000) at line 47 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'color: window['cftk_cookie_key_cf2']='devclouddevuibjcftk'' at line 1 ERROR 1064 (42000) at line 50 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window['headerapp_resource']={ "dir": "//devcloud-res.hc-cdn.com/HeaderAppCDN/' at line 1 ERROR 1064 (42000) at line 67 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window['service_cf3_config']={"nps":{"surveyId":"hwcloudbusurvey_key_fbd25bdbdb8' at line 1 ERROR 1064 (42000) at line 68 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '</script> </head> <body class="prerender-auto-height"> <!--insertHeaderSc' at line 1 ERROR 1064 (42000) at line 68 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window[n].config={"appId":window.service_cf3_config.furion_app_id,"setting":"per' at line 1 ERROR 1064 (42000) at line 68 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'var o=document.createElement('script')' at line 1 ERROR 1064 (42000) at line 68 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'o.src=x,o.async=!0' at line 1 ERROR 1064 (42000) at line 76 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'var d=document.body.firstChild' at line 1 ERROR 1064 (42000) at line 76 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'document.body.insertBefore(o,d)' at line 1 ERROR 1064 (42000) at line 76 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}(window.service_cf3_config.furion_cdn_url,'__fr')' at line 1 ERROR 1064 (42000) at line 76 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}</script> <!--FurionScriptEnd--> <!--insertOnloadScriptHere--> <script> ' at line 1 ERROR 1064 (42000) at line 88 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} if (isExecuteInsertInto() && !location.host.includes('dev.huawei')) { ' at line 1 ERROR 1064 (42000) at line 92 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'const random = Math.floor(Math.random() * 100) + 1' at line 1 ERROR 1064 (42000) at line 93 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'if (random <= uemLoadingRate) { window.uemBetaAppId = 'a2f87770efd837b54' at line 1 ERROR 1064 (42000) at line 95 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.uemProdAppId = 'a419e557b46b7fb81b7681a6a250909d'' at line 1 ERROR 1064 (42000) at line 96 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'const uemUrl = '//devcloud-res.hc-cdn.com/MirrorPortal-CDN/2025.4.0/hws/UEM_V4.j' at line 1 ERROR 1064 (42000) at line 97 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'let script = document.createElement('script')' at line 1 ERROR 1064 (42000) at line 98 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'script.src = uemUrl' at line 1 ERROR 1064 (42000) at line 99 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'script.async = true' at line 1 ERROR 1064 (42000) at line 100 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'let firstChild = document.body.firstChild' at line 1 ERROR 1064 (42000) at line 101 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'document.body.insertBefore(script, firstChild)' at line 1 ERROR 1064 (42000) at line 102 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} } </script> <app-root devui-devcloud-version="14.6.9" devui-assets-v' at line 1 MariaDB [gpmall]> use gpmall; Database changed MariaDB [gpmall]> source /root/gpmall.sql ERROR 1064 (42000) at line 1 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<!DOCTYPE html><html><head> <meta charset="utf-8"> <meta http-equiv="X-U' at line 1 ERROR 1064 (42000) at line 13 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'let locationHost = window.location.host' at line 1 ERROR 1064 (42000) at line 14 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'if ( (locationHost.indexOf('xfusion.com') > -1 || locationHost' at line 1 ERROR 1064 (42000) at line 21 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} </script> <script> window.devEnvName = 'hws'' at line 1 ERROR 1064 (42000) at line 26 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.header_url = 'is_global'' at line 1 ERROR 1064 (42000) at line 27 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.app_cookie_prefix = 'cftk'' at line 1 ERROR 1064 (42000) at line 28 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.oversea = ''' at line 1 ERROR 1064 (42000) at line 29 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.platform = 'devcloud'' at line 1 ERROR 1064 (42000) at line 30 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.appName = 'mirror'' at line 1 ERROR 1064 (42000) at line 31 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.globalVars = JSON.parse('{"Portal_devEnv_name":" hws","__POWERED_BY_DRAGO' at line 1 ERROR 1064 (42000) at line 32 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '</script> <script> window.devEnvName = 'Portal_devEnv_name'' at line 1 ERROR 1064 (42000) at line 37 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.inhuaweiEnable = String(window.platform === 'clouddragon')' at line 1 ERROR 1064 (42000) at line 38 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'localStorage.setItem('inhuaweiEnable', window.inhuaweiEnable)' at line 1 ERROR 1064 (42000) at line 40 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'localStorage.setItem('newVersion', 'true')' at line 1 ERROR 1064 (42000) at line 41 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.isNewVisionFeedback = localStorage.getItem('isNewVisionFeedback')' at line 1 ERROR 1064 (42000) at line 42 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'if (window.isNewVisionFeedback === 'false' || window.isNewVisionFeedback == null' at line 1 ERROR 1064 (42000) at line 44 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} window.isNewVersion = localStorage.getItem('newVersion')' at line 1 ERROR 1064 (42000) at line 47 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '</script> <style>@charset "UTF-8"' at line 1 ERROR 1064 (42000) at line 47 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'html{line-height:1.15' at line 1 ERROR 1064 (42000) at line 47 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-webkit-text-size-adjust:100%}body{margin:0}body{margin:0' at line 1 ERROR 1064 (42000) at line 47 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'padding:0' at line 1 ERROR 1064 (42000) at line 47 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'color: window['cftk_cookie_key_cf2']='devclouddevuibjcftk'' at line 1 ERROR 1064 (42000) at line 50 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window['headerapp_resource']={ "dir": "//devcloud-res.hc-cdn.com/HeaderAppCDN/' at line 1 ERROR 1064 (42000) at line 67 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window['service_cf3_config']={"nps":{"surveyId":"hwcloudbusurvey_key_fbd25bdbdb8' at line 1 ERROR 1064 (42000) at line 68 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '</script> </head> <body class="prerender-auto-height"> <!--insertHeaderSc' at line 1 ERROR 1064 (42000) at line 68 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window[n].config={"appId":window.service_cf3_config.furion_app_id,"setting":"per' at line 1 ERROR 1064 (42000) at line 68 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'var o=document.createElement('script')' at line 1 ERROR 1064 (42000) at line 68 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'o.src=x,o.async=!0' at line 1 ERROR 1064 (42000) at line 76 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'var d=document.body.firstChild' at line 1 ERROR 1064 (42000) at line 76 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'document.body.insertBefore(o,d)' at line 1 ERROR 1064 (42000) at line 76 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}(window.service_cf3_config.furion_cdn_url,'__fr')' at line 1 ERROR 1064 (42000) at line 76 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}</script> <!--FurionScriptEnd--> <!--insertOnloadScriptHere--> <script> ' at line 1 ERROR 1064 (42000) at line 88 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} if (isExecuteInsertInto() && !location.host.includes('dev.huawei')) { ' at line 1 ERROR 1064 (42000) at line 92 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'const random = Math.floor(Math.random() * 100) + 1' at line 1 ERROR 1064 (42000) at line 93 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'if (random <= uemLoadingRate) { window.uemBetaAppId = 'a2f87770efd837b54' at line 1 ERROR 1064 (42000) at line 95 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'window.uemProdAppId = 'a419e557b46b7fb81b7681a6a250909d'' at line 1 ERROR 1064 (42000) at line 96 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'const uemUrl = '//devcloud-res.hc-cdn.com/MirrorPortal-CDN/2025.4.0/hws/UEM_V4.j' at line 1 ERROR 1064 (42000) at line 97 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'let script = document.createElement('script')' at line 1 ERROR 1064 (42000) at line 98 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'script.src = uemUrl' at line 1 ERROR 1064 (42000) at line 99 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'script.async = true' at line 1 ERROR 1064 (42000) at line 100 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'let firstChild = document.body.firstChild' at line 1 ERROR 1064 (42000) at line 101 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'document.body.insertBefore(script, firstChild)' at line 1 ERROR 1064 (42000) at line 102 in file: '/root/gpmall.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} } </script> <app-root devui-devcloud-version="14.6.9" devui-assets-v' at line 1
最新发布
05-23
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值