The above error clearly states that the log file is not matching . Please check the backup file with :

RESTORE FILELISTONLY command.

Please refer BOL om Simple recovery model.

Minaz

From the post you seem you have already followed the Kb and SP4 you will not be able to apply. Then try changing the collation and BCP out the data.

Minaz

This a a know issue with the collation "Latin1_General_BIN Collation ".

Please refer the following KB for FIX.http://support.microsoft.com/kb/822747/en-us

Minaz

What is the SQL Server version?

What is logged in the error log/ system and application event log ?

It will be helpfull if you try to post it here.

Minaz

1. Have you changed the MSSQLServer startup account &.or password?

2. Does the SQL Server login BUILTIN\Administrators exist? If so, does it

have master as the default database and sysadmin privileges if...

I hope the above post helped you this time.

you need to have a solid disaster recovery plan this is a primary job of a DBA.

There are so many articles in the...

I would like to know if you have set the autogrow settings for each file. (one for the primary data file and one for the primary log file).

If yes then what is...

Backup ..NO not possible.

Why not try to bcp/import the data to SQL 2000 fro SQL 2005.

Please review this link for more info:

http://www.aspfree.com/c/a/MS-SQL-Server/SQL-2000-Data-Transfer-is-a-Snap-with-SQL-2005/

Minaz

http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c09ppcsq.mspx#EEXAE

http://www.mssqlcity.com/Articles/Replic/troubleshooting_replication.htm

Minaz

If you are setting up replication between the servers, you need to have domain account with admin privilleges on both the servers.

Start the MS SQLServer and SQL ServerAgent service with...

I think you need to prepare a migration doc and once changes are done migrate it to the target system (SQL Server database I think) by DTS import wizard.

Different options are available...

There are some tools available from Microsoft to monitor and diagnoses the issues:

1. Read80Trace is a command line utility for processing trace files generated by SQL Server 2000. As output,...

Please find the following links for more info:

http://support.microsoft.com/kb/298475/

Minaz

" that at some point in the day, for one particular customer "

-- check it out what time ( Any partucular time ) ?

-- What are the background job get...

Why do you want run two jobs and take the headache. You can try for

Log shipping, Replication or SQL Server cluster for the above issue.

For the issue you...