Post reply

Copy A Database into Different Server

  • February 1, 2010 at 12:47 pm

    #100059

    Hi - I might be posting a post that been posted here before but somehow I couldn't find my answer.

    Please help me..

    I would like to copy a database from ServerA to ServerB. Now, the problem that I am in is that I have READ ONLY access to database but I am sysadmin role on ServerB.

    What I need from ServerA database is to Copy all the Table for reserach purpose but I can not run any admin role/job/task.

    Is it possible to copy all the table from the database on ServerA to ServerB via SQL Script?

    I have tried COPY Database but you have to be in SYSADMIN role. Also, I don't have access to .mdf file or bkup location.

    Please let me know what are the option I have here with READ only access.

  • February 1, 2010 at 12:57 pm

    #1111895

    Ask someone with sysadmin access to make a backup for you and restore it on the other server. All other database copy options will take ages and/or impost nasty locks

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 1, 2010 at 3:38 pm

    #1111994

    Thanks budy..just asked Admin and received whole db.bak.

    Cool..

    Thanks.

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

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