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

·         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