Blog Post

SQL Server Blog
1 MIN READ

How to move databases using detach/attach functions?

SQL-Server-Team's avatar
Mar 23, 2019
First published on MSDN on Feb 14, 2007

Quickie post this morning. I was in a review of customer support cases yesterday lunchtime and noticed a trend of cases where people get into trouble moving databases around. There is a good KB article ( http://support.microsoft.com/kb/224071/ ) which explains how to do this for user databases, master, model, tempdb and msdb. It also contains a link to a SQL Server 2005 hotfix for the problem where after detaching a databases that resides on network-attached storage, it can't be reattached.

Well worth reading to avoid downtime and a support call.


Updated Mar 23, 2019
Version 2.0
No CommentsBe the first to comment