Bookmark and Share
Set recovery model
(Publish Date: 2014-5-23 1:50pm, Total Visits: 425, Today: 1, This Week: 2, This Month: 6)

·         Set recovery model

ALTER DATABASE Market SET RECOVERY SIMPLE;

GO

ALTER DATABASE Market SET RECOVERY FULL;

GO

·         Perform a full backup

BACKUP DATABASE LogTest

                TO DISK = ‘D:\Market\LogTest_Full.bak’

WITH INIT;

GO