SBS 2003 Backup failing
|
From: Terence Liu [MSFT] on 16 Aug 2007 05:59 Hello Simon, Thank you for posting back. I'm glad to hear that things are working correctly for you now. I'd like to make a summary for this post: Issue: ============= Get the following error when backup SBS "MSDEWriter" has reported an error 0x800423f4. This is part of System State. The backup cannot continue. Resolutions: ============= 1). Try to find NT AUTHORITY\SYSTEM Foreign Security Principal in Active Directory Users and Computers. If you do not find it, please run the following command to add it back: net localgroup users "NT AUTHORITY\SYSTEM" /add 2). Decided to try installing a new MSDE instance as a test using the following command: C:\Program Files\Microsoft SQL Server SP4\MSDE\setup>SqlRun13.msi blanksapwd=1 INSTANCENAME="SBSTEST" DATADIR="C:\Program Files\Microsoft SQL Server\" TARGETDIR="C:\Program Files\Microsoft SQL Server\" /L*v "C:\windows\temp\MSDE_SBSTest.log 3). Start the MSSQL$SBSTEST service. Also start the MSSQL$SBSMONITORING and the MSSQL$SHAREPOINT services. 4). Then test the SBS Backup. 5). If the backup success finish, please uninstall the SBSTEST MSDE Instance from Control Panel - Add/Remove Programs. Please do not hesitate to post in this great newsgroup if you need any assistance in the future. I look forward to working with you again. Thank you and have a nice day, Best regards, Terence Liu(MSFT) 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: SBS 2003 Backup failing | thread-index: AcffpGfaO95mniXkTcCmGrAbT5KsAQ== | X-WBNR-Posting-Host: 207.46.192.207 | From: =?Utf-8?B?U2ltb24gRGFuaWVs?= <SimonDaniel(a)discussions.microsoft.com> | References: <238920C8-E7D8-478A-B22B-BCEEC36D7E64(a)microsoft.com> <OlWNOcg3HHA.748(a)TK2MSFTNGP04.phx.gbl> <DA730AF9-BA7C-4E05-BBFC-F75D25C4E8FB(a)microsoft.com> <uGVq96g3HHA.5360(a)TK2MSFTNGP03.phx.gbl> <346C404F-86FF-4BD3-A20B-1E382213B6E2(a)microsoft.com> <j9uAg2l3HHA.5204(a)TK2MSFTNGHUB02.phx.gbl> | Subject: Re: SBS 2003 Backup failing | Date: Wed, 15 Aug 2007 18:26:01 -0700 | Lines: 141 | Message-ID: <6C745B32-5934-443E-9656-95FFBAF42A08(a)microsoft.com> | 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.2826 | Newsgroups: microsoft.public.windows.server.sbs | Path: TK2MSFTNGHUB02.phx.gbl | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:56802 | NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148 | X-Tomcat-NG: microsoft.public.windows.server.sbs | | Thanks a lot Terence. | | Your suggestion to install a new MSDE instance MSSQL$SBSTEST fixed the | problem. After I uninstalled the MSSQL$SBSTEST instance the backup still | works. | | | "Terence Liu [MSFT]" wrote: | | > Hello Simon, | > | > Thank you for your post here. | > | > I understand that you encounter error 800423f4 when trying to backup SBS | > Server. If I have misunderstood your issue, please do let me know. | > | > I suggest that we first perform following generate troubleshoot steps to | > see how it goes. | > | > 1. Please apply the following hotfix first, most this error will be fix by | > this hotfix: | > | > 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 | > | > 2. Since the error refers to the MSDEWriter, this issue may be related | > with Microsoft SQL Server 2000 Desktop Engine (MSDE) database files. As | > 0x800423f4 is translated to VSS_E_WRITERERROR_NONRETRYABLE, I suggest that | > we have a check the service account issue of the MSDE instance. | > | > 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. | > | > 3. Please install following hotfix to see how it goes: | > | > Update is available that fixes various Volume Shadow Copy Service issues in | > Windows Server 2003 | > http://support.microsoft.com/default.aspx?scid=kb;en-us;891957 | > | > A new Volume Shadow Copy Service update is now available that fixes various | > Volume Shadow Copy Service problems in Windows Server 2003 | > http://support.microsoft.com/default.aspx?scid=kb;EN-US;913648 | > | > 4. | > 1). Try to find NT AUTHORITY\SYSTEM Foreign Security Principal in Active | > Directory Users and Computers. If you do not find it, please run the | > following command to add it back: | > | > net localgroup users "NT AUTHORITY\SYSTEM" /add | > | > 2). Decided to try installing a new MSDE instance as a test using the | > following command: | > | > C:\Program Files\Microsoft SQL Server SP4\MSDE\setup>SqlRun13.msi | > blanksapwd=1 | > INSTANCENAME="SBSTEST" DATADIR="C:\Program Files\Microsoft SQL Server\" | > TARGETDIR="C:\Program Files\Microsoft SQL Server\" /L*v | > "C:\windows\temp\MSDE_SBSTest.log | > | > 3). Start the MSSQL$SBSTEST service. Also start the MSSQL$SBSMONITORING and | > the MSSQL$SHAREPOINT services. | > | > 4). Then test the SBS Backup. | > | > 5). If the backup success finish, please uninstall the SBSTEST MSDE | > Instance from Control Panel - Add/Remove Programs. | > | > Test the SBS Backup. | > | > If the issue persists, please kindly help me collect some information for | > further investigation: | > | > 1. Save application event log and system event log as evt files on | > problematic machines and send to my mailbox: v-terliu(a)microsoft.com | > | > 2. Please gather and send me the entire NTBackup log file for further | > analysis. | > | > C:\Documents and Settings\<user name>\Local Settings\Application | > Data\Microsoft\Windows NT\NTBackup\data | > | > 3. Please gather an MPS setup report: | > | > 1) Please download the MPSRPT_SETUPPerf.EXE from the following link and | > then run this tool to gather some information from the problematic computer: | > http://download.microsoft.com/download/b/b/1/bb139fcb-4aac-4fe5-a579-30b0bd9 | > 15706/MPSRPT_SETUPPerf.EXE | > | > 2) Double-click on the MPSRPT_SETUPPerf.EXE file. | > [Note] This process may take some time; however, it will not have a | > negative effect on the performance. | > | > 3) A CAB file will be generated in the | > %systemroot%\MPSReports\Setup\Reports\Cab directory called | > %COMPUTERNAME%_MPSReports.CAB. The CAB file will contain the reports | > generated by the MPS Reporting Tool. | > | > Send the .cab file directly to me at v-terliu(a)microsoft.com | > | > Hope these steps will give you some help. | > | > Thanks and have a nice day! | > | > Best regards, | > | > Terence Liu(MSFT) | > | > 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. | |