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 |
|
honoredfrank
Starting Member
4 Posts |
 Posted - 2010-09-06 : 09:55:03
|
| Hi all,i am quit inexperience with sql but determin to do thing. i am trying to backup my transaction log files in SQL2000 through Enterprise Manager, but the "Transation Log" radio button is inactive. why is this so, and what should i do? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-09-06 : 10:00:48
|
| Check the recovery model for your database (right-click, Properties, Options). If it's in Simple recovery you cannot back up the transaction log, change it to full or bulk-logged. You'll then need to do a full database backup before you can do a log backup. |
 |
|
|
honoredfrank
Starting Member
4 Posts |
Posted - 2010-09-06 : 10:31:19
|
| thanks robvolk |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-06 : 12:06:49
|
| once you do this, you'll want to back up the transaction log at regular intervals, else it will grow out of control. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-09-07 : 02:42:26
|
| Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-07 : 08:47:33
|
| Also asked here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149799 |
|
|
|
|
|
|
how to back up transation log in SQL 2000