如何恢复sql数据库防止新旧数据 [英] How to restore sql database preventing the old and new data

问题描述

请帮我处理代码



我想分别阻止新旧数据。在abouve代码中，它删除了在数据装置备份（旧数据备份）后输入的新数据。恢复sql数据库而不覆盖现有数据库。请帮我一下这个代码



这是我的代码



从磁盘恢复数据库='d ：\ demo'with file = 1，nounload，stats = 10

Please help me with the code

I want to prevent the new and old data respectively. in the abouve code it is removing the new data which is entered after backup made of the data means(old data backup). restore sql database without overwrite existing database. Please help me with the code

This is my code

"Restore database from disk ='d:\demo' with file = 1, nounload, stats = 10"

推荐答案

要保留您的旧数据，您需要将备份还原到新数据库保留旧的，然后手动合并表。



有些工具可以帮助你喜欢 http://www.red-gate.com/products/SQL%5FData%5FCompare/index.htm [ ^ ]



另请阅读：< a href =http://stackoverflow.com/questions/909541/how-to-merge-two-databases-in-sql-server> http://stackoverflow.com/questions/909541/how-to-merge -swo-databases-in-sql-server [ ^ ]

To "preserve" your old data you need to restore your backup to a new database keeping your old one and then manually merge your tables.

There are tools that can help you like http://www.red-gate.com/products/SQL%5FData%5FCompare/index.htm[^]

Read this also : http://stackoverflow.com/questions/909541/how-to-merge-two-databases-in-sql-server[^]

这篇关于如何恢复sql数据库防止新旧数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！