SQLServer 2012 镜像部署

共1338个字

环境说明:
Citrix DDC 高可用部署
Windows Server 2012 R2
SQL Server 2012 (建议更新到SP4)

SQLServer01      172.16.100.11

SQLServer02     172.16.100.12

SQLServerWit     172.16.100.20

管理员域账号 DBAdmin  把这个账户加入三台SQLServer服务器的Administrators组

镜像服务域账号 DBAcc

使用DBAdmin账户登陆SQLServer服务器

SQLServer安装的功能:

实例功能

| -数据库引擎服务

| | -SQL Server 复制

| -Analysis Services

| -Reporting Service – 本机

共享功能

| -客户端工具连接

| -管理工具 – 基本

| | -管理工具 – 完整

SQLServer服务账户设置:

SQL Server 代理               DBAcc    自动

SQL Server 数据库引擎         DBAcc    自动

SQL Server Analysis Services    DBAcc    自动

SQL Server Reporting Service    DBAcc    自动

SQL Server Browser             默认      自动

SQLServer 服务器配置:

身份验证模式            混合模式

指定SQL Server 管理员为 DBAdmin

Analysis Services服务器配置:

服务器模式                     多维和数据挖掘模式(M)

指定Analysis Services管理员为  DBAdmin

其他选项默认或者按照喜好自己安装

SQLServer防火墙设置

开放TCP 1433,5022 端口

开放UDP 1434 端口

注:1433端口为默认SQL Server端口,5022为SQL Server镜像端口,1434 为SQL ServerBrowser 服务

开启镜像:

在SQLServer01备份数据库,注意数据类型要完整

备份刚才数据库的事务日志,数据类型选择事务日志(记录把备份的文件名修改,不然覆盖刚才的备份了)

在SQLServer02 还原数据库,注意在文件页面,勾选将所有文件重新定位到文件夹,在选项页面,恢复状态选择RESTORE WITH NERECOVERY,确定即可看到数据库显示正在还原;

右键该数据库选择任务-还原-事务日志,把刚才备份的事务日志添加进来,在选项页面勾选不对数据库执行任何操作,确定即可。

注:如果导入事务日志有错误,重新到SQLServer01备份数据库和事务日志(记得先删掉原来的备份),然后重新在SQLServer02 还原即可

确定数据库的状态处于(正在还原…)

回到SQLServer01,在你的数据库右键-任务-镜像 选择配置安全性

选择包含见证服务器

主体服务器不可更改,直接下一步

镜像服务器实例选择SQLServer02 ,默认使用了DBAdmin登陆的服务器,直接选择Windows身份验证即可

见证服务器实例选择SQLServerWit,选择Windows身份验证

服务账户全部选择SQLAcc

在弹出的窗口中选择开始镜像即可

❤ 喜欢 0

5条回应:“SQLServer 2012 镜像部署”

  1. gamefly说道:

    you are in reality a just right webmaster. The web site
    loading velocity is incredible. It kind of feels that you are
    doing any distinctive trick. Moreover, The contents are masterwork.

    you have done a wonderful process in this matter!

  2. Heya i am for the primary time here. I came across this
    board and I to find It really helpful & it helped me
    out a lot. I hope to present something back and aid others like you helped me.

  3. gamefly说道:

    For hottest information you have to pay a quick visit web and on the
    web I found this web page as a best web page for latest updates.

  4. Hey there! I know this is somewhat off topic but I was wondering if you knew where I could find a captcha plugin for my comment form?
    I’m using the same blog platform as yours and I’m having problems
    finding one? Thanks a lot!

  5. This is the perfect blog for anyone who really wants to find
    out about this topic. You know so much its almost hard
    to argue with you (not that I actually would want to…HaHa).
    You definitely put a new spin on a subject that has been discussed for years.
    Wonderful stuff, just excellent!

gamefly进行回复 取消回复

必填项已用*标注

归档于 Windows