How to shrink database through query?

Question

Hi guys Actully i know how we can shrink data base manually in sql server it working also properlly. But i want to shrink database through query after 15 days it will be automatically take shrink process how i can do help me ? Thanks & Regards Suraj

Akshay Phadke · Answer

dont write anything in your database ID  target percentage is nothing but how much you wnant to shrink database i.e 100%.50% and so on . But  depeneds how much you can shrink and how much database shrink can be done ..

Akshay Phadke · Answer

DBCC SHRINKDATABASE ( database_name | database_id | 0 [  target_percent ] [  { NOTRUNCATE | TRUNCATEONLY } ] ) [ WITH NO_INFOMSGS ]

Subodh Natoo · Answer

Hi Suraj Execute below query in sql server ALTER DATABASE MyDatabase SET RECOVERY SIMPLE GO DBCC SHRINKFILE (MyDatabase_Log 5) GO ALTER DATABASE MyDatabase SET RECOVERY FULL GO

suraj Bhoir · Answer

Can u please give some example i do not understand :(

suraj Bhoir · Answer

hi akshay thanks for reply ur ans is correct but what have to writeen in database_id and target percent means what? plz explin