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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 how to enable transaction log

Author  Topic 

shaminda
Starting Member

25 Posts

Posted - 2005-04-13 : 15:51:42
In one of our windows 2000 servers we have SQL Server 2000 running. I’ve been trying to backup my transaction logs for the databases for some time but I’ve had no success. Today I tried to manually backup the transaction log and I discovered that on every database the transaction log option is disabled. In other words if I right click a database and select ‘All Tasks->Backup Database…’ And under ‘Backup’ there are ‘Database – complete, Database – deferential, Transaction log, File and file group:’I cannot select Transaction log because it is disabled. Does anybody know why they are disabled? How can I enable them?

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-04-13 : 16:07:24
IT sounds like your recovery model is set to simple.

Jim
Users <> Logic
Go to Top of Page

jason
Posting Yak Master

164 Posts

Posted - 2005-04-13 : 16:40:12
as opposed to full...
Go to Top of Page

shaminda
Starting Member

25 Posts

Posted - 2005-04-14 : 07:54:16
Yes, they are set to simple.
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-04-14 : 08:19:52
shaminda
look up Recovery Model in books on line. If you want to use Transaction log backups you will need to change the Recovery Model.

Jim
Users <> Logic
Go to Top of Page
   

- Advertisement -