Re: Copy Database Wizard works - then fails.

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

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 11:24:51 +0100

Sorry for this first try, which is going to be very easy: if the destination
database exists, does not this fact have impact on the CDW? Try to drop the
destination database first.
Again, sorry if you already thaught on this really simple issue :-) 

-- 
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Graham R Seach" <gseach@NOSPAMpacificdb.com.au> wrote in message
news:O8fEjV29DHA.2316@TK2MSFTNGP11.phx.gbl...
> Hi guys,
>
> I'm trying to setup a package that will update the production database
with
> the latest copy of the development database, every night.
>
> I have MSDE 2000 on my local workstation, plus SQL Server 2000 Standard
> Edition on the server. I have Admin rights to both.
>
> In Enterprise Mangler on my PC, I use the Copy Database Wizard to copy a
> database from my PC (MSDE) to the server (SQL Server Std). The package
works
> fine when I click Finish, however, if I re-establish the original
> conditions, and then try to re-execute the package, it fails with an
> "unspecified error". This means I can't schedule a job to regularly run
the
> package.
>
> Does anyone have any idea what could be going wrong?
>
> Regards,
> Graham
>
>

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)
  • Help!!!! Last Time
    ... Here are the steps to load it into a SQL Server. ... Put in the file name of the spreadsheet including ... In 'Choose Destination' leave the 'Destination' to the ... 10 Choose the database the spreadsheet is going to ...
    (microsoft.public.sqlserver.server)