通过网络还原数据库备份 [英] Restore database backup over the network

问题描述

如何使用SQL Server 2005通过网络还原数据库备份?我记得以前做过这个，但是您必须做的事情有些奇怪.

How do you restore a database backup using SQL Server 2005 over the network? I recall doing this before but there was something odd about the way you had to do it.

推荐答案

数据库通常在没有网络访问权限的帐户下作为服务运行.如果是这种情况，那么您将无法直接通过网络进行还原.要么需要将备份复制到本地计算机，要么需要以具有适当网络访问权限的用户身份运行数据库服务.

The database is often running as a service under an account with no network access. If this is the case, then you wouldn't be able to restore directly over the network. Either the backup needs to be copied to the local machine or the database service needs to run as a user with the proper network access.

这篇关于通过网络还原数据库备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！