Select size of database files before shrink
SELECT Name AS Logical_Name,(size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = 'MyDB'
GO
USE MyDB;
ALTER DATABASE MyDB
SET RECOVERY SIMPLE WITH NO_WAIT;
DBCC SHRINKFILE(MyDB_log, 1);
ALTER DATABASE MyDB SET RECOVERY FULL WITH NO_WAIT; GO
SELECT Name AS Logical_Name, (size*8)/1024 SizeMB FROM sys.master_files
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: