Home > Archive > Microsoft SQL Server Desktop Engine > July 2005 > MDF Missing!









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author MDF Missing!
Ruben

2005-06-30, 1:24 pm

Hi, I have a very strange and dangeorous problem, I have MSDE 2000 SP3
installed on several laptops using a database as local, and it replicates as
the user request to, using Merge replication. Everything works fine, but
sometimes suddenly the MDF and TRN files of the laptops just dissappears.

I look over all the disk and there are no trace of the files, it isn't in
the recycle byn, and the most strange is if I try to delete an MDF the OS
dennies the operation, because the service is running.

Any idea?? please help
Greg Low [MVP]

2005-07-04, 3:23 am

Hi Ruben,

Sounds like either:

a) virus activity
b) virus scanner activity
c) hardware issues
d) corrupted disk (particularly if fat32 as an example)

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

"Ruben" <Ruben@discussions.microsoft.com> wrote in message
news:647704C3-9351-40D7-BEF2- E8625D445452@microso
ft.com...
> Hi, I have a very strange and dangeorous problem, I have MSDE 2000 SP3
> installed on several laptops using a database as local, and it replicates
> as
> the user request to, using Merge replication. Everything works fine, but
> sometimes suddenly the MDF and TRN files of the laptops just dissappears.
>
> I look over all the disk and there are no trace of the files, it isn't in
> the recycle byn, and the most strange is if I try to delete an MDF the OS
> dennies the operation, because the service is running.
>
> Any idea?? please help



Ruben

2005-07-04, 11:23 am

Hi Greg, I suppossed that and I'll run a full scan on that computers, but the
only chance is that virus just affects mdf files, because no other files are
being deleted. Thank you any way

"Greg Low [MVP]" wrote:

> Hi Ruben,
>
> Sounds like either:
>
> a) virus activity
> b) virus scanner activity
> c) hardware issues
> d) corrupted disk (particularly if fat32 as an example)
>
> HTH,
>
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
>
> "Ruben" <Ruben@discussions.microsoft.com> wrote in message
> news:647704C3-9351-40D7-BEF2- E8625D445452@microso
ft.com...
>
>
>

Ruben

2005-07-04, 8:23 pm

It happen again! on three laptops the MDF where deleted, I ran the antivirus
(with latest definitions, symantec and McAfee), ran the MS AntiSpyware full
scan and none found, all the disks are NTFS. I noticed just the replicated
databases are being deleted.

Please help me, I can't found any case like this in whole internet....thanks

"Ruben" wrote:
[color=darkred]
> Hi Greg, I suppossed that and I'll run a full scan on that computers, but the
> only chance is that virus just affects mdf files, because no other files are
> being deleted. Thank you any way
>
> "Greg Low [MVP]" wrote:
>
Greg Low [MVP]

2005-07-11, 3:23 am

Turn on Auditing for File Deletions in NTFS and find out who/when is
deleting the file.

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

"Ruben" <Ruben@discussions.microsoft.com> wrote in message
news:27E76B98-3867-4B2E-8B7E- A2775E83427A@microso
ft.com...[color=darkred]
> It happen again! on three laptops the MDF where deleted, I ran the
> antivirus
> (with latest definitions, symantec and McAfee), ran the MS AntiSpyware
> full
> scan and none found, all the disks are NTFS. I noticed just the replicated
> databases are being deleted.
>
> Please help me, I can't found any case like this in whole
> internet....thanks
>
> "Ruben" wrote:
>


Ruben

2005-07-11, 9:23 am

Thank again Greg, i'll try this

"Greg Low [MVP]" wrote:

> Turn on Auditing for File Deletions in NTFS and find out who/when is
> deleting the file.
>
> HTH,
>
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
>
> "Ruben" <Ruben@discussions.microsoft.com> wrote in message
> news:27E76B98-3867-4B2E-8B7E- A2775E83427A@microso
ft.com...
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com