码农, 农民工的程序人生

学习SQL的一些小材料。

Problem: You are trying to setup a mirroring on a Database called xxxDB(SQL server 2012). You are getting this error while trying to setup mirroring. “Neither the partner nor the witness server ins

Background: It's fairly common for businesses to want to provide some high availability for their SQL Server databases, and one option is to have two SQL Server databases on separate machines with a SQL Server database mirrored.

The server network address “TCP://myserverAddress:50221″ cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

 SQL Server online consultants came across an interesting scenario where one of our client was unable to restore a native SQL Server backup successfully performed from one instance running on M

One: he backup set holds a backup of a database other than the existing ‘xxdb’ database Sometime when you try to restore the backup file on an existing database and receive the followi

Steps: 1. backup database DBmirror on SQL1 2. backup database log 3. copy db and log backup files to SQL2 4. restore db with norecovery 5. restore log with norecovery 6. create endpoints on both

问题： 我有一个包含SQL服务器的虚拟机，它包含一个复制...发布者和订阅者都在这同一个虚拟机...我已经克隆了这个生产虚拟机用于测试目的，然后我放弃了复制（在测试），然后再重新创建它，但复制将无法启动，当我尝试右击发布，然后选择属性，我得到了下面的错误： SQL server replication requires the actual server name to make a co

How to solve Error: String or binary data would be truncated

由于项目需要，每次运行case的时候都需要创建数据库。虽然每次执行结束都会删除，但是不保证每次都能删除成功（这里有许多原因，我就不列举了）。所以我写了个脚本去批量删除数据库。首先为确保我们的数据库是有用的，不被错删除的。所以就必须先备份在删除。 备份数据库： DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(2