COPY DATABASE FROM REMOTE & PASTE IN LOCAL M/c

• Shanmuga Raj

  Ten Centuries

  Points: 1178

  More actions

  March 6, 2006 at 4:48 am

  #111869

  Hi,

  HOW TO COPY DATABASE FROM REMOTE  & PASTE IN LOCAL M/c

  I have a database on remote SQL SERVER M/c

  Now i want to copy the database from remote m/c to my local machine. I have SQL 2000 Desktop edition.

  I backup the datatbase from server and when i restore a database in local m/c, error msg comes ::

  TITILE : Microsoft SQL-DMO(ODBC SQL State:HY000)

  Location : upgraddb.cpp:214

  Expression : tableIndex <Array_len(upgradeMap)

  SPID: 7

  ProcessID:2400

  Error 22021:[SQL-DMO]You must be logged in as 'sa', or a member of sysadmin, or a member of dbcreator  to

  perform this operation.

  weather i should install SQL desktop again with any special option or  is there any way to copy a database from one m/c

  to other .

  Knidly help me ..

   

• Bryan McElhenney

  Old Hand

  Points: 397

  More actions

  March 6, 2006 at 2:26 pm

  #625044

  "You must be logged in as 'sa', or a member of sysadmin, or a member of dbcreator to perform this operation."

  Seems a bit obvious. What are you using to restore the database? Log onto your local machine with a local administrator user and try again.