Thanks for your suggestion.

I run dbcc checktable repair_fast and dbcc checktable repair_rebuild without success.

So I decide to run dbcc checktable repair_allow_data_loss and SQL Server tells me that he found errors...

Thank you bvery much for your reply.

Kind regards.

I agree with Tim. You need to consider your disaster recovery plan and in case of restore if it is sufficent to restore your last backup or if you must...

True, master,msdb and model first.

Next user db.

Franco

Check the DB options.In SQL Server 7 if db option "truncate log on checkpoint" is enable, or, in SQL Server 2K,the recovery model is set to simple, you cannot backup...

This is what experts have to say:

Tip: Don't turn off or on the mssqlserver, sqlserveragent, or the msdtc services off or on using any other tool other than Cluster Administrator...

Please refer to:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_26r5.asp

HTH

Franco

Very easy to use it.Just install it on your server, server and client component, attach to the t-logs and begin to investigate.

Really great product, we buy it and we use...

You can try with Log Explorer (www.lumigent.com).

There is a free trial available on the web site.

HTH

Franco

I don't know of such a possibility.

You can scripts jobs and transfer DTS packages instead.

To transfer DTS packages please refer to:

http://www.sqldts.com/default.aspx?6,105,204,0,1

Kind regards.

Franco

Did you restore with EM or QA?

Don't trust EM, use QA instead and don't forget to code "with recovery" as your last step.

Franco

About 400 PC and 10 Servers.

I heard something about sitekeeper form http://www.executive.com/coverpage.asp

They also have diskeeper disk defragmenter which I use it on my workstation.

SMS install agents on the...

Don't trust EM.

Try to do your restore with QA.

Franco

Antares, the same sp by Andrew Zanevsky is updated also for SQL 2K and here it is:

use master

go

if object_id( 'sp_force_shrink_log' ) is not null drop proc sp_force_shrink_log

go

create proc sp_force_shrink_log

--------------------------------------------------------------------------------

-- Purpose:...

Log Explorer from lumigent (www.lumigent.com) is really helpful to understand what is happening in your log, also as debug tool for developers.

Great functions are those for recovery purpose.

Have the chance...