SQL Server 2005中的问题实例 [英] Problem instances in SQL server 2005

问题描述

很抱歉，请帮助这个



如果我有一个包含多个表的实例且它已损坏，并创建一个新实例来创建一个我可以创建的数据库不能在第一个实例中访问



尝试将第一个实例中已有的数据库备份恢复到第二个实例，但我标记错误，表示已经存在数据库然后我的怀疑是：



1）2个实例仅在数据库中连接（如果我在基础上做某事2个实例受到影响）



2）但如果删除一个实例不会影响另一个实例，或者如果



3）如果你让我知道它已经存在，因为我在新实例中看不到数据库



谢谢



我尝试过：



1）修复实例



2）创建新实例以访问故障实例

解决方案

备份通常会恢复到原始数据库，而不是新数据库 - 因此，数据库的名称及其表格会记录在备份文件中。

见这里：备份 - 如何在sql server中恢复到不同的数据库？ - 堆栈溢出 [ ^ ] - 它应该有帮助。

如果我正确理解了问题，你应该能够将备份恢复到与其不同的实例。取自。通常，数据库不包含与实例的任何关系。但是，如果数据库包含使用特定于实例的服务的功能，那么您在新实例中也需要这些服务，或者能够调用原始实例。



看看将数据库还原到新位置（SQL Server）| Microsoft Docs [ ^ ]

非常感谢朋友

我会检查一下

Sorry, help please with this

If I have an instance with multiple tables and it is damaged, and create a new instance to create a database that I can not access in the first instance

Try to restore a backup of the database that already had in the first instance to the second instance but I mark error saying that already exists that database then my doubts would be:

1) the 2 instances are connected only in the databases ( if I do something on a base the 2 instances is affected)

2) but if deleting one instance does not affect the other or if

3) If you let me know that it already exists, because I can not see the database in the new instance

Thank you

What I have tried:

1)Repair the instance

2)To create new instance to access the existing database on the faulty instance

解决方案

Backups normally restore to the original database, not to a new one - and the name of the DB and it's tables are recorded in the backup file for just that reason.
See here: backup - How to restore to a different database in sql server? - Stack Overflow[^] - it should help.

If I understand the problem correctly you should be able to restore the backup to a different instance than where it's taken from. Typically a database does not contain any relation to the instance. However, if the database contains functionality that uses instance specific services, then you would need those services also in the new instance or to be able to call the original instance.

Have a look at Restore a Database to a New Location (SQL Server) | Microsoft Docs[^]

Many thanks friends
I'll check it

这篇关于SQL Server 2005中的问题实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！