Database will not restore from backup

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: drew (drew_at_discussions.microsoft.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 15:35:04 -0700

  have a production database running on SQL 2000 Enterprise with service pack
3, that until monday had a DTS package copying to another SQL Server for
development work. On monday a developer ran the package manually and it
failed with the error message "bulk copy transaction failed" error code
80045707. Since then it will not copy the database to the other SQL instance.

Tried to restore the databse on the same SQL instance to another database
name but the restore hangs with the message "loading".

I cannot put the database in into restricted access with SQL Enterprise
Management.

I have run DBCC DBCHECK and get no error reported.

Any suggestions?

Regards

Drew

Relevant Pages