Post reply

Moving T-logs from one drive to another

  • June 3, 2008 at 3:50 pm

    #122519

    Experts, I have 15 db that I need to move the transaction log to another drive, but the problem i have is that we are running replication on all of the db's.

    Which will be the best way to handle this - thanks

  • June 3, 2008 at 4:12 pm

    #823903

    http://msdn.microsoft.com/en-us/library/ms174269.aspx

    Excerpt from books online:

    Moving a file to a new location

    The following example moves the Test1log2 file created in example A to a new directory.

    Note:

    You must physically move the file to the new directory before running this example. Afterward, stop and start the instance of SQL Server or take the AdventureWorks database OFFLINE and then ONLINE to implement the change.

    Copy Code

    USE master;

    GO

    ALTER DATABASE AdventureWorks

    MODIFY FILE

    (

    NAME = Test1log2,

    FILENAME = N'c:\t1dat2.ldf'

    );

    GO

    Manu

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply