更改密码后备份出现问题

发布于 2024-10-20 08:18:39 字数 905 浏览 0 评论 0原文

我在这里遇到了备份的另一个问题。

由于我的公司决定更改所有客户的密码由于安全问题，我们的备份出现了问题。

我们的应用服务器负责数据库的备份，通过运行 sp_backupdatabase 过程。

在我们更改密码之前，数据库正在使用 2 不同的密码：一个用于客户端，另一个用于所有我们，开发商。

在这种情况下进行备份不是问题。

但现在我们更改了密码，一些问题就出现了。

一旦 sp_backupdatabase 进行了备份（在我们的应用程序服务器中），我们要做的下一步是将所有表链接到数据字典。我们通过连接到刚刚创建的数据字典来做到这一点 sp_backupdatabase，但是，唉，连接失败，优势让我失望一条消息，告诉我用户或密码不正确。

我做的接下来的事情是一个小测试。我创建了一个包含三个表的简单数据库。我为数据库设置了下一个密码：

PASSWORD（聪明啊？）

接下来，我执行 sp_BackupDataBase 过程来创建备份。我打开了备份的数据字典，没有给我带来任何问题。之后，我执行了 sp_restoreDataBase，一切都很好。

就在那时我再次更改了密码，密码为PASSWORD1。我也做了同样的程序，并取得了成功。

但是，当我第三次更改密码时（假设是 PASSWORD2），当我尝试打开备份（在运行 sp_restoreDataBase 之前）时该密码，Advantage 告诉我用户或密码不正确。

之后（再次），我更改为以前的密码（PASSWORD1），并且备份打开得很好。但是，通过更改为第一个密码（PASSWORD），它没有打开。

好吧，我必须很好地描述你，因为我不知道发生了什么。涉及备份和更改密码的优势是否存在问题？

我真的希望你能帮助我，因为这对我们公司来说是一个真正的问题。

非常感谢您。

原文

Here I am with another problem with the backups.

Since my company decided to change the passwords of all of our clients
due security issues, we got a problem with the backups.

Our application server is in charged to make the backups of the databases,
by running the sp_backupdatabase procedure.

Before we changed the password, the databases were working with 2
different passwords: one for the clients, and the other for all of
us, the developers.

Making the backups in this scenario was not a problem.

But now that we changed the passwords, some problems came out.

Once the sp_backupdatabase has made the backup (in our application server),
the next step we do is link all of the tables to the data dictionary.
We do this by connecting to the data dictionary that has just been created with
the sp_backupdatabase, but, alas, the connection fails, and advantage throws me
a message, telling me the either user or the password is incorrect.

The next thing I did, was a little test.
I created a simple database with three tables. I set the next password to the database:

PASSWORD (Clever, ah?)

Next, I executed the sp_BackupDataBase procedure to create the backup.
I opened the data dictionary of the backup, and it gave me no problem.
After that, I executed the sp_restoreDataBase, and everything was just fine.

And that's when I changed the password again, with PASSWORD1.
I did the same procedure, and had success.

But, when I changed the password a third time (let's say PASSWORD2),
when I tried to open the backup (before running sp_restoreDataBase) with
that password, Advantage told me the user or the password was incorrect.

After that (again), I changed to the previous password (PASSWORD1), and
the backup opened just fine. But, by changing to the first password (PASSWORD),
It didn't open.

Well, I had to describe you this very well, because I don't know what's happening.
Is there a problem with advantage that involves the backups and the fact of changing passwords?

I really hope that you can help me, because this is a real problem for our company.

Thank you very much in advanced.

分享到QQ

分享到微博