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 = NeverLSBAKEN'

@ 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 = NeverLSBAKEN'

@ 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