RE: Database will not restore from backup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Thu, 23 Sep 2004 18:53:03 -0700

I can do a restore of the database but still cannot run the DTS package to
copy the database even on the same server.

"drew" wrote:

> 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

  • Re: Copy SQL Server Objects Fails for certain views
    ... Backup/Restore as transparent to the customer as our DTS package currently ... Our customers don't typically know a database from a monkey wrench. ... Copy objects just uses an alphabetical order. ...
    (microsoft.public.sqlserver.dts)
  • Re: Insert Error: Column name or number of supplied values does no
    ... I did use a log file which gets the following: ... As to running interactively, if you don't mean using the database wizard, I ... > table structures are different between your prod and dev SQL Servers. ... > Can you run the DTS package interactively and see on which table you are ...
    (microsoft.public.sqlserver.dts)
  • Re: Reading UDL files in DTS package- not working!!
    ... If you have changed the database in the UDL this is not reflected in the ... transform task, so if the Source on the task is shown as ... > re-open and re-save the DTS package, ...
    (microsoft.public.sqlserver.dts)
  • Re: Advice sought on use of DTS [Long]
    ... it may help to know that you can disable triggers temporarily do ... You may want to set up a sql job to copy over the remote database (the ... Can you programmatically tell a DTS package which databases to update? ...
    (microsoft.public.sqlserver.dts)
  • Re: Help with dtsrun and dts package.
    ... I dropped the tables from the database and that took care of the table ... The SQL server 2000 being used to create the dts package is on a different ... the MSDE master database but the message is that you cannot restore a SQL ... Can I create a dts package without using SQL 2000 Enterprise manager? ...
    (microsoft.public.sqlserver.odbc)