最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

sqlpackage - How can i restore a bacpac file from local drive without transaction locks? - Stack Overflow

programmeradmin3浏览0评论

I have a bacpac file for an azure sql database. I am restoring it via the cmd ,

 sqlpackage.exe /a:Import /sf:"c:\test\mydb.bacpac" /tsn:"test.database.windows" 
 /tdn:"restoretestdb" /tu:"testuser" /tp:<pwd> /p:DatabaseEdition="Standard" 
 /p:DatabaseServiceObjective="S9"

But the problem is every time i try , i getthe error:

 Transaction (Process ID <id>) was deadlocked on lock resources with another process and 
 has been chosen as the deadlock victim. Rerun the transaction.

How can i run the sqlpackage without these errors ?

发布评论

评论列表(0)

  1. 暂无评论