码农, 农民工的程序人生

学习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’ databaseSometime when you try to restore the backup file on an existing database and receive the followi

Steps:1. backup database DBmirror on SQL12. backup database log3. copy db and log backup files to SQL24. restore db with norecovery5. restore log with norecovery6. 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