Redian新闻
>
backup database sql server 2005
avatar
backup database sql server 2005# Database - 数据库
m*h
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?
avatar
w*e
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?

avatar
a*t
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?

avatar
m*h
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
avatar
j*n
5
try out using SSIS for your backup/maintenance plan, it is simple and
straight forward.
avatar
w*e
6
在2K5里, maintenance plan就是用SSIS的

【在 j*****n 的大作中提到】
: try out using SSIS for your backup/maintenance plan, it is simple and
: straight forward.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。