Tuesday, January 24, 2017

.::: Change Mirror Server Instance to Single User/Server on SQL Server 2012,2014,2016 :::.


1. Open SQL using SQL Management Studio






2. Open Mirror Server Instance and query and execute
alter database teguhtrihartodb set partner off
go
restore database teguhtrihartodb with recovery
go


3. expand Database on SQL Management Studio

No comments:

Post a Comment

Popular Posts