how to shrink database in sql - cSharp Coder

Latest

cSharp Coder

Sharp Future

Friday, October 4, 2019

how to shrink database in sql

ALTER DATABASE DB_NAME SET RECOVERY SIMPLE
DBCC SHRINKFILE('DB_NAME_log',1) 
ALTER DATABASE DB_NAME SET RECOVERY FULL

No comments:

Post a Comment