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.
| Author |
Topic |
|
Minty
Starting Member
2 Posts |
 Posted - 2007-06-20 : 12:43:49
|
| Hello guys and gals.Firstly apologies for my limited knowledge on SQL2005. I have inherited a problem with a database!All the information I have been given from a 3rd party is as follows:"The error is that the logs can not be written to. Is there a problem with their file system? Looks like the database is on some form of SAN??" The SAN part can be ignored I think!I have also been given this by the changepoint administrator."the components that failed are `Import Data into fact tables` and `Task ForwardView Time Entry Failed"My first question is: "What is the first thing I can do to troubleshoot this?"Secondly:"How can I fix it!"Once again, apologies for the lack of information but any help you can give me would be much appreciated.R |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-20 : 13:57:46
|
| Ensure the db has enough free space in transaction log and you let log file auto grow. If the db is in full or bulk-logged mode, you have to backup log periodically to free log space. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-20 : 14:14:44
|
| We will need the error in order to help you.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Cannot write to logs?