Misc stuff

select name,recovery_model_desc from sys.databases

GO

Alter database DATABASENAME Set Recovery simple

GO

Declare @LogFileLogicalName sysname

select @LogFileLogicalName=Name from sys.database_files where Type=1

print @LogFileLogicalName

DBCC Shrinkfile(@LogFileLogicalName,100)

 

 

Tags: sql 2008 log

This entry was posted on Friday, July 27th, 2012 at 18:47 and is filed under Microsoft SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.