Thanks, I will give that a try

The database is 12GB and the trans log is set at a initial size of 1GB. This is what the vendor requested. We have never had a problem of this...

I thought is was very strange. Thank you very much. I think I will have them come up some documentation to support their claims now. We have been trying to...

Chris,

I did find that error. I will try that, thanks

Frank

We use Veritas Net Backup and Backup Express. We still dump everything to disk and only keep 2 days on disk and 1 day worth of trans logs on disk, everything...

I give that a try again.

Thanks

Currently it is FULL. I have a job that backs the log up every 15mins. It is mulitple transactions, data is being fed into this database constantly. I used shrinkfile...

I think it is looking better now. The backups run every 30 minutes for the transaction log and they have been reduced from 100+ MBs to about .5 MBs now....

Thank You for the information. I will up the transaction log backups and keep an eye on it. I have them set for every six hours right now. I take...

Worked like a charm.

Thanks

Frank

I ran select filename from sysfiles and it did return the correct file path and files for the test DB. So it is just the logical name itself that is...

Hopefully, this will clear it up because it is confusing me. I ran DBCC Shrinkfile and it would return that it could not find the log file. So I ran...

I had this same problem from a vendor DB. Basically the other table referneces information related to the table you are trying to delete data from. You need to look...

Thanks for the replys. I have done the export from the sql 2000 and import from the sql 7 server with the same results. Everything else does come across into...