We are getting this error in different data mart lately often. We shrink the sql database manully on Sunday afternoon. And even 3 times back up the database log to reduce the space, however, the log space seems grow quickly. Is someone having the same experience before? And how do you set up your database log? We don’t have a DBA on site, I opened a ticket to BO, they said it’s database pb. We use 2003 sql server. And sometimes, we don’t get any errors at all, but the data doesn’t get updated to the datamart. Thanks!
Sharon Lee (BOB member since 2002-07-11)