i have a question abt the recovery
1)on every sunday 11pm i will take full backup
2)every day each half an hour i will take tranctional backup
3)every day 11:30 differential backup back up
and on tuesday 11am the system is crashed ,then how to back up the the database without any loss? ,
Thanks in advanceRefer this SQL Server Book Online article
"How to restore a differential database backup"
No comments:
Post a Comment