Shrink to X GB (where X is the size the log needs to be for normal operation)
Thanks Gila I did backed up my data but not the log, hope its fine.
but what is the right amount of X?
On previous page Steve recommended 5gb
As I said, in the post you quoted "where X is the size the log needs to be for normal operation", now you may need to do some monitoring and work to see how much log space the database operations normally need.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass