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 |
|
shzkhan28
Starting Member
15 Posts |
 Posted - 2009-09-15 : 22:12:46
|
| Hi All,I am trying to change the struc of a very large volume table,thru alter table command,after a certain time it is giving errorMsg 9002,Level 17 ,State 2,Line 1The transaction log for database 'dbname' is full.To find out why space in the log cannot be reused,see .....Could any body suggest how to overcome this problem.Thanks... |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2009-09-16 : 13:13:27
|
| change database to simple recovery mode and then run alter table command.alter database <your database name> set recovery simple |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-09-16 : 23:37:20
|
| What Exactly are you doing? |
|
|
|
shzkhan28
Starting Member
15 Posts |
Posted - 2009-09-17 : 04:20:21
|
quote:
Originally posted by Peter99
change database to simple recovery mode and then run alter table command.alter database <your database name> set recovery simple
I will try this |
|
|
|
shzkhan28
Starting Member
15 Posts |
Posted - 2009-09-17 : 04:22:55
|
quote:
Originally posted by sodeep
What Exactly are you doing?
Increasing Numeric Column Width by 1 digit. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-17 : 07:33:44
|
quote:
Originally posted by shzkhan28
quote:
Originally posted by Peter99
change database to simple recovery mode and then run alter table command.alter database <your database name> set recovery simple
I will try this
Before you do that, understand what exactly you're doing and what impact it has on your ability to recover the database after deleted data or other disaster.Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Transaction log for database is full