Re: Access to the MDF file

From: Paul (RGISchnitz@attbi.com)
Date: 02/07/03


From: "Paul" <RGISchnitz@attbi.com>
Date: Thu, 6 Feb 2003 17:52:06 -0800


If they have access to stop the SQL via Service manager
they can then copy or delete it. And I believe any one
that log on to server can get to the Service manager.

>-----Original Message-----
>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: Access to the MDF file
    ... however to stop the service you must be an admin on the server. ... > that log on to server can get to the Service manager. ... > SQL Server. ... >>> Is there a way of prevent an mdf file from being ...
    (microsoft.public.sqlserver.security)
  • RE: SQL Server Service Manager
    ... Microsoft CSS Online Newsgroup Support ... <Thread-Topic: SQL Server Service Manager ...
    (microsoft.public.windows.server.sbs)
  • RE: SQL Server Service Manager Problem on SBS2003 Standard
    ... You can remove the Service Manager shortcut from the Startup group. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... SQL Server Service Manager Problem on SBS2003 Standard ...
    (microsoft.public.windows.server.sbs)
  • Re: SPS 2003 with SQL 2005
    ... To apply Sharepoint Portals Server SP2, ... > you must first apply Windows Sharepoint Services SP2. ... > Sharepoint Services SP2 enables support for SQL 2005. ... Microsoft SQL Server 2000 Enterprise Edition, ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Referenced Memory Problem with Enterprise Manager
    ... Could be a bad SQL Server binary. ... sp_attach_db to narrow down if it is the .MDF file the local SS installation ... When I attempt to attach a database using the wizard in the manager, I get the following error when I click on the button to select MDF file of database to attach: ... The instruction at "0x41d53c0a" referenced memory at "0xffffffff". ...
    (microsoft.public.sqlserver.server)

Quantcast