SQL Server database – Error 3743
2024-09-06 21:20:24
Database mirroring must be removed before you drop SQL Server database – Error 3743
If you try to drop a mirrored database in SQL Server before you remove mirroring you will get the following error:
Msg 3743, Level 16, State 1, Line 1
The database ‘Database_Name’ is enabled for database mirroring. Database mirroring must be removed before you drop the database.
You need to disable mirroring before deleting the database.
To disable mirroring run the following code:
ALTER DATABASE [Database_Name] SET PARTNER OFF;
GO
Now the database mirroring is removed and you will be able to drop the database.
最新文章
- 瀑布流布局(jq实现)
- WCF实现客户端自动更新-GenerateFileList
- hdu 2027
- systemd详解
- Unity3d 协程、调用函数、委托
- Linq常用查询运算符
- myEclipse修改deploy location
- 1分钟搞定超慢SQL
- Servlet配置load-on-startup
- 国内首家MR头显公司于CES惊艳亮相
- jQuery UI Autocomplete Combobox 配 ASP.NET DropDownList
- [转帖]FORFILES 的简单介绍。
- Android 开发 VectorDrawable 矢量图 (三)矢量图动画
- usb协议栈学习笔记
- 118/119. Pascal's Triangle/II
- leetcode738
- Message Loop 原理及应用
- unknown2
- C# 文件流FileStream 实现多媒体文件复制 StreamReader StreamWriter 读取写入文本
- passwd(总结)