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)
 need help: updating table is not working

Author  Topic 

pssheba
Yak Posting Veteran

95 Posts

Posted - 2007-10-22 : 05:32:45
Hi everyone,
i run an "update" query in my sql server 2000 query analyser and get the following message:
quote:

The log file for database 'fiftyplus' is full. Back up the transaction log for the database to free up some log space.


Could anyone tell me how to backup the transaction log ?
Thanks

Kristen
Test

22859 Posts

Posted - 2007-10-22 : 11:00:29
See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Backup
Go to Top of Page

pssheba
Yak Posting Veteran

95 Posts

Posted - 2007-10-23 : 12:21:29
Thanks
Go to Top of Page
   

- Advertisement -