Skip to main content

Posts

Showing posts with the label Set the Microsoft SQL Server recovery model to simple

Set the Microsoft SQL Server recovery model to simple

Set the Microsoft SQL Server recovery model to simple Before you begin final preprocessing on the source system, set the source system SQL Server recovery model to simple. By setting the recovery model to simple, you permit the high-performance bulk copy process that is optimal for running the single-user mode preprocessing scripts and bulk copy of the source data to the target system. 1. Open Microsoft SQL Server Management Studio (Start > All Programs > Microsoft SQL Server [version] > SQL Server Management Studio). 2. In Object explorer, select the database to open the Database properties - <database name> form. 3. In the Select a page pane, click Options. 4. In the Recovery model list, select Simple. 5. Click OK.