while setting up log shipping if a copy job fails,what will be the reason

• gajapathi321

  Newbie

  Points: 7

  More actions

  February 23, 2010 at 11:31 pm

  #216005

  Hi All call u plz give the answers for the below question as iam new to this sql i had a client round but i dont have answere for these question plz plz tel me

  1.while setting up log shipping if a copy job fails,what will be the reason can any one tell me plz

  2.how do we find the last lost job restored in the secondary db

  3.pre-requirements for setting up a db and log shipping

• Tim Weintz

  SSCommitted

  Points: 1622

  More actions

  February 24, 2010 at 4:38 pm

  #1124675

  1. Any number of reasons. (eg, network, disk, authentication, etc.)

  2. Several methods. Easiest is probably via ssms, right click on the database you are concerned with and check last database log backup.

  3. Check Books On Line.