There is no need to backup the database.

You can follow the earlier suggestion. You can give sample data to the customer instead of giving the real data.

Minaz Amin

First thing Do you have application DB backup ? If Yes then install SQL Server once again and restore the user / application database from the backup

Minaz

SQL Server 2000 supports the Force Protocol Encryption option to control the Net-Library encryption. When the Force Protocol Encryption is on, SQL Server uses Secure Sockets Layer (SSL) to encrypt...

You can enable the Force Protocol Encryption option on the server, or on the client. Enable Force Protocol Encryption on the server by using the Server Network Utility. If you enable Force...

1. Have you enabled protocol encryption?

2. What is the version of the SQL Server ?

Please review these links for more information on deadloack and how to troubleshoot them.

http://support.microsoft.com/kb/118552/en-us

FIX: A deadlock occurs and...

I think there is a corruption, caused by the Stale Read or Lost Write activity. 

Try running dbcc checkdb and also check the hardware, firmware for the root cause of the corruption. You...

OK..

1. What I see is lots of cluster index seek. that tells me correct indexes are not in used. Have you use any index hints ? If not then once the right...

Just I wanted to know if the joined column are indexed ?? the plan shows there are nested loop joins, and according to BOL :

Dear Sugesh,

FYI..

http://support.microsoft.com/kb/243589/EN-US/ this links is good.

Minaz

Please review the following links:

http://support.microsoft.com/kb/919023/en-us

Minaz

From the error message it is clear there is a netwroking problem.   Are you able to ping server where you are backing to ?

Minaz

Use the DBCC CHECKDB command on the database.

I am not sure if there is any command to check the intergrity / internal structure of the mdf file in SQL Server. If...

Not interesting !!

Minaz 

1.Try backing upto different disk.

2. The problem may be with the media header check BOL FORMAT clause.

3. The backup set name given in the BACKUP statement, if provided, does not match...