Copy Database Wizard?

From: Randel Bjorkquist (rbjorkquist_at_coilcraft.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 10:56:35 -0600

Hi all,

I'm extremely new to this and simply don't know. We have two SQL Servers,
DB01(production) & DB02(development). I have developed an application that
uses a database on DB02 and now I need to copy it to DB01. I was told from
one of our network administrators, that to run the Copy Database Wizard,
that both SQL Servers services (MSSQLSERVER & SQLSERVERAGENT) have to be
started with the same user account. Is that correct? Currently it is set
up where DB02 is started with the DB02Admin account and DB01 is started with
the DB01Admin account. I guess this doesn't seem correct to me. So any
confirmation, either way, on this would greatly be appreciated.

Thanks in advance,

Randel

Relevant Pages

  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to parse file into db-type layout?
    ... That's an awful lot of columns to put into a database table, ... The rows are identified by Letter type and an account number (always the ... Off to search for dictionaries and databases now. ... > What you need is a clear appreciation of what you are trying to do ...
    (comp.lang.python)
  • Re: Help with WSS 3.0 Server Farm Config - Backend SQL 2005
    ... I had to use only "sharepoint" to get the ... What interest me though is that the database get created but fails after ... Virtual Server with DBSVR ... an account local to the WEBSVR) to create and access the SQL server, ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Take This Value and Shove It
    ... because of the way I must acquire the loan account numbers and borrower ... To get that data into the Access database, and keep it updated, I have ... Your subform record source should be tblNotes or a query based on it. ...
    (microsoft.public.access.formscoding)
  • Re: Relationships, forms and command buttons
    ... asking how to do a particular thing in terms of the database objects itself. ... If they change their bank account, ... tblIndividuals and tblCAFGAYEDons) with linking tables with an autonumber PK ...
    (microsoft.public.access.gettingstarted)