Home 
 1. Hardware 
 Check Server Hardware 
 Check SAN/DAS connectivity 
 Check Network connectivity 
 2. Installation Operating System 
 Partition System Disk 
 Installation Windows Server 20...  
 Installation of required Hotfi...  
 Installation of Proliant Suppo...  
 Installation of SQL XML & MS X...  
 Install MPIO 
 3. Active Directory infrastructur...  
 Creation of Service User Accou...  
 Assign proper rights 
 4. Preparing systems 
 Install MS DTC and COM+ compon...  
 Add Service accounts in Local ...  
 Configure NIC Binder order 
 Configure the protocols used p...  
 Install Disk Systems 
 5. Installation of Cluster 
 First Node 
 Second Node 
 Additional nodes 
 Verify Cluster 
 Post installation tasks 
 6. Configure Cluster Server 
 MS DTC Service 
 Test Cluster 
 7. Installation of SQL 
 Installation of SQL on first n...  
 Installation SQL Workstation C...  
 Installation of an additional ...  
 Installation Service Pack 1 
 Install Updated Books On Line 
 8. Post installation Tasks 
 Database file location 
 Database tuning 
 Moving TEMPDB transaction log 
 Moving master transaction log 
 9. Use full links 
 Cluster 
Moving master transaction log
We're also moving the master transaction log file towards the dedicated location.
  • Launch 'SQL Server Configuration Manager'
  • Select 'SQL Server 2005 Services'
  • Right click on 'SQL Server (MSSQLSERVER)' and select properties.
  • Click 'Advanced' tab
  • Navigate down to 'Startup Parameters'
  • Copy string to a text editor (for example notepad), and change the master log path to the 'System Transaction' path of the SQL instance

    For example:
    -dE:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;- eE:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;- lE:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

    towards
    -dE:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;- eE:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;- lF:\DBLog\mastlog.ldf
Top