Re: file backup component

Merry.Win,

Well, honestly, if the issue is only due to some timing at the system boot time, it may be not easy to find out he source who keeps
the file locked at the boot time.

First of all, you should carefully review all the services, Run/RunOnce and Start Up programs on your image runtime. Maybe you will
be able to find the faulty component just from the service name.

Otherwise you can try to use audit techniques to find out who's trying to access the LDF file. The audit will only work for you if
you use NTFS file system. Here is how you set up the audit on particular file: http://support.microsoft.com/kb/310399. You should
probably set the Success and Failure audit event on that file to see all the attempts to access it. Easiest way to make the audit
and Local Security Policies work on your image is to include Administrative Tools Support component and resolve its dependencies.
Otherwise, AuditPol.exe command line tool from Resource Kit may be used.

--
=========
Regards,
KM

KM

I've tested the method you recommended me that revealed there indeed a
timing issue on my system.Afer enter the desktop and all system tray icons
on the right below desktop appear,I can start manually SQL service easily.

But which thread occupies the LDF file when system boot up? I do not install
file backup app or any other app that need LDF file a while.

Regards

Merry.Win

"KM" <konstmor@xxxxxxxxxxxxxxxx> дÈëÏûÏ¢ÐÂÎÅ:%23jGk9IRXHHA.1432@xxxxxxxxxxxxxxxxxxxxxxx
Merry.Win,

I am not sure what he was referring to as the backup thread. Perhaps, he meant something that belongs to the SQL server itself.
I'd recommend you:
- Delay the start of the SQL server service until manual start. This way you can test it whether there is indeed a timing
issue there.
- Explore the issue with the tools from sysinternals.com. Specifically, make use of ProcessExplorer and ProcessMonitor tools.
The first one will give you enough info about a process/service as to what modules (dlls, etc.) and files (database files, logs
,etc.) are being loaded and mapped to the process address space. With this you may be able to find the process that locks the LDF
file.

As to the windows backup. Just check if you happened to include the components I already mentioned in your image config and/or
its dependencies.

--
=========
Regards,
KM

Hi ,KM

I have builded a XPE image with SQL server 2005. Sometimes,my SQL server service can not automaticly start after system is
start.I have checked the log with event viewer.There is a error in event log that a thread are using mastlog.ldf file when
system start the SQL service.The thread that Mr.RM in microsoft.public.sqlserver.server newgroup told me may be the file backup
thread.

How can I konw whether my image have file backup function?

Thanks

Merry.Win

"KM" <konstmor@xxxxxxxxxxxxxxxx> дÈëÏûÏ¢ÐÂÎÅ:uiHRNVIXHHA.3948@xxxxxxxxxxxxxxxxxxxxxxx
Probably what you are looking for is "Windows Backup Utility" component. (Since SP2 this component has Visibility 1000)

--
=========
Regards,
KM

Hi All

How to know that file backup component is included in the xpe image?

thank you for your answer.


Merry.Win










.

Relevant Pages

  • Re: file backup component
    ... I've gotten my problem solved.The reason why my SQL service sometimes can ... Otherwise you can try to use audit techniques to find out who's trying to ... file backup app or any other app that need LDF file a while. ... Delay the start of the SQL server service until manual start. ...
    (microsoft.public.windowsxp.embedded)
  • Re: One Web Service updates SQL, another cant?
    ... In the profiler, in the Events tab, click on Security Audit. ... Columnist, SQL Server Professional ... And then I start getting the database closed errors on subsequent calls. ... >>> thing to look at is the permissions for that user in EM. ...
    (microsoft.public.sqlserver.security)
  • Re: file backup component
    ... file backup app or any other app that need LDF file a while. ... Delay the start of the SQL server service until manual start. ... way you can test it whether there is indeed a timing issue there. ... I have builded a XPE image with SQL server 2005. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Audit logging an adp
    ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Who is using MSMQ?
    ... To add on to the other responses, the MSMQ warning messages you get from the ... SQL Server Service Manager are the same ones you get from the Windows MMC ...
    (microsoft.public.sqlserver.security)