Home Forums SQL Server 7,2000 Backups Recovery Model resets to Simple for MSDB on reboot RE: Recovery Model resets to Simple for MSDB on reboot
Allen Cui-55137
SSC Guru
Points: 51650
More actions
February 12, 2004 at 10:05 am
#493843
Use sp_procoption to set stored procedure to autoexection runs every time SQL Server is started. In the stored procedure, run alter database command to set database in full recovery mode.