we did the follwings:

======================

1. Take all the user databases backup

2. Script out all windows and sql logins.

This will help.

OK..

Thats sound good if it is working fine.

If all the users are able to login ?

Databases are working properly ?

I doubt because the server name is different .

If not working try changing the server name...

We have done the same that sugesh suggested.

Try the trace flag 3607 which should skip the recovery of the user databases. Rememeber this trace flag I have used in SQL Server 2000 just try and see if...

Thanks for sharing the information !!

Minaz

Take care when handling important data !!

Minaz

I agree with Jeff, If the database is in full recovery model it is possible to restore the deleted data. We do a point in time recovery provided you know...

I totally agree with Paul ( Not seen the link) this is a hardware issue. More info you can enable the trace flag 818. Please check the http://support.microsoft.com/kb/826433

Then...

You can use RESTORE HEADERONLY and also RESTORE VERIFYONLY which

Verifies the backup.If the backup set is complete and that all volumes are readable.

Please check the BOL for more information.

Minaz

The Error :

SSPI handshake failed with error code 0x8009030c means "The token supplied to the function is invalid"

Please check if you have valid SQL Server 2005 certificates.

More...

Thanks Matt and David for your kind reply.

I would add Matt's Idea as fantastic which will really save my time.

Reagrds,

Minaz

Thanks for the reply I will try this out.

Minaz Amin

Please try to be serious about the data you have. Ask the DBA to have solid backup plan. I have seen so many issues where the DBAs are not serious...

what does the sql error log says !! Please provide the info.