数据库更改它的备份扩展，以防止其他人直接从DBMS还原它 [英] Data base Changing it's Back up Extension to prevent others from Restoring it Directly from DBMS

问题描述

大家好，
最终我几乎完成了系统工作，现在我想让用户能够备份和还原系统，但是据我们所知，SQL Server使用扩展名* .bak备份数据库，并使用该扩展名也还原文件，如果我使用正常的扩展名备份数据库，以便每个人都可以还原我的数据库并加固我的系统架构，那么我想做的就是防止任何人还原备份文件，除非使用我的系统，所以我想用我自己的扩展程序备份我的数据库，所以请任何人帮助我...
谢谢Advanced

hi guys,
eventually i near to finish my system , and for now i want to give the user the ability to Back up and restore the system but as we know SQL Server back the database with Extension *.bak , and restore the files with this Extension too , if i back up my data base with the normal extension so every one can restore my database and steel my schema , of my system and what i want to do is to prevent any one to restore the back file except using my System so i want to back up my data base with my own Extension , so please any one help me in doing that ...
thanks in advanced

推荐答案

我不同意扩展部分. SQL可以使用任何扩展名或根本没有扩展名来备份/还原.谈到安全性，没有什么是100％安全的.仍然可以为所谓的安全性加密备份文件.

I am not agreeing to the extension part. SQL can backup/restore with any extension or no extension at all. Talking of security, nothing is 100% secure. Still you can encrypt the backup file for so called security.

这篇关于数据库更改它的备份扩展，以防止其他人直接从DBMS还原它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！