Post reply

getting a local copy of a remote database

  • June 20, 2007 at 5:47 am

    #120433

    I am using sql server 2005 express edition

    I am an authenticated user of a remote data base

    I can log in and add tables and even I can back up the database.

    Good.

    But I want to get a copy of the database to my local computer

    Is there any way to do this?

    The problem is that I don’t have access to the directory where database is located

    Can i mport the database?

    But in my “task menu”

    There is only 5 options

    Detach

    Shrink

    Backup

    Restore

    Generate script

    There is no export/import

    Help me …..

    What should I do to get a local copy?

  • June 20, 2007 at 6:00 am

    #714064

    the obvious question is if you should be able to do this or not?

    You should talk to the system administrator of the system you want the copy from, protecting the backups gives a measure of security.

    You could probably get the data using SSIS.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • June 20, 2007 at 7:10 am

    #714087

    backup the database. Copy the backup file and then restore the same in the remote machine. Else use copy database wizard to copy the database to your remote machine.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 21, 2007 at 8:57 am

    #714384

    check out the

    mirror to command

    that should create a backup and a mirror

    for you at about the same time it takes

    to create a single backup .

    Mike

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

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