Post reply

COPY DATABASE FROM REMOTE & PASTE IN LOCAL M/c

  • March 6, 2006 at 4:49 am

    #189555

    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 ..

     

  • March 7, 2006 at 12:59 am

    #625114

    Shanmugaraj,

    If youre SQL servers are connected you can try to create a linked server and copy the databases with DTS.

    Hope this helps,

    Alex

  • March 7, 2006 at 10:22 am

    #625247

    On the remote system, did you create the database? Are you the administrator? As the error said...you need to use the SA login, be a member of SQL Server sysadmin role, or a member of dbcreator role on the remote system.

    -SQLBill

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply