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 |
|
reoaran
Starting Member
20 Posts |
 Posted - 2010-07-26 : 09:24:17
|
| Hi,alter table tblnamealter column [col_name] varchar(30)alter table tblnamealter column col_name varchar(1000)When i was running a script for resizing of columns(around 15 to 20 columns like above) for a table, the log file got filled up and failed. The db size is 70 GB and have set the log size limit to 65 GB and then also it failed with log full error. This table has appx 17662000 rows. Does the above column resize proportional depend upon the data of these rows and hence making the log full ? In the Prod, the above query script failed when the db recovery mode was Full and success when changed to Simple without incresing the log file. But in the test environment, it succeeded with the db in Full recovery mode it self. Not sure where is the difference ? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-26 : 10:26:41
|
| Duplicate of : http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=147783 |
 |
|
|
|
|
|
Alter colum depends upong the data row ?