SQL script that writes sql (DLL or DML) script for DBA and Developer for MS SQL Server 2005 or 2008 or R2
Thursday, September 6, 2012
Genarate DBCC SHRINKFILE command script using Powershell
Generate DBCC SHRINKFILE shrink file command in small size as time # OUTPUT USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,10000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,9000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,8000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,7000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,6000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,5000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,4000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,3000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,2000) GO #>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment