At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Phone: 800-549-4505
How to reach a live person:
Press 0 three times
Hours of Operation:
Maybe 24/7. I called at 7:00am PT on a Saturday morning and a person picked up.
I have one in the uk, some blue ray discs are region encoded (some work some don't). Uk DVD's don't work and neither do old uk playstation 1 or 2 games. However all PS3 games are region free and work fine.
If your database log gets filled. You can alter the log size if required in future too. If the log suddenly got filled and it is not occuring everyday then you have to find which query causing the log filled by executing the below
select * from syslogshold where dbid=db_id("your db name")
find out the spid and then run sp_showplan and dbcc sqltext for the particular spid and then decide upon the query whether you can stop(kill the process) it or allow it run by increasing the log space.
Be careful in production environment. Don't it kill any process without confirmation of user.
If the same query is running everyday and log is getting fill everyday then you can alter the database log space with proper approval.
If the same query is running everyday but today only log space got fill then check the growth of data decide accordingly log size of your database.
×