Shrink database data.
USE DatabaseName; GO -- Shrink the truncated file to 1024MB. DBCC SHRINKFILE (DataBaseFileName, 1024); GO
Shrink database log.
USE DatabaseName; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE DatabaseName SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (DatabaseFileLogName, 1); GO -- Reset the database recovery model. ALTER DATABASE DatabaseName SET RECOVERY FULL; GO
Advertisements
Hi,
Shrink database data is recommended ? Do you have any idea on this ?
Best Regards.,
Ravi Theja Madisetty
https://techguns.wordpress.com
Hi Viewers,
You want to know more about DB log shrink, refer below link.
https://msdn.microsoft.com/en-us/library/ms189493.aspx
Thanks- Ravi Theja Madisetty
https://techguns.wordpress.com
USE AdventureWorks2012;
GO
— Truncate the log by changing the database
recovery model to SIMPLE.
ALTER DATABASE AdventureWorks2012
SET RECOVERY SIMPLE;
GO
— Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (AdventureWorks2012_Log, 1);
GO
— Reset the database recovery model.
ALTER DATABASE AdventureWorks2012
SET RECOVERY FULL;
GO