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)
 SQL Back up Problem in 2K

Author  Topic 

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-07-25 : 11:38:36
Hi all i am getting log back up error and then getting message that downgrading from 194K to 64 K

I have 4G and avalilabe is 2G for SQL

How can i solve this please!!!!

Thanks

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-25 : 12:34:03
Can you post the messages that you are getting please.
How are you trying to do the backup?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-07-25 : 12:36:55
it is maintainance plan Transaction log back up and it is failing saying that back up command falied to do transaction log back for the the database
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-25 : 12:43:11
Try doing a backup in query analyser.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-07-25 : 14:41:55
it still fails that way too.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-25 : 14:54:41
Please post the error messages.

Tara Kizer
Go to Top of Page
   

- Advertisement -