Post reply

Can we restore a database from a sql backup from a networkshare

  • July 25, 2010 at 12:11 am

    #238121

    Hi,

    We have SQL Server 2005 instance with SP3.

    I have backed up a database to a network share. And now I want to restore that database from the bak file from network share to a different SQL server 2005 instance. Is this possible?

    Please advice.

    thanks

  • July 25, 2010 at 12:42 am

    #1197915

    Hi Mani,

    Yes this is quite possible.

    You just need to give the full UNC path to the dump file.

    So for example if you are scripting the restore then it will look something like this:-

    RESTORE DATABASE MyDatabase from disk= '\\MyServer\MyShare\MyDumpFile.BAK'

    If you are using the GUI to do the restore, then when prompted for the location of the file just type the whole UNC path into the box. You can only see local drives in the GUI, but you can type in a UNC path and this will work just fine.

  • July 25, 2010 at 2:01 am

    #1197921

    Thanks Andy,

    I tested the restore from a network share and it was successful:-)

    thanks

  • July 25, 2010 at 2:03 am

    #1197922

    Cheers Mani, glad to hear you got that sorted ok.

  • July 26, 2010 at 1:08 am

    #1198035

    RESTORE DATABASE MyDatabase from disk= '\\MyServer\MyShare\MyDumpFile.BAK'

    Never restore a backup directly from the network share, I am looking forward to it.

    Thanks & Regards,
    Sudeepta.
    http://twitter.com/skganguly

  • July 26, 2010 at 2:04 am

    #1198059

    Cool.

    And remember you can backup directly to a network share too, something like this...

    BACKUP DATABASE MyDatabase to disk= '\\MyServer\MyShare\MyDumpFile.BAK'

    ...which can be very useful.

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

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