Tip: Take a moment to rename databases during a database attach upgrade

re: Tip: Take a moment to rename databases during a database attach upgrade

Nico de Jong — Wed, 30 Nov 2011 12:58:32 GMT

Better yet - resore, rename and move the mdf and ldf to your preferred location with T-SQL like

RESTORE DATABASE SP2010UA_IntranetPortal_Content

FROM DISK='\\SomeServer\DBUAUpgrade\WSS_Content_Intranet.bak'

WITH

MOVE 'WSS_Content_Intranet' TO 'C:\Microsoft SQL Server\MSSQL\Data\SP2010UA_IntranetPortal_Content.mdf',

MOVE 'WSS_Content_Intranet_log' TO 'C:\Microsoft SQL Server\MSSQL\Data\Logs\SP2010UA_IntranetPortal_Content_log.ldf'

re: Tip: Take a moment to rename databases during a database attach upgrade

Craig Humphrey — Tue, 29 Nov 2011 23:32:47 GMT

Better yet, don't let the GUIDs get there in the first place!

Giving new Content DBs sensible names is easy, even some of your service DBs can be named at creation time, others (I'm looking at you PerformancePoint) are harder.

Using reusable/repeatable scripts like AutoSPInstaller (autospinstaller.codeplex.com) can make life so much simpler, even in complex environments.