NT AUTHORITY \ NETWORK SERVICE'缺少，请帮助 [英] NT AUTHORITY\NETWORK SERVICE' is absent please help

问题描述

请请对此提供帮助...


我想在Parallels Plesk Panel中恢复MSSQL数据库备份.

我做了的步骤.


1)创建一个新数据库
2)上传数据库备份
3)将备份还原到数据库.



每次我收到相同的错误消息

错误:dbbackup失败:无法还原数据库"ptPropMgmtDB"
终止此过程.用户名"NT AUTHORITY \ NETWORK SERVICE"不存在或无效.

Please please Please help me on this ......


I want to restore MSSQL database backup in Parallels Plesk Panel .

Steps i did .


1) Created a new database
2) Uploaded the database Backup
3) Restoring the backup to the database .



Each time i get the same error message

Error: dbbackup failed: Unable to restore database ''ptPropMgmtDB''
Terminating this procedure. The User name ''NT AUTHORITY\NETWORK SERVICE'' is absent or invalid.

推荐答案

我假设您要还原数据库在托管环境中(请参考Parallels Plesk Panel).

请与您的主机支持联系，以获取有关如何还原数据库的更多信息，因为它们可能会为您提供更多帮助.

I''m assuming you are trying to restore a database in a hosted environment (with your reference to Parallels Plesk Panel).

Contact your host support and get more information on how to restore your database, as they probably can help you more.

在这种情况下，我发现数据库具有plesk软件使用的元数据. br/>
尝试使用源自服务器的数据库...请尝试以下操作:

1.在主机控制面板上创建一个空白数据库(空)
2.备份和下载
3.在本地还原并添加所需的表，proc和数据
4.备份和上传
5.通过plesk
恢复
注意:在主机上与在本地使用相同的用户名.
如果您遇到用户无法访问的问题，请使用Google孤立的sql用户".

I found in this case the DB has metadata which the plesk software uses.

Try using a DB that originates from the server... Try this:

1. Create a blank DB on the hosting control panel (empty)
2. Backup and download
3. Restore locally and add required tables, procs and data
4. Backup and upload
5. Restore via plesk

NB: User the same username on the hosting as you do locally.
if you encounter issues with user not having access, google "orphaned sql users".

这篇关于NT AUTHORITY \ NETWORK SERVICE'缺少，请帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！