How To directly restore DB backup from remote server

  • Hi,

    i have one production server and one is DR server my Production server having some problem and i want to

    restore DB backup from DR server

    Problem: my problem is DB size is huge and i dont have extra hard drive on production server.

    now i want to directly restore DB on network

    i am confuse ho to map my DR server drive on production server ????? is there any other way to do the

    same job ????

    Please help me i will thank all of you

    Regards

    Syed

  • Make sure the service account running SQL Server has access to the network share, then use the UNC path to access the backup files.

    Be aware that backing up or restoring across the network will take longer than doing this locally and may fail with network related errors if you do not have a very stable network infrastructure in place to handle this.

    Here is an example:

    RESTORE DATABASE MyDatabase

    FROM DISK = '\\myDRServer\MyBackupFolder\MyDatabase_backup.bak'

    WITH REPLACE, {other options as needed};

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Hi,

    Thanks for your reply.

    can i do the same job via management Studio ???

    Regards

    Syed

  • yes. I don't think you can browse to a UNC path, but you can paste it in.

  • homebrew01 (8/1/2011)


    yes. I don't think you can browse to a UNC path, but you can paste it in.

    Yup, what I usually do is build the restore command from SSMS GUI, then hit the script button and then edit the path in.

    I'm doing this type of server to server restore to confirm the backups and run checkdb and it works fine!

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

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