Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2009-03-10 : 14:14:30
|
| Hi,i noticed following message during logon.Failed to Login;Failed SQL: /* ~~QC */ UPDATE SEQUENCES SET SQ_SEQ_VALUE=SQ_SEQ_VALUE+/*P*/1 WHERE SQ_SEQ_NAME=/*P*/'LOGIN_SESSION_SEQ'[Mercury][SQLServer JDBC Driver][SQLServer]The transaction log for database 'qcsiteadmin_db' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases;Pl advice |
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2009-03-10 : 14:19:43
|
| Go to the Properties of the database, select Transaction Log, and make sure Automatically grow file is checked and Maximum file size is set to Unrestricted file growth. If this is all set correctly check the hard drive space where the log files are kept which is usually in the MSSQL folder. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-10 : 14:27:38
|
quote:
Originally posted by sqlserverdbam
Hi,i noticed following message during logon.Failed to Login;Failed SQL: /* ~~QC */ UPDATE SEQUENCES SET SQ_SEQ_VALUE=SQ_SEQ_VALUE+/*P*/1 WHERE SQ_SEQ_NAME=/*P*/'LOGIN_SESSION_SEQ'[Mercury][SQLServer JDBC Driver][SQLServer]The transaction log for database 'qcsiteadmin_db' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases;Pl advice
There are millions of post regarding this issue. Please search here. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-03-10 : 14:30:38
|
| You should post questions for SQL 2005 or 2008 in the SQL Server Administration (2005) or SQL Server Administration (2008) forums. You are using one or the other, since sys.databases did not exist before SQL 2005.Do you have transaction log backups setup and running on a regular basis, like every 15 minutes?CODO ERGO SUM |
|
|
|
|
|
|
Transaction log full