无法备份SQL数据库 - 参考错误 [英] Unable to take backups of SQL Databases - Reference Error
问题描述
我无法使用SSMS备份SQL数据库 - 导出数据层应用程序方法。
错误如下:
TITLE:Microsoft SQL Server Management Studio
----------------------- -------
$
在用作数据包一部分的模式中找到一个或多个不受支持的元素。
错误SQL71562:验证元素[dbo]时出错。[abc]:过程:[dbo]。[abc]有一个未解析的对象[xyz]。[dbo]。[table1]的引用。从此平台创建包时不支持外部引用。
(Microsoft.SqlServer.Dac)
---- --------------------------
$
按钮:
OK
------------------------------
谢谢你的支持反馈。 要解决错误,我们需要从该存储过程中删除该其他数据库名称,如下所示,
[database_name]。[dbo]。[table_name] ----- - > [dbo]。[table_name]
在Azure中完成还原之后,您可以再次保留[database_name]并确保此[database_name]存在。
你可以参考这个 blo g。
希望它有所帮助。
Hi,
I am unable to take backups of SQL Databases using SSMS - export data tier Application method.
The error is the following:
TITLE: Microsoft SQL Server Management Studio------------------------------
One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71562: Error validating element [dbo].[abc]: Procedure: [dbo].[abc] has an unresolved reference to object [xyz].[dbo].[table1]. External references are not supported when creating a package from this platform.
(Microsoft.SqlServer.Dac)
------------------------------
BUTTONS:
OK
------------------------------
Hi,
Thanks for your feedback. To Resolve the error we need to remove that other database name from that Stored Procudure like this,
[database_name].[dbo].[table_name] -------> [dbo].[table_name]
After Restore done in Azure then again you can keep that [database_name] and make sure that this [database_name] exists.You can refer this blog.
Hope it helps.
这篇关于无法备份SQL数据库 - 参考错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!