??????????Windows2008 R2 ??SQL 2012
??????????????????????????????????????м????????????????????????????????????????????????????????????
???????????????У???????????ipд?????????ip??????????????????
????--?????????
????USE [master]
????GO
????ALTER DATABASE [CT_DB] SET PARTNER = 'TCP://192.168.1.106:5022';   --????????????ip
????192.168.1.106????????????ip

?????????????SELECT DB_NAME([dbid]) ??* FROM sys.[sysprocesses] WHERE [spid]>49 ORDER BY [spid] ?????????????о????????????????????о????????????
????????????[CT_DB]??drop??
DROP DATABASE [CT_DB]
--ALTER DATABASE [CT_DB] SET PARTNER OFF

ALTER DATABASE [CT_DB] SET PARTNER FAILOVER
GO

ALTER DATABASE [CT_DB] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
GO

??????????????????岻????????????????????Щ??????