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.
PingBack from http://sqlserverforum.org/archives/2007/02/14/how-to-move-databases-using-detachattach-functions/
website url web sitemap http://dierdrejoslyn.00home.com/ website