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 |
|
dr223
Constraint Violating Yak Guru
444 Posts |
 Posted - 2012-12-11 : 12:27:52
|
| Hi, I working with SQL Server 2005.I have a table called dbo.files which has a field filesize data type int. I changed the data type to bigint and saved the table successfully. Then I open the table and increased the filesize of one record from 30 to 21073535353.It was fine... Then I returned the value back to 30 and saved. Now, I wanted to change the bigint to int. I receive the error...'files' table-Unable to modify table.The transaction log for database 'gprddevelopment' is full. To find out why space in th elog cannot be reused, see the log_reuse_wait_desc column in sys.databasesAny help please.. Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-11 : 13:22:02
|
| Your transaction is full.you need shrink it. Are you using transaction log backup? if not you can change it to simple recovery model so log doesn't grow huge. |
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-12-17 : 01:50:40
|
| The error message is telling to look in the sys.databases table for more info. Let's do that by following command: SELECT log_reuse_wait_desc FROM sys.databases WHERE [name] = 'tinylogtest';Please post the result here!! |
|
|
|
EsmondNorton
Starting Member
5 Posts |
|
|
|
|
|
Log File