SHRINK DATABASE IN SQL SERVER

AS SALAMO ALAIKUM WA RAHMATULLAH,

Hereunder is sample code for truncating Database log file or Database data file.

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 

--

USE AdventureWorks2012;  
GO  
-- Create a data file and assume it contains 

data.  
ALTER DATABASE AdventureWorks2012   
ADD FILE (  
    NAME = Test1data,  
    FILENAME = 'C:\t1data.ndf',  
    SIZE = 5MB  
    );  
GO  
-- Empty the data file.  
DBCC SHRINKFILE (Test1data, EMPTYFILE);  
GO  
-- Remove the data file from the database.  
ALTER DATABASE AdventureWorks2012  
REMOVE FILE Test1data;  

GO 

--
Ma Asalaam
Passion 4 Oracle