After my previous post (24 june 2009), in which I proposed a script to Shrink log Files for all DB in a SQL Server 2005 machine, now you've got a script to do the same thing on SQL Server 2008 servera:
EXECUTE sp_msforeachdb
'USE ?;
Alter Database ? Set Recovery Simple;
Alter Database ? Set Recovery Full;
DECLARE @LogLogicalName nvarchar(100);
SELECT @LogLogicalName = file_name(2);
dbcc shrinkfile(@LogLogicalName, 1);
dbcc shrinkfile(@LogLogicalName, 1);
dbcc shrinkfile(@LogLogicalName, 1);
dbcc shrinkfile(@LogLogicalName, 1);'
1 comment:
Simple to make an appointment, great value for broken monitors and fully punctually. I even acquired a half hour gauge virtually facing their creating and also as promised, was out your front door in particularly thirty minutes - highly recommend SOSav Pezzi di ricambio iPhone!
Post a Comment