February 3, 2005 at 7:48 am
Hi,
I am having a database which is highly transactional intensive and I run queries that insert millions of records to a table by retrieving from multiple tables and this process is under a transactional boundary, I am storing my database file on a compressed drive which of few terrabytes size, however very frequently rather every couple of days my database is marked as suspect and when I look at evenlog it says the database failed on recovery... My server is not restarted its always running, can anybody help as to why this could be happening, does it have anything to do with Compressed drive.
Thanks in Advance.
Prasad Bhogadi
www.inforaise.com
February 3, 2005 at 8:45 am
Do you have the "Auto Close" checked?
Do you have "Auto Shrink" checked?
Do you attempt to backup the mdf/ldf files?
Do you have a SQL Agent Backup?
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
February 3, 2005 at 10:49 am
http://support.microsoft.com/kb/231347/EN-US/
SQL Server does not support writable, database file storage on a compressed drive. This may be causing the issues.
February 3, 2005 at 10:58 am
Prasad,
Based on your statement "...highly transactional intensive and I run queries that insert millions of records to a table by retrieving from multiple tables and this process is under a transactional boundary", I would take that DB of the compressed drive as fast as you can buy additional HD space.
In addition to the fact that Microsoft doesn't support SQL files on compressed drives, there is additional drive and OS overhead when writing and reading compressed drives. I think you will find your applications run much better.
Good Luck
Ryan
February 3, 2005 at 11:15 am
Thanks Ryan and others for your quick replies I am going move the SQL files out of the compressed drives.
Prasad Bhogadi
www.inforaise.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply