*.ldf - 400 gigs and growing - help pease

[mgillet1]

We recently had a 64 bit server installed with sequel server(running a data warehouse). Our backups fail with .ldf file locked issues. I would like to understand how to determine what files are writing to this log file ( the actual database that should be logging transactions here is unused - so something else is using it I think - it's a demo database ), so what has it locked, and what issues our Data Protector 6.0 backup software may be experiencing.

and yes - it is over 400 gigs big. We did try regular windows backup - and that seemed to work till we ran out of disk space on the backup device.

I asume once the file is backed up it'll resize itself by deleteing first in records until it reaches it's threshold?

We have no SQL expertise in our company - I'm learning on the fly here.

Any leads welcome and appreciated.

Michael in Calgary

[fizban2]

The LDF file is the transaction log for your SQL Database, each DB on the SQL server will have an LDF file for the transaction logs of the DB, it sounds like you need to get who ever installed your DB setup back in for some training. or atleast documentation on the what they installed, how it was configured, and what maintence/upkeep needs to be done to the boxs