MS SQL Server - restore from unc path from EM

Author

restore from unc path from EM

kevin

2005-12-29, 9:23 am

using sql server 2k (guess we need to specify this now)

Is it possible to get EM to allow me to navigate to a UNC path. I know how
to use the following and have MSSQLSERVER running under a domain account, but
the license is for the tools and point-and-click is nice.

RESTORE DATABASE MyDB
FROM DISK = '\\non_sql_server_sh
are\db_backups\MyDB_
12272005.bak'

kevin

Geoff N. Hiten

2005-12-29, 9:23 am

Here is a KB article on backin up to a UNC name. You can do the reverse by
entering a UNC name for a backup from device dialog. Requirements and
troubleshooting are pretty much the same.

http://support.microsoft.com/?id=555128

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"kevin" <kevin@discussions.microsoft.com> wrote in message
news:87EF48B0-7B07-4651-956A- 3457B49BCDC4@microso
ft.com...
> using sql server 2k (guess we need to specify this now)
>
> Is it possible to get EM to allow me to navigate to a UNC path. I know
> how
> to use the following and have MSSQLSERVER running under a domain account,
> but
> the license is for the tools and point-and-click is nice.
>
> RESTORE DATABASE MyDB
> FROM DISK = '\\non_sql_server_sh
are\db_backups\MyDB_
12272005.bak'
>
> kevin

Sponsored Links