SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Transaction log for database is full
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shzkhan28
Starting Member

Singapore
15 Posts

Posted - 09/15/2009 :  22:12:46  Show Profile  Reply with Quote
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 error
Msg 9002,Level 17 ,State 2,Line 1
The 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

494 Posts

Posted - 09/16/2009 :  13:13:27  Show Profile  Reply with Quote
change database to simple recovery mode and then run alter table command.

alter database <your database name> set recovery simple
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 09/16/2009 :  23:37:20  Show Profile  Reply with Quote
What Exactly are you doing?
Go to Top of Page

shzkhan28
Starting Member

Singapore
15 Posts

Posted - 09/17/2009 :  04:20:21  Show Profile  Reply with Quote
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
Go to Top of Page

shzkhan28
Starting Member

Singapore
15 Posts

Posted - 09/17/2009 :  04:22:55  Show Profile  Reply with Quote
quote:
Originally posted by sodeep

What Exactly are you doing?



Increasing Numeric Column Width by 1 digit.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 09/17/2009 :  07:33:44  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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 - http://www.sqlservercentral.com/articles/64582/

--
Gail Shaw
SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000