deleting rows from a table, i get an error message

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)

deleting rows from a table, i get an error message

Author

Topic

pssheba
Yak Posting Veteran

95 Posts

Posted - 2007-10-01 : 10:44:41

Hi everyone,
I want to delete rows from a table:


DELETE FROM contact1
WHERE
phone1 IN(SELECT phone FROM two_phones) AND firstname1 IS NULL

But I only get the following error message:

quote:

Server: Msg 9002, Level 17, State 6, Line 1
The log file for database 'fiftyplus' is full. Back up the transaction log for the database to free up some log space.

Can anyone explain me what is it all about ?
Thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-01 : 10:48:51

your transaction log is full.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=How%20Backup%20works,What%20type%20of%20backup%20should%20I%20use,Automating%20Backups,Backup

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

Kristen
Test

22859 Posts

Posted - 2007-10-01 : 11:23:36

And possible also this:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Why%20is%20my%20LDF%20Log%20File%20so%20big

Kristen

pssheba
Yak Posting Veteran

95 Posts

Posted - 2007-10-02 : 03:21:46

Thanks a lot "SPIRIT1". I'm learning now what you have suggested.

pssheba
Yak Posting Veteran

95 Posts

Posted - 2007-10-02 : 05:21:32

Thanks Kristen.
After i get to understanding the BACKUP mechanism I'll try to learn the files on disk magnitude which also cause us problems (At the absence of a real DBA..)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources