Shrink Database Log File after Changing Recovery Model

  1. USE [master]  
  2. GO  
  3. ALTER DATABASE[SharePoint_Config] SET RECOVERY SIMPLE WITH NO_WAIT  
  4. GO  
  5. USE [SharePoint_Config]  
  6. GO  
  7. DBCC SHRINKFILE ('SharePoint_Config_Log')  
  8. GO  
  9. ALTER DATABASE[SharePoint_Config] SET RECOVERY FULL WITH NO_WAIT 
  10. GO
  11. USE [SharePoint_Config]  
  12. GO


Comments

Post a Comment