 Posted 3/17/2009 12:07:46 PM
|
|
|
|
| Hello, I user MS SQL Server 2008 and it's work very nice until anyone can use my database. I got this message : The transaction log for database 'mydatabasename' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases It's important because my members cannot login in my application. Thank you for any information that can help me.
Louis
|
|
|
Posted 3/17/2009 12:08:43 PM
|
|
|
|
Truncate the Log in the Control Panel for your hosting account.
Paul BRe-invent Technologies LLC
http://www.re-invent.com
Innovative ASP.NET 3.5/2.0 Hosting
Now with Windows 2008 Hosting and SQL 2008
Celebrating 10 Years in Business!
|
|
|
Posted 3/17/2009 12:17:10 PM
|
|
|
|
| Thank you for your verf fast answer Paul. I really appreciate. But I try to find out where I can got in Control Panel. I see Account Management, Customer Support, Tools and Utilities. I suppose it's in Tools and Utilities but I dont see where. Can you help me a bit more please. (I use the connexion for the Control Panel before ocotober 2008). Thank a lot.
Louis
|
|
|
Posted 3/17/2009 12:26:12 PM
|
|
|
|
A member of our support team truncated the log for you. This feature is currently not available in the Custoemr Portal.
Paul BRe-invent Technologies LLC
http://www.re-invent.com
Innovative ASP.NET 3.5/2.0 Hosting
Now with Windows 2008 Hosting and SQL 2008
Celebrating 10 Years in Business!
|
|
|
Posted 3/17/2009 12:35:24 PM
|
|
|
|
| Thank you a lot dear Paul. Do you think it's can be append again? How to prevent this? I got a Pay site and my customers use it a lot at anytime. BTW, Re-invent have a very good uptime (almost 100%) and it's very appreciate!
Louis
|
|
|
Posted 3/17/2009 12:39:14 PM
|
|
|
|
Hello,
It could be that you performed many transactions on your database? Could be other coding issues? You just may need more disk space possibly.
The server / network you are on actually has been at 100% uptime. Except for any monthly security updates that needed to be done during off hours.
Paul BRe-invent Technologies LLC
http://www.re-invent.com
Innovative ASP.NET 3.5/2.0 Hosting
Now with Windows 2008 Hosting and SQL 2008
Celebrating 10 Years in Business!
|
|
|
Posted 3/17/2009 12:57:29 PM
|
|
|
|
| Hi dear Paul, Everything is back to normal  Yes my membres have a lot of transactions. This is why I choose MS SQL Server 2008 with 600Mb with Re-Invent.. If I check my database Properties, it's show Size = 166 Mo and Space Avalaibale = 0.73 Mo. Regardless those statitics you think I have to get more space? And why Space Available is only 0.73? Thank you again for your fast service!
Louis
|
|
|
Posted 3/17/2009 1:01:22 PM
|
|
|
|
Thats the space available before the database grows to the next level. Currently set to grow in 1MB increments. We're showing 66MB out of 600MB is currently actually being used at this time after truncating and shrinking the database.
Paul BRe-invent Technologies LLC
http://www.re-invent.com
Innovative ASP.NET 3.5/2.0 Hosting
Now with Windows 2008 Hosting and SQL 2008
Celebrating 10 Years in Business!
|
|
|
Posted 3/17/2009 1:26:59 PM
|
|
|
|
Ok thank you Paul. Everything is ok for now. Have nice day.
Louis
|
|
|
|