日期:2014-05-19  浏览次数:20488 次

ALTER DATABASE pubs SET RECOVERY SIMPLE 有什么用?
sql   帮助中关于writeText函数有一个例子:
USE   pubs;
GO
ALTER   DATABASE   pubs   SET   RECOVERY   SIMPLE;
GO
DECLARE   @ptrval   binary(16)
SELECT   @ptrval   =   TEXTPTR(pr_info)  
FROM   pub_info   pr,   publishers   p
WHERE   p.pub_id   =   pr.pub_id  
      AND   p.pub_name   =   'New   Moon   Books '
WRITETEXT   pub_info.pr_info   @ptrval   'New   Moon   Books   (NMB)   has   just   released   another   top   ten   publication.   With   the   latest   publication   this   makes   NMB   the   hottest   new   publisher   of   the   year! '
GO
ALTER   DATABASE   pubs   SET   RECOVERY   SIMPLE;
GO

其中其中“ALTER   DATABASE   pubs   SET   RECOVERY   SIMPLE;”的作用是什么呢?

------解决方案--------------------
只不过是一种安全考虑呀,出错可以进行补救呀