Even though we have a 300GB hard disk, it is running out of space when we host more and more development databases. This morning one of my program failed because its back end database log file had reached the upper limit.
All my attempt faield as recorded as following,
1. Delete the log files directly
2. Add another log file and then try to delete the primary log file
3. Detach the database, delete those log files, then tried to attach the MDF file. It failed because MS refused to attach it when certain files are missing.
In the end I changed the recovery mode of the database to Simple instead of Full as this is a development server we don't need to restore it to the point of failure, lots of space were reclaimed.
Subscribe to:
Post Comments (Atom)
9 comments:
It's genuinely very difficult in this busy life to listen news on TV, therefore I simply use the web for that reason, and obtain the newest news.
my web blog; nicorette gum coupons discount
Thanks for sharing your thoughts about medical transcriptionist
classes. Regards
Visit my web site - Coupons On snapple
Hello Dear, are you genuinely visiting this site regularly, if so then
you will definitely take nice knowledge.
Here is my website ... coupons on kotex u
Wonderful post! We will be linking to this great content
on our website. Keep up the great writing.
Have a look at my weblog; garnier olia hair color coupons
Listed here are some pointers and buying tag heuer link calibre 36 as being a
gift or for your self.
Here is my site :: tag heuer links
We stumbled over here from a different web address and thought I
may as well check things out. I like what I see so i am just following
you. Look forward to checking out your web page for a second time.
My web blog: maxwell house instant coffee coupons
Buying a used car can be tricky, no matter how much you already know about cars.
There are lots of different things to consider so that
you don't end up buying a piece of junk that breaks down right away. Use some great tips of the trade in the following article to help you make your next car choice.
An impгesѕiνe share! І've just forwarded this onto a coworker who had been conducting a little research on this. And he actually bought me breakfast because I found it for him... lol. So let me reword this.... Thank YOU for the meal!! But yeah, thanks for spending time to talk about this issue here on your website.
Also visit my web page: Pharmacy Tech training
smokeless cigarettes, electronic cigarette brands, best electronic cigarette, e cigarette, ecig, ecigarette
Post a Comment