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

Popular posts from this blog

Using External Content Types with Stored Procedures with Input Parameters

Windows 7 Blue Screen because of ConnectiFy

HTTPS Site InfoPath Issue : You do not have permissions to access a web service that provides data required for this form to function correctly