Backups and Log Shipping

• justinh1

  Newbie

  Points: 3

  More actions

  June 23, 2003 at 8:49 am

  #106690

  I'm just about to implement log shipping on a business critical sql 2000 db, and to my surpise (Not!) the developers have it set to simple recovery model at the moment....

  The DB is ~20GB and I plan to log ship every 30 mins to a server setup for reporting. I also want to do a full/differential nightly backup with log backups during the day.

  Question, are the log files from creating the log shipping sufficient for backing up? or would I be better setting up a separate job for the backups of the logs?

  ta

  J

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  June 24, 2003 at 2:56 am

  #462754

  Yes, the Log shipping backups are sufficient for backing up, they are legitimate transaction log backups.

  If you introduce separate log backups you run the risk of breaking the log shipping mechanism.

• Clark Cruz

  SSC Veteran

  Points: 235

  More actions

  June 24, 2003 at 8:52 am

  #462837

  My solution includes a maintenance plan

  for log shipping for the hours 8 AM to 6 PM.

  Then I have a full backup job that runs

  at 7 PM. So, I have a FBU every day and

  log shipping thru the work day.