Deskripsi
i not recommend use shrink but if it urgent you can use it because it effect reduce perfomance to database.
How to
1. run query , to get physical name of files data or log.
select name from dbname.sys.database_files where type=1
2. to use shrink use this
Backup log dbname with truncate_only
go
DBCC shrinkfile('logicalfilename',100)
but it still not recommend use shrink , you must give a limitation of the autogrowth file data / log !!