Monday, March 26, 2012

recovery

hi all,

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