Move transaction logs in SQL cluster

#1

Hi

I need to move the transaction logs for all the sql db's (including master,
model and user db's etc) to a seperate drive. Does anyone have any experience
doing this in a sql cluster?

Thanks
--
Parky

#2

Parky wrote:

Quote:

Hi

I need to move the transaction logs for all the sql db's (including
master, model and user db's etc) to a seperate drive. Does anyone
have any experience doing this in a sql cluster?

There is no difference if you move t-log in a single box machine or in a
cluster environment.
You have to pay attention to move db files ONLY on shared disk and modify,
using EM, the switch -l in startup properties of SQL Server and assign them
the new location of t-log of master database

Quote:

Thanks

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://mvp.support.microsoft.com
http://italy.mvps.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Move transaction logs in SQL cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Move transaction logs in SQL cluster - 10-25-2004 , 06:01 AM

Re: Move transaction logs in SQL cluster - 10-25-2004 , 06:51 AM