One of those thorny little problems that comes up from time to time, we get asked about with monotonous regularity. Users install Microsoft SQL Server, leave the options as default, and away they go. Later on they start encountering performance problems, and really need to move those databases files to a RAID array or two - but how do you do it? It's actually quite simple...

For user databases, the sp_attach_db and sp_detach_db commands work fine. The latter detaches the database from SQL Server - obviously it must not be in use!

When you reattach, you can then move the physical data or logfile, and use that as the second parameter to sp_attach_db. This then updates SQL Server's knowledge of where the file should be and brings the database back online.

Easy as pie.

"But what about master and tempdb?", I hear you cry?

Well, that's easily enough solved as well, it's just a little more complex, and carries some additional dangers if you don't do it right. Need to know how? Contact us for some free advice on +44 (0) 800 8766 696, or info@mwm-systems.co.uk

What have you got to lose?
<<Back