Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Virtual SQL Server Cluster Group Selection - Data Files Expand / Collapse
Author
Message
Posted Friday, May 29, 2009 3:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 06, 2014 4:18 AM
Points: 2, Visits: 65
SQL Server 2005 Enterprise Edition SP2 x64 - Windows 2003 x64 Virtual SQL Server install under MSCS Cluster

On the Cluster Group Selection panel you have the option to define the location for the data files. I can see all the system database e.g master have been created on the Drive and Location I have provided. However the associated Transaction Log for each system database is also located on the same Drive and Folder which is undesirable.

Has anybody encountered this before .?

Thank you

Steve
Post #725679
Posted Friday, May 29, 2009 4:54 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:27 AM
Points: 4,432, Visits: 4,155
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


Markus Bohse
Post #725701
Posted Sunday, May 31, 2009 2:55 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:51 AM
Points: 5,958, Visits: 12,839
if you really need to move logs for the master,model and msdb then use the

alter database modify file command

Tempdb may also be moved but make sure not to touch dist and resource databases


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #726366
Posted Sunday, May 31, 2009 9:17 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 4:47 AM
Points: 93, Visits: 310
Hi,

yes this is normal. When we provide location for keeping up the files it didn't differentiate between a MDF or LDF file it will initially keep MASTER DATABASE files (MDF & LDF) on the same provided location. In order to move the files we can use ALTER DATABASE command.

Pleae go thru below MSDN artcile which tells how to move SYSTEM DATABASES.

http://msdn.microsoft.com/en-us/library/ms345408.aspx

Regards
GURSETHI
Post #726393
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse