How to fix 10 GB database to 2mb

Quote:

---

Originally Posted by MHUii

Help me i used this code on sql server 2008 r2
it say's

---

MuOnline db>Properties>Options>Recovery model change from "full" to "simple"
now db shrinks with time!

Runing this in QA MuOnline db changed to 200mb from 19GB :d

dbcc shrinkfile (MuOnline_log, 20000, TRUNCATEONLY)

Thanks for help - neo6 and for info Abols

Quote:

---

Originally Posted by MHUii

Help me i used this code on sql server 2008 r2
it say's

---

easy way
http://4rapiddev.com/sql-server/dele...-log-ldf-file/

Quote:

---

Originally Posted by piradzins

MuOnline db>Properties>Options>Recovery model change from "full" to "simple"
now db shrinks with time!

Runing this in QA MuOnline db changed to 200mb from 19GB :d

dbcc shrinkfile (MuOnline_log, 20000, TRUNCATEONLY)

Thanks for help - neo6 and for info Abols

---

Thankyou so much!

very usefull tnx a lot xD