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.
Showing posts with label due. Show all posts
Showing posts with label due. Show all posts
Subscribe to:
Comments (Atom)