Re: file backup component

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 have builded a XPE image with SQL server 2005. ... How can I konw whether my image have file backup function? ... How to know that file backup component is included in the xpe image? ...
    (microsoft.public.windowsxp.embedded)
  • Re: file backup component
    ... Otherwise you can try to use audit techniques to find out who's trying to access the LDF file. ... file backup app or any other app that need LDF file a while. ... he meant something that belongs to the SQL server itself. ... Delay the start of the SQL server service until manual start. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Need help please
    ... You probably will not be able to restore... ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > database was, but i was able to recover a file backup from the database wich> has almost 10 GB, and when i try to restore this file over a new database> the SQL tell's me that the the file backup isn't a valid backup format and> doesn't recognize the data on that file. ...
    (microsoft.public.sqlserver.server)
Loading