MsSQL DB Backup schedule 등록하는 방법

1.     SQL connect 후 Management -> Maintenance Plans -> Maintenance Plans wizard

2.     Plans 의 Name 입력 “ Backup Plan “

3. Tasks 선택 – Full, Diff, Trans, Maintenance Cleanup

4. Databases -> All user databases 

-> Create a subdirectory for each database 

Schedule :  Full / week  ,  Diff / day  ,  Trans / Hour

Full -> weekly -> Monday -> 06:00 AM

5. Schedule -> Full per weekly , Diff per Daily , Trans per Hourly 

6.     Diff -> daily -> 06:30 AM

7. Trnas -> Daily -> Occurs every 1 hours

8. Cleanup Plan -> .bak -> Delete files 4 weeks after

9.  Execute finish

10.     SQL Agent -> Jobs -> start Job at step… ( Full, Diff, Tran, Clean )

                                                    :)