Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving log file after configured Log Shipping Expand / Collapse
Author
Message
Posted Thursday, September 19, 2013 6:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 86, Visits: 301
Hi experts,
I have configured Log shipping on a database on production server. The database's data and log files are on same drive. If I want to move the log file to different drive (which is being created), will the log shipping break? plz advice me step by step.
Post #1496368
Posted Thursday, September 19, 2013 8:09 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:49 AM
Points: 811, Visits: 2,418
Hi,
Do you want to move it on the secondary, too? That'd be more problematic
I'd say no, it won't break it. Log shipping is just a backup, copy, restore of the transaction logs on a schedule. None of that has any reliance over where the database files physically reside.
Post #1496415
Posted Thursday, September 19, 2013 8:22 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 86, Visits: 301
can u plz tell me how to move log file on secondary?
Post #1496425
Posted Thursday, September 19, 2013 11:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:26 AM
Points: 381, Visits: 1,857
smtzac (9/19/2013)
can u plz tell me how to move log file on secondary?


I don't think it's possible. You have to reset the log shipping if you want to move the files. You can detach a database which is in standby mode but you cannot reattach it.
Post #1496528
Posted Friday, September 20, 2013 1:33 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 10, 2014 8:36 AM
Points: 77, Visits: 100
Hi,
The easiest way to move logshipped database

1)Stop logshipping

use master
alter database [xxx] set offline
alter database [xx] modify file (name=xxx_log, FILENAME='some_path\xxx_log.ldf')

2)Physically move log files to path 'some_path'

3)alter database [xxx] set online

6)Resume logshipping
Cheers,
Marcin
Post #1496733
Posted Friday, September 20, 2013 4:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:21 AM
Points: 2,837, Visits: 3,954
markoz.job (9/20/2013)
use master
alter database [xxx] set offline
Is it necessary to make it offline can we make it single user and then then do the rest of steps ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1496785
Posted Friday, September 20, 2013 4:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 10, 2014 8:36 AM
Points: 77, Visits: 100
Hi,
No, single user mode will not work.
Altering database in this way require setting int off and online.
Cheers,
Marcin
Post #1496790
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse