Home Forums SQL Server 2005 Administering I have few doubts, SOMEONE PLZ ANSWER MY QUEESTIONS –Thanks in advanced. RE: I have few doubts, SOMEONE PLZ ANSWER MY QUEESTIONS –Thanks in advanced.

  • July 20, 2013 at 3:06 am

    #1634241

    rajeshn29.dba (7/20/2013)

    Hi All

    1.In mirroring If I add data file in primary server will it reflect in mirror server or not?

    If yes can you pls explain me?

    2.In transactional replication if we get ‘ log file full on subscriber end’ then how to resolve the issue.

    3.In transactional replication with updatable subscriber I have added the data file at subscriber end but it is not reflecting at the publisher end.What should I do to resolve it?

    4.In log shipping secondary server if we get log file is full then how to resolve the issue.

    1. Please refer Gail's comment; Thanks Gail.

    2. Do the same workaround as how you will do for other databases. Check the log_reuse_wait_desc column from sys.databases and do accordingly. Ideally you can keep the database in 'SIMPLE' recovery.

    3. Refer 1.

    4. Shrinking the files in PRIMARY will reflect in SECONDARY in LS/ Mirroring. So shrink the log file in Primary.