SQL Database Backup Procedures via SQL Management Studio
1. Start SQL Management Studio
2. Point to Management > Maintenance Plans
a. Right click “Maintenance Plans” and choose New Maintenance Plan
b. Give a name for a New Plan
3. In left panel, drag and drop the ‘Back Up Database Task” to right panel [Screen shot below]
1. Double click the new “Back Up Database Task”
a. Connection: Local server connection
b. Databases: **Please choose the correct database**
c. Backup Type: Full
d. Destination
i. Back up to: Disk
ii. Folder: Please choose the location for the backup file (different location of the production database)
iii. Okay to complete
2.
a. In a Job Schedule Properties
i. Give a name [Example Transaction Log Backup]
ii. Schedule type: Recurring
iii. Occurs: Daily
iv. Occurs once at: 00:00:00am (Time)
v. Okay to complete
Part B – Transaction Log Backup Procedures via SQL Management Studio
1. Start SQL Management Studio
2. Point to Management > Maintenance Plans
a. Right click “Maintenance Plans” and choose New Maintenance Plan
b. Give a name for a New Plan
3. In left panel, drag and drop the ‘Back Up Database Task” to right panel
[Screen shot below]
1. Double click the new “Back Up Database Task”
a. Connection: Local server connection
b. Databases: **Please choose the correct database**
c. Backup Type: Transaction Log
d. Destination
i. Back up to: Disk
ii. Folder: Please choose the location for the backup file (different location of the production database)
iii. Okay to complete
2.
a. Name: Transaction Log
b. Occurs: Daily
c. Recurs every: * days ( Enter schedule)
d. Occurs every: * hour(s) ( Enter schedule)
e. Starting at: 8:00am
f. Ending at: 11:59:59pm
Thats It !
No comments:
Post a Comment