Sleeper Veteran Posted February 10, 2004 Veteran Share Posted February 10, 2004 I have setup a SQL 2000 Cluster, I have 2x 72GB Raid5 Partitions 1 for the logs and one for the databases. What im wanting to know is how do I move the SQL Transaction logs for the databases to the Log drive, because as default they go on the same drive as the databases. Cheers Link to comment https://www.neowin.net/forum/topic/140038-moving-sql-2000-logs/ Share on other sites More sharing options...
Steven Posted February 10, 2004 Share Posted February 10, 2004 sp_detach_db Link to comment https://www.neowin.net/forum/topic/140038-moving-sql-2000-logs/#findComment-1715813 Share on other sites More sharing options...
Steven Posted February 10, 2004 Share Posted February 10, 2004 http://support.microsoft.com/default.aspx?...kb;en-us;272318 Link to comment https://www.neowin.net/forum/topic/140038-moving-sql-2000-logs/#findComment-1715823 Share on other sites More sharing options...
Sleeper Veteran Posted February 10, 2004 Author Veteran Share Posted February 10, 2004 xStainDx said: http://support.microsoft.com/default.aspx?...kb;en-us;272318 am i missing something here, just all i can see on that page is how to shrink the log... your help is greatly appreciated. Link to comment https://www.neowin.net/forum/topic/140038-moving-sql-2000-logs/#findComment-1715868 Share on other sites More sharing options...
ForkliftDude Posted February 10, 2004 Share Posted February 10, 2004 this is the right one: http://support.microsoft.com/default.aspx?...kb;EN-US;224071 Link to comment https://www.neowin.net/forum/topic/140038-moving-sql-2000-logs/#findComment-1715897 Share on other sites More sharing options...
Steven Posted February 10, 2004 Share Posted February 10, 2004 ForkliftDude said: this is the right one:http://support.microsoft.com/default.aspx?...kb;EN-US;224071 exacty in my first post i wrote sp_detach_db :) then i just gave you something extra to shrink the logs if you wanted that also! Link to comment https://www.neowin.net/forum/topic/140038-moving-sql-2000-logs/#findComment-1717567 Share on other sites More sharing options...
ForkliftDude Posted February 11, 2004 Share Posted February 11, 2004 i think some extra around sp_detach would have helped too, or else he'd have detached his databases and then stood there without a followup clue. Link to comment https://www.neowin.net/forum/topic/140038-moving-sql-2000-logs/#findComment-1720947 Share on other sites More sharing options...
Recommended Posts