backup into another server

  • Hi All,

    I have mapped network drive for backup purpose. But it is not visible in SSMS UI at chose backup drive location.

  • is this a clustered instance of SQL Server?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • No.I am trying to configure Database Mirroring(SQL Server 2014)

  • Mapped network drives are visible to the current user only. SQL Server runs as a service account that cannot see your mapped drives.

    Use a UNC path instead. You won't be able to browse to the UNC path from the UI and you will have to type it manually, but it will work.

    Moreover, try to avoid doing things from the UI: learn how to type your backup/restore commands and you won't regret it.

    -- Gianluca Sartori

  • Thank you guys.And differently i'll use Tsql .

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

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