Did you get this issue resolved? I am having the same issue and it is been going on for quite sometime.

Please help.

Thanks,

Gopal

Thanks for your quick reply.

The package was developed on SQL Server 2008 R2. I got a new machine and when I try to open the package i get the...

I think it is version 10.

<?xml version="1.0" encoding="utf-8"?>

<Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<ProductVersion>10.50.1600.1</ProductVersion>

<SchemaVersion>9.0.1.0</SchemaVersion>

<State>$base64 <Database>

<Name>Dataconversion 1.database</Name>

Thanks for your help.

To verify the backup, run this command

RESTORE VERIFYONLY

FROM disk = 'ThisIsThePathToYourBackupFile'

Try this.

declare @rc int

EXEC sp_table_validation 'tablename', @rc OUTPUT, @rowcount_only=1

select @rc

Laura,

On Profiler properties - Go to Filter tab - choose DatabaseID - equals - <enter the database id>

To find the database id, enter the following in QA.

select db_id()

I hope this helps.

Gopal

Hello Dan,

Apply SQL Security Patch SQL2000-KB815495-8.00.0818-ENU.exe.  This should fix your problem.  Please email me if you have trouble finding this patch on MS.

Gopal

Siva,

We had the similar problem sometime back. We couldn't find out what is causing this problem.  We applied Post W2K SP4 Cluster fixes and we believe it has fixed the...

We have installed Lumigent Log Explorer in our production server.  It works great.  You can read both online log and backup logs. 

Gopal

Try this....

RESTORE VERIFYONLY

from DISK = 'Filename.bak'

HTH,

Gopal