Skip to main content

sql

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.