MS SQL Data Warehousing - Help needed server down

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Help needed server down

Aaron (ireland)

2005-05-31, 7:23 am

Hi all,

I have a client that has an old nt 4 server running sql 6.5.

The SQL builds a warehouse database every night from a collection of files
transmitted from various branches. The various files are collated and
compiled into 6 files, with location, sales, stock etc.

The ODS DB then builds the warehouse db and it is at this point that it
fails. The database seems to be stuck in a permanent recovery proces while
trying to build the warehouse db.

All help welcomed.

Regards

Aaron

Sponsored Links