How to Shrink Microsoft SQL Database | How to reduce database size | How to fast database

on

 When you database is working very slow then need to Shrink Database or Database, File and Data size is too high then need to Shrink Database.


1. Open Database 


2. Select Database, you want to Shrink


3. Open New Query

Type below query

DBCC SHRINKDATABASE (database_name, 10)


if your database name is "karim_shop" then you have type 


DBCC SHRINKDATABASE (karim_shop, 10)


4. Execute this code and wait until finish.




Comments

Post a Comment