RE: Strange Backup problem



Dear Customer,

Sorry to keep you waiting.

I have discussed with SQL Engineers but we cannot reproduce your issue
here, so please help me to perform following steps and gather more detailed
information to further troubleshoot your issue:

=============

Suggestion 1:

Since the error refers to the MSDEWriter, and 0x800423f4 is translated to
VSS_E_WRITERERROR_NONRETRYABLE, I think this could be a service account
issue of the MSDE instance. For a further troubleshooting, please refer to
the following steps.

1. Run Services.msc to bring up the service console

2. Double click MSSQL$SHAREPOINT to open the properties page.

3. In the logon tab, please make sure this service is running under Local
System Account instead of a specific account

4. Please check the same settings with MSSQL$SBSMONITORING service

5. Restart the server and test your issue again.

In addition, please also make sure MSSQLServer service is running under
System Account service.

Suggestion 2:

a. On the SBS Server, go to Start -> Run "regedit" (without quotation
marks).
b. Check if you have following registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\Setup

DTSInstall=DWORD: 00000001

DTSPath = "C:\\Program Files\\Microsoft SQL Server\\90\\DTS\\"

c. You may need to restart Server.

Suggestion 3:

You cannot back up a volume by using the Volume Shadow Copy Service in
Windows Server 2003 after you install Microsoft SQL Server 2005 CTP
http://support.microsoft.com/default.aspx?scid=KB;EN-US;904801

For your additional information:

828481 Error 800423f4 appears in the backup log file when you back up a
volume by using the Volume Shadow Copy service in Windows Server 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;828481

Update is available that fixes various Volume Shadow Copy Service issues in
Windows Server 2003
http://support.microsoft.com/?id=891957

912414 Error message when you use the Volume Shadow Copy Service (VSS) to
back up SQL Server 2000 database files or SQL Server 2000 Desktop Engine
(MSDE) database files: "'MSDEWriter' has reported an error 0x800423f4"
http://support.microsoft.com/default.aspx?scid=kb;EN-US;912414

=============

If the issue persists, please help me to gather following information for
further research:

1. Are you running the SBS 2K3 SP1?

2. Please help me to gather Backup Log:

1) The Backupxx.log files in the folder 'C:\Documents and Settings\SBS
Backup User\Local Settings\Application Data\Microsoft\Windows
NT\NTBackup\data'.

2) The Sbsbackuplog0x.log files which can be located under the folder
'%sbsprogramdir%\Support\Backup Logs'.

Please zip these backup logs and send them two attachments to my mailbox:
v-branee@xxxxxxxxxxxxxx

Please take your time to perform the steps and gather the information. I am
looking forward to hearing from you!

Best regards,

Brandy Nee

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
Thread-Topic: Strange Backup problem
thread-index: AcZW9OPIOA1dp+VoQFqnB+OGfd/leA==
X-WBNR-Posting-Host: 60.48.24.73
From: =?Utf-8?B?Q2hpbmc=?= <Ching@xxxxxxxxxxxxxxxxxxxxxxxxx>
References: <7070837D-AD62-4894-B52C-C07CEE5736BA@xxxxxxxxxxxxx>
<kziV7QHVGHA.880@xxxxxxxxxxxxxxxxxxxxx>
Subject: RE: Strange Backup problem
Date: Mon, 3 Apr 2006 01:02:02 -0700
Lines: 170
Message-ID: <328089BA-9631-4217-A519-D386B5A46769@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.windows.server.sbs
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:257629
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.windows.server.sbs

I am a bit confused. If Windows SBS does not support SQL 2K5 Enterprise
Edition, why does this page says it is supported?
http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx


.



Relevant Pages

  • Re: Upgrading to R2 premium SQL questions
    ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... |> Collation settings in SQL Server is commonly used for international ...
    (microsoft.public.windows.server.sbs)
  • RE: NOLOCK due to data movement
    ... It is unfortunate that you do not understand that this is an SBS problem. ... The default instance of SQL 2005 is working fine. ... Please understanding our newsgroup is mainly focused on SBS support. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Monitoring & Reporting Wont install! (msde install fails!)
    ... Perform a clean boot on the server. ... SQL Server SP4\MSDE". ... Please paste the output in the newsgroup. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Microsoft CSS Online Newsgroup Support ... SBS 2003 Unable to connect to database STS_Config ... You cannot upgrade the Monitoring instance to SQL ...
    (microsoft.public.windows.server.sbs)
  • RE: Help please
    ... you can allow access to SQL for user in Windows 2003 domain. ... > newsgroup, as there you may have more good sharing in SQL fields. ... > Microsoft CSS Online Newsgroup Support ... > | At this moment my client use software without license (please don't ask ...
    (microsoft.public.windows.server.sbs)