backup database sql server 2005 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

backup database sql server 2005

backup database sql server 2005# Database - 数据库

m*h2008-10-02 07:10

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*e2008-10-02 07:10

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*t2008-10-02 07:10

3 楼

yep, maintenance plan. add a schedule

【在 m*****h 的大作中提到】

m*h2008-10-02 07:10

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