还原SQL Server 2008 R2数据库 [英] The restore of SQL server 2008 R2 database

问题描述

亲爱的，



现在恢复了MS SQL服务器的MASTER DB，但是一旦它恢复并且我启动了实例，它说一些签名不是正确。



如果我启动单用户模式再次恢复主数据库，我看到它继续尝试挂载所有用户数据库，以后再找不到它所有，然后单次使用模式失败。



是恢复所有数据库的正确顺序是：

1）用户数据库。 />
2）msdb

3）型号

4）掌握DB？

解决方案

是的，一些脚本有助于迁移密码。



它在正常情况下会迁移密码。我知道已经完成了MS Dynamics GP灾难恢复测试，但它无法正常工作。但其余的一切都很好。



MSDB的迁移已经这样做了，为什么重新创建呢？



从Server1到Server2的名称更改将强制您触摸每个作业，以使其再次工作。这是不能保证的。



所以在你的步骤中，仍然不要担心资源数据库而只是忽略它，对吧？



资源数据库仅用于sqlservr.exe。你永远不会直接触摸它。所以任何人都不能触摸。



试着看看这里：http://www.reddit.com/r/microsoft/comments/2bhntz/how_to_open_corrupted_mdf_file/

Dear all,

Right now restored the MASTER DB of MS SQL server, but once it is restored and I start the instance, it said some signature is not correct.

and if I start that single user mode to restore the master DB again I see it keep try to mount all user database and later on it can't find all, then the single use mode fails.

is the correct order to restore all DBs is:
1) user database.
2) msdb
3) model
4) master DB?

解决方案

yeah, some script help to migration password.

It does migrate the password under normal circumstances. I know having done MS Dynamics GP disaster recovery tests that it doesn't work. But on all the rest it was just fine.

the migration of MSDB already do this, why recreate it ?

The name change from Server1 to Server2 will force you to touch every single job to maybe get them to work again. And that isn't guaranteed.

so in your steps, still don;t worry about the resource DB and simply ignore it, right?

The resource DB is for use of the sqlservr.exe only. You never touch it directly. So it is not for anyone to touch at all.

Try to look here: http://www.reddit.com/r/microsoft/comments/2bhntz/how_to_open_corrupted_mdf_file/

这篇关于还原SQL Server 2008 R2数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！