Results 1 to 2 of 2

Thread: Backup query ??

  1. #1
    Join Date
    Apr 2004

    Unanswered: Backup query ??

    Im currently planning to move a Sql Server Database from one Server to another due to SAN errors on the current server.

    What I need to know is...

    Im currently restoring from last nights backup.. I then plan to apply all the transaction logs from today and tomorrow.
    (Up until downtime)

    If the database back's up between now and tomorrow will I loose data at the points between the back and the next transaction log backup ??

    Im not truncating the transaction log at backup but I just wanted to make sure that ive got this straight before I start the work.


  2. #2
    Join Date
    Sep 2003
    Dallas, Texas
    You will not loose data between the full backup and the next transactional log backup. That is, of course, everything was done correctly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts