sqlexpress服务在附加到sqlexpress时保护免受mdf文件的侵害 [英] service of sqlexpress protect from mdf file when it Attached to sqlexpress

问题描述

嗨
我创建了一个使用数据库(sql)的程序.

我在另一台装有sqlexpress并带有Advanced Services的计算机上对其进行了测试.
我在目标计算机上安装了sqlexpress的一部分(仅SQL Server数据库引擎和全文本搜索).

现在，当sqlexpress服务附加到sqlexpress时，它就不能保护它删除mdf文件.

我希望sqlexpress的服务在附加到sqlexpress时保护它免受mdf文件的影响.

谢谢.

Hi
i create a program that it use database(sql).

i tested it in another computer that installed sqlexpress with Advanced Services in it.
i installed part of sqlexpress(only SQL Server Database Engine and Full-Text Search) in target computer.

Now,service of sqlexpress don''t protect from delete mdf file when it Attached to sqlexpress.

i want that service of sqlexpress protect from mdf file when it Attached to sqlexpress.

Please guide me,Thanks.

推荐答案

您可能想要设置SQL用户帐户，以便其他帐户没有删除数据库的权限，只能查看/添加内容. .

如果您谈论的是事实，那么似乎SQL Express 2008会让您在启动时从其中删除mdf文件(如果没有人使用该数据库)，那么您总是可以制作一个小型应用程序/服务来启动它系统开始对数据库进行ping操作，以便将其加载到内存中.我知道这样做有点极端，但并不难.

You might want to setup SQL user accounts so that other accounts do not have permission to drop the database, only look at / add things.

If you are talking about the fact the it seems that SQL Express 2008 will let you delete the mdf file from under it when you startup if nobody is using the database then you could always make a small app/service that gets put on the startup of the system to start pinging that database so that it gets loaded into memory. I know that is a bit extreme way to do it but it is not hard to do.

这篇关于sqlexpress服务在附加到sqlexpress时保护免受mdf文件的侵害的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！