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;”的作用是什么呢?
------解决方案--------------------只不过是一种安全考虑呀,出错可以进行补救呀