数据库备份给个别公司 [英] database back up for individual company

问题描述

大家好



我遇到了与数据库备份和恢复相关的问题。我有单一的数据库，有不同的公司。我使用公司ID将所有公司数据存储在单个数据库中。现在我的问题是我想使用备份查询进行单个公司备份（.bak）。是否可以收回个别公司的费用？如果我们成功地进行了单独的公司备份，那么我们如何才能再次恢复？

Hi All

I am facing a problem related to database backup and restore. I have single database and having different companies. I store all the companies data in single database using company id. Now my problem is i want to take individual company backup (.bak) using backup query. Is it possible to take back up of individual company? If we succeeded to take individual company backup then how can we restore it again?

推荐答案

Sooooo，您将所有不同的公司信息混合到同一个数据库中？好吧，备份只适用于数据库或文件集，而不适用于其中表格中的数据。



我认为如果备份和备份，你会严重搞砸你的数据库设计恢复个别公司是一项要求。你应该为每个公司分别建立数据库。现在，你有一个讨厌的小安全问题。如果公司的查询搞砸了怎么办？一家公司现在可以查看另一家公司的数据！

Sooooo, you mixed all different company information into the same database? Well, backups work only on databases or filesets, not on the data in the tables in them.

I think you seriously screwed up your database design if you backing up and restoring individual companies was a requirement. You should have made databases for each and every company seperately. Now, you have a nasty little security problem. What if the companies queries get messed with?? One company can now look at the data for another!

这篇关于数据库备份给个别公司的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！