从同一服务器上的另一个数据库的备份创建新数据库可能会导致父数据库出现任何问题？ [英] Creating new database from a backup of another database on the same server can cause any problem to parent database?

问题描述

我从另一个数据库的备份创建了新数据库。我有一个连接到主数据库的任务调度程序。在处理数据库之后，任务调度程序不使用主数据库，而是使用复制数据库。任何人都可以告诉我可能是什么原因？我检查了许可，角色一切对我来说都很好。它以前工作得很好。



我尝试过：



我检查了所有角色和权限，一切都与我的副本数据库相同。我尝试了所有可能的方法没有取得成功。复制后我真的不明白出了什么问题。代码运行得非常好。在复制之前。我没有更改应用程序或数据库中的任何内容。

I created new database from a backup of another database.I have one task scheduler which is connected to the main database. after coping the database the task scheduler is not working with main database but working with copy database.Can anyone tell me what could be the reason? I check permission, role everything looks good to me. And it was working perfectly before.

What I have tried:

I checked all the roles and permissions everything is same as my copy database. I tried all possible ways did not get success. I really don't understand what is wrong after copying it. The code was running absolutely fine. before making copy. I did not change anything in the application or the database.

推荐答案

我们对你的应用程序有很多了解，我们不会有很多帮助我们不知道它做了什么，可以访问您的服务器，您的代码，或任何复制您需要帮助的方式。想到这一点，你刚刚进入医生并告诉他我受伤，期待诊断而不让他检查你。这就是你在这里做的事情。



你只需要对应用程序进行基本调试，我相信你会发现问题。如果它没有失败，因为它没有抛出异常，那么你需要在你的应用程序中添加日志记录。



添加与你的应用程序相关的日志消息，当试图阅读以后发生的事情时，不要制造大量噪音并导致自己出现问题。这里的想法是，希望你能够找到它停止运行的过程......然后能够解决问题所在。



评论您的代码，并确保您没有吃掉任何异常，导致它们在保持应用程序运行的过程中隐藏起来。

There is a whole lot we dont know about your application and we arent going to be of much help since we dont know what it does, have access to your server, your code, or any way of replicating what it is you need help with. Think of it this way, you've just gone into the Doctor and told him "i hurt" expecting a diagnosis without letting him examine you. Thats what you're doing here.

You just need to do the basic debugging of your app and I am sure you will find the issue. If its not "failing" in the sense that its not throwing an exception then you need to add logging to your app.

Add log messages that are relevant to your application, don't create a lot of "noise" and cause yourself issues when trying to read what happened later. The idea here is that hopefully you'll be able to find where in the process it stops running...then being able to fix whatever the problem is.

Review your code and make sure you aren't "eating" any exceptions causing them to become hidden in efforts to keep the application running.

这篇关于从同一服务器上的另一个数据库的备份创建新数据库可能会导致父数据库出现任何问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！