«
»

SQL Server 2005

SQL Server 2005 doesn’t prompt during install for locations of datafiles and logfiles, meaning they will end up on C:, which you won’t normally want. You can alter the locations during install, but it’s not especially intuitive. Or at least not intuitive enough for me :(

To fix them after the event, see http://www.campus.ncl.ac.uk/databases/sqlser/SQL2005/setupsql2005.html and http://msdn2.microsoft.com/en-us/library/ms345408.aspx
and http://msdn2.microsoft.com/en-us/library/ms143547.aspx

This entry was posted on Friday, January 26th, 2007 at 16:39 and is filed under Uncategorized, old. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “SQL Server 2005”

  1. Kevinclosson says:
    26 January 2007 at 18:46

    Good post, Adrew. BTW, have you or your readers seen anything about SQL Server 2005 Scale-out reporting capabilites? I submit:

    http://kevinclosson.wordpress.com/misc/sql-server-2005-scale-out/

Leave a Reply