Fix Suspended Database steps,and reset mirroring

-- Removemirroring

ALTER DATABASE token SET PARTNER off

-- dropdatabase on secondary

drop DATABASE token

--disable job on primary

USE msdb;

GO

EXECdbo.sp_update_job

    @job_name = N'LSBak_token',

    @enabled = 0;

GO

-- backup database on primary and copy to secondary

Backup database token  TODISK='c:\MSSQL\DATA\token.bak'

Backup log token TO DISK='c:\MSSQL\DATA\token_log.bak'

--restore database on secondary

restore database token from DISK='c:\MSSQL\DATA\token.bak'

with norecovery

restorel og token from DISK='c:\MSSQL\DATA\token_log.bak'

with norecovery

-- setmirroring on secondary

ALTER DATABASE token SET PARTNER = 'TCP://CPCWRBISQLATP03:5022' 

-- setmirroring on primary

ALTER DATABASE token SET PARTNER = 'TCP://CPCWRBISQLATS03:5022' 

-- enablejob on primary

USE msdb;

GO

EXECdbo.sp_update_job

    @job_name = N'LSBak_token',

    @enabled = 1;

GO

Q:

Msg 3101,Level 16, State 1, Line 1

Exclusiveaccess could not be obtained because the database is in use.

Msg 3013,Level 16, State 1, Line 1

BACKUP LOG is terminating abnormally.

A:checkthe session for databasename, and kill it. try again.

sp_who2

kill 55

亿速云「云服务器」，即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘，价格低至29元/月。点击查看>>