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 in SQL server. Bookmark the permalink.

One Response to SQL Server 2005

  1. Kevinclosson says:

    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

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>