That basically means that we don't know what has caused such growth, but I would still try step #2.
Remember to backup!
Aderson
Last time I will bother you tonight :)
Under database server in the Host dashboard, it shows data in the DB mdf file at 21 MB And another file ldf file at 4,604 MB
http://www.coatofarms.jp/xHero/logs2.gif
Does that info change the approach? or do we now back it up and run the truncate scripts?
Thanks a million!
Bruce
It won't change Bruce. To be precise, your scripts will look like this:
dbcc shrinkfile(coajp_DotNetNuke_8 ,1) go dbcc shrinkfile(coajp_DotNetNuke_8_log,1) go backup log [coajp_DotNetNuke_8] with truncate_only go
Cheers,
Sorry Aderson...
2 things...
1) should I actually include the square brackets [ ] on the last one?
2) Is this 3 separate scripts or 1? I think it is 3... with "go" being where I run the script..or press the run script button. I think I don't actually type/paste the word go in there..right?
Sorry...amateur questions :)
Hi Bruce,
No worries. You can paste the hole thing at once as I have posted.
Remember the backup!