m*****h
发帖数: 18 | 1 I have a database with Full Recovery Model, I need to schedule one Full
backup on every sunday night, and Differential backup on every night and
mutiple Transaction Log backup every 2/3 hours. How should I do it?
When taking about backing up database, should I also back up the log file?
if so, how should i do it? thanks? | w*******e
发帖数: 1622 | 2 maintenance plan那里有你问的所有答案
【在 m*****h 的大作中提到】
: I have a database with Full Recovery Model, I need to schedule one Full
: backup on every sunday night, and Differential backup on every night and
: mutiple Transaction Log backup every 2/3 hours. How should I do it?
: When taking about backing up database, should I also back up the log file?
: if so, how should i do it? thanks?
| a*******t
发帖数: 891 | 3 yep, maintenance plan. add a schedule
【在 m*****h 的大作中提到】
: I have a database with Full Recovery Model, I need to schedule one Full
: backup on every sunday night, and Differential backup on every night and
: mutiple Transaction Log backup every 2/3 hours. How should I do it?
: When taking about backing up database, should I also back up the log file?
: if so, how should i do it? thanks?
| m*****h
发帖数: 18 | 4 Thanks for the reply. should I create a separate maintenance plan for Full
backup, differential backup and transaction log backup? then add a schedule
for each backup? When backuping a user db, should i select the master, msdb database too? Thanks | j*****n
发帖数: 1781 | 5 try out using SSIS for your backup/maintenance plan, it is simple and
straight forward. | w*******e
发帖数: 1622 | 6 在2K5里, maintenance plan就是用SSIS的
【在 j*****n 的大作中提到】
: try out using SSIS for your backup/maintenance plan, it is simple and
: straight forward.
|
|
