Home Forums SQL Server 2005 Administering Virtual SQL Server Cluster Group Selection - Data Files RE: Virtual SQL Server Cluster Group Selection - Data Files

  • That's totally normal. During installation of SQL 2005 you cannot choose a separate drive for logfiles, so the system databases always have datafiles and logfiles in the same directory. You can move them if you really want, but usually for system databases it's not so important to have the logfiles on a separate drive.

    For moving system databases see here http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx.

    But be very carefull with moving the resource database. http://support.microsoft.com/kb/947989 and

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/01/22/error-945-severity-14-state-2-database-mssqlsystemresource-cannot-be-opened.aspx

    [font="Verdana"]Markus Bohse[/font]