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
 Analysis Services (2000)
 Transaction Log is full

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-12-10 : 07:47:07
Yogesh writes "Hi

I am trying to built a cube on server but it's giving remark.
""The cube scheduled to be built on 11/29/2004 at 2:03 AM failed. (-2147217900) The log file for database 'projectserver' is full. Back up the transaction log for the database to free up some log space. "

and the other is
"The cube scheduled to be built on 11/29/2004 at 4:27 AM failed.
(-2147217871) Timeout expired
"

please help me regarding this issue

Thanks
Yogesh
maiytrya@rediffmail.com"

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-12-10 : 17:59:19
I would start by doing what it says to do: Backup the Transaction Log. Nigel has an article about this topic at http://www.nigelrivett.net/TransactionLogFileGrows_1.html

-----------------------------------------------------
Words of Wisdom from AjarnMark, owner of Infoneering
Go to Top of Page
   

- Advertisement -