Post reply

Backup log shipping target database?

  • July 10, 2013 at 6:36 am

    #280127

    On a log shipped database, my client wants to be able to backup the target database as well as the source.

    Is this possible?

    Thanks.

    SQL2K5 & 2008.

  • July 10, 2013 at 7:01 am

    #1631194

    On source it is possible but i fear not possible in target server as it will be restoration mode.

    why does he want that?

    Regards
    Durai Nagarajan

  • July 10, 2013 at 7:46 am

    #1631224

    Thanks, grateful for confirmation.

    He wants to do it because my client is a busy fool throwing out poorly thought out "solutions" to requirements he hasn't properly analyzed or explained. It's hard to explain the environment & politics I currently work under. It forces me to ask lots of stupid questions on this forum.

    I am much obliged!

  • July 11, 2013 at 11:58 pm

    #1631806

    Hello,

    In logshipping,Generally you can take the full backup of Source Database and But in Target Server is not possible to take the full backup,As you know already Restoring means the database is not accessible. Standby means it is read-only( but users can query it – except when a log backup is being restored.)

    But full back up is not possible in Target Server Database.

    Please check the below link

    http://www.sqlservercentral.com/Forums/Topic1268824-361-1.aspx#bm1299386

    Thanks&regards,

    DBA

    SQL server DBA

  • July 12, 2013 at 2:44 am

    #1631848

    Thanks for the reply.

    As usual around here, it's not been thought through at all. :).

    Cheers.

Viewing 5 posts - 1 through 4 (of 4 total)

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