Virtual SQL Server Cluster Group Selection

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Virtual SQL Server Cluster Group Selection -...

Virtual SQL Server Cluster Group Selection - Data Files

Rate Topic

Display Mode

Topic Options

Author

Message

stephenkeogh

Posted Friday, May 29, 2009 3:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:37 AM
Points: 2, Visits: 59

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

MarkusB

Posted Friday, May 29, 2009 4:54 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:03 AM
Points: 4,218, Visits: 3,874

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

Perry Whittle

Posted Sunday, May 31, 2009 2:55 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 5,201, Visits: 11,150

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" Wink

Post #726366

GURSETHI

Posted Sunday, May 31, 2009 9:17 PM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, April 26, 2013 12:57 PM
Points: 92, Visits: 280

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 »

Permissions