microsoft newsgroup web access
     dot net    |    ms sql    |    ms access    |    office    |    windows    |   
Microsoft ms sql group
sqlserver.ce
sqlserver.clients
sqlserver.clustering
sqlserver.connect
sqlserver.datawarehouse
sqlserver.dts
sqlserver.fulltext
sqlserver.msde
sqlserver.mseq
sqlserver.notificationsvcs
sqlserver.odbc
sqlserver.olap
sqlserver.programming
sqlserver.replication
sqlserver.reportingsvcs
sqlserver.security
sqlserver.server
sqlserver.setup
sqlserver.tools
sqlserver.xml
  
    

move transaction logs for master/model/tempdb



I am configuring a new database server that has a RAID 1 array for the
transaction logs and a RAID 10 array for the data files.

During the SQL install process you are allowed to specify the location for
all datafiles but there is no way to specify one location for log files and a
second for data files. Therefore master/model/tempdb all ended up on the RAID
10 array when I installed.

I know how to specify locations for new databases that I add, but I don't
know what to do about these existing databases.

Fri, 14 Jan 2005 11:37:04 -0800 =?Utf-8?B?RGFu?=


COPYRIGHT © 2004, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE
http://www.meetholland.com

advertisement:   complete list of microsoft newsgroup    |    uk based newsgroup    |