sql server2000 怎样备份日志和清空日志？(30分)

B

book523

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-24

• #1

sql server2000 怎样备份日志和清空日志？

 

南

南宫吹云

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-24

• #2

备份日志文件：
backup log yourdatabasename to disk='d:/temp.dat';

清日志文件：
backup log yourdatabasename with truncate_only;

 

B

book523

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-21

• #3

接受答案了.