mssql
2017
Transfer SQL Authentication Credentials between servers
·755 words·4 mins
system-administration
tech
mssql
sql
sysadmin
technology
Have you ever had to migrate a SQL instance from one server to the next?
2013
How to set a SQL database in Microsoft SQL Server to offline
·177 words·1 min
system-administration
tech
mssql
sql
sysadmin
technology
After moving a database to a new server (via backup and restore utilities built into Microsoft SQL Server) I wanted to take the copy on the old server offline to ensure when testing the move I was only accessing the new database but due to my limited (but growing) knowledge I had no idea how to take a database offline.