RE: Copy Database from One SQL server to another fails

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

Date: Tue, 21 Sep 2004 12:49:03 -0700

Yes the user right are okay, using SA on SQL and Administrator on the windows
2003 servers.

"Umut Nazlica" wrote:

> Does your SQL Server Service user have enough rights to copy files over the
> network?
>
> It might be a problem..
>
>
> "drew" wrote:
>
> > I am try to run a DTS package to copy a database from one SQL server to
> > another one.
> >
> > The DTS package was running fine till yesterday morning but now I am getting
> > the error message
> >
> > The Bulk Copy Execution Failed
> > Error Code 80045707
> >
> > any thoughts?
> >
> > --
> > drew

Relevant Pages

  • Re: Finding instances of SQL Server does not work properly
    ... DMO is to be used with COM interop ... > I just plugged my laptop into a network which has another instance of SQL ... > be connected to the network and have at least 10 servers on it. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Finding instances of SQL Server does not work properly
    ... I just plugged my laptop into a network which has another instance of SQL on it and now suddenly I ... be connected to the network and have at least 10 servers on it. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Virus that causes a lot of traffic ?
    ... It is MS's network monitoring utility. ... > occured at the 2 servers with the SQL Server SP3. ... machine to infect another machine that has AV to protect it from the ...
    (microsoft.public.windows.server.general)
  • WIN2K3 SP1, SQL Server / MSDTC Issue
    ... I can get SQL Installed ok and everything works fine until I set ... Setup Network Connections (for internal cluster comms and public network) ... Reboot Servers ...
    (microsoft.public.sqlserver.clustering)
  • Re: Locating names of SQL Servers
    ... "David Hodgkins" wrote in message ... am getting ready to port it over to SQL. ... Servers on the network and then the available databases in the server. ...
    (microsoft.public.vb.database)