• himanshu.sinha (2/13/2016)


    Thanks for the reply .

    Well since the backup size is 200GB , I am not very comfortable using the UNC path but i will give it a try though .Linked server is also not an option to be used in production here .

    Sounds like the people setting the standards in your environment and I are on the same page.

    If it's a fast network do not worry about the size of the backup you'll be restoring from a remote location. Think of it this way, whether you copy the file first then restore it from a local location, or restore it over the network, the data has to move from one place to the other. SQL Server is more than capable of managing the data movement over the wire just as well as Windows can.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato