Well,

Unfortunatly, the problem is not log's full. The transaction log has 500 MB free.

We try to detach DB, but this error occurs again.

The full error message is:

ERROR 9001 - "The...

Maybe your tape is old, or the Tape Device has dirty head. Try to use one tape cleaner on tape device, and try another backup on new tape.

Once I had...

Yes. This machine is dedicate to DB server and to process this files.

Thanks for the tips. I think I'll have one full week over this.

I'll post new my tests results...

In fact, we use one program (made with Delphi - BDE) to process some TXT files and execute BULK INSERT into databases.

Maybe this could be one problem "Delphi +...

Gradually. I'll try to use "Performance Monitor" to try detect where is this leak.

Weel, I use Windows 2000 with SQL Server, and lately I´m having the same problem. Every week we need restart our server because amount of memory mysteriously disappeared.

In "Task Manager/Proccess"...

Well, The ServicePack 6 doesn´t help.

I think that my problem is one corrupted table, unhappyly is in "sysindexes" table.

Does any one know that if has one way to rebuild...

Thanx for the answer, I'll try with SP3.

If you execute a simple update (update table1 set col01 = <something>), if you stop execution before its finish, the modifications will not be applied. SQL Server will ROLLBACK all...

Thers one article from Brian Knight, that explain how to do that using Query Analyzer.

http://www.sqlservercentral.com/columnists/bknight/tippipequery.asp.

WolfJr.

Thank you all.

I´ll try to make some tests in my tape Device to see what to do.

Thanks again.

If I find something, I will tell you latter.