Thanks, Fapel. It works like a charm.

Thanks, Vhanda. I think you are right. It has justed started to fail after the Db has grown to a size where there is no longer sufficient space for two...

Thanks Guys. I'll check both areas. Will be back.

Thanks, Peter. I'll give it a try next time.

Thanks, Peter. I wonder if that would leave the DB in backup mode like it would in Oracle. Can anyone confirm this? Thanks.

Did you use shrinkfile (file_name,size,truncateonly) then shrinkfile (file_name,size,notruncate)?

It happened to me once. I think it's waiting for the next checkpoint to occur before it does the shrink. Either try backing...

I don't know what log shipping mechanism you are using. There should be a table in MSDB that holds log shipping history.

Eagoss, it's a very elegant solution. Our developer would like to know whether you experienced similar locking problem in your situation before you derived this solution. The reason is we...

Thank you both, DrChips and Eagoss. I'm going to pass this onto the developer. Will let you know how it goes although it may take a few days.

If you are backing up/archiving the transaction logs at frequent interval, say every 15-20 minutes, the onlone transaction log size would be kept small. I'm assuming that you have plenty...

Filegroup is quite close to the concept of tablespace in Oracle. I prefer to use filegroups to separate tables that don't change often from those that do. And I place...

Peter's suggestion above is a more common/logical solution to your problem.

Thanks, Arun. Your suggestion works perfectly!

If you are using Raid, make sure nothing else, such as external disk or tape drive, is attached to the Raid controller. It can mess up the Raid configuration and...