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.
Thanks.You will not loose data between the full backup and the next transactional log backup. That is, of course, everything was done correctly.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment