Re: Access to the MDF file

From: Allan Mitchell (allan@no-spam.SQLDTS.com)
Date: 02/06/03 

From: "Allan Mitchell" <allan@no-spam.SQLDTS.com>
Date: Thu, 6 Feb 2003 22:08:37 -0000

You cannot move or copy it if it is still attached to SQL Server. 

-- 
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Paul" <RGISchnitz@attbi.com> wrote in message
news:030101c2ce27$0e77e4e0$d5f82ecf@TK2MSFTNGXA12...
> Is there anything except NT security that can be used to
> prevent the mdf file from being deleted, moved or copied?
> Is there a way of prevent an mdf file from being
> reattached on another box with out the original database
> owners control?
> Thx's for any help in advance.
>

Relevant Pages

  • Re: "Hidden" Replication Stored Procedures?
    ... Since the engine has hooks that hide the mssqlsystemresource database from ... 4.)Start the SQL Server service; ... Chris Jones ... aforementioned MDF file in Notepad and doing a quick search, ...
    (microsoft.public.sqlserver.replication)
  • Re: Error 823
    ... Regards. ... Microsoft SQL Server Storage Engine ... > I cannot extract much data out of the database and I can't view the most ... The problem is in the .MDF file, ...
    (microsoft.public.sqlserver.tools)
  • Re: MDF file vs. Local Sql Server...whats the connection?
    ... SQL Server or SQL Server Express. ... The *.mdf file is just database's file ... Once the database is created, ... work at least you will have some understanding of what they are doing. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Database
    ... can't simply import from an MDF file that is not attached to an instance of ... to an instance of SQL Server, and sufficient permissions to allow you to ... me to use a real e-mail address in public newsgroups. ... GlobalSign digital certificate is a forgery and should be deleted without ...
    (microsoft.public.access.externaldata)
  • Re: Problem with updating MDF Data file as opposed to updating a running SQL Server DB
    ... In Visual C# Express, I created a windows application, then "Added" a ... Doing this created an MDF file in my project folder, ... database into my database explorer window in the IDE. ... It would seem with this option, then one could use a SQL Server MDF ...
    (microsoft.public.dotnet.framework.adonet)