Re: Moving server to larger hard drive

From: Marina Roos [SBS-MVP] (marina_at_roos.nodontwantspam.nl.com)
Date: 03/12/05


Date: Sat, 12 Mar 2005 01:42:45 +0100

Hi Bob,

It is all in the log. Error 0x800423f4 and SQL database(s) that are not in
simple mode.

http://download.microsoft.com/download/5/6/1/561c9fd7-0e27-4525-94ec-4d2d38f
61aa3/TSHT_SBS.htm#backup

Cause: SQL Server 2000 is installed and one or more databases have a
recovery model not set to Simple. Windows Small Business Server 2003 backup
cannot back up this type of databases.

Solution: Set the SQL Server 2000 database recovery model to Simple.

To set the SQL Server 2000 database recovery model to Simple

Open SQL Server Enterprise Manager.
Double-click Microsoft SQL Servers, double-click SQL Server Group, (Local),
and then double-click Databases.
Right click each database, choose Properties, and then on the Options tab,
under Recovery, set the model to Simple.

Ray Fong
Microsoft SBS Product Support

-- 
Regards,
Marina
Microsoft SBS-MVP
One of the Magical M&M's
"BoboTWG" <aaron.nospam@excite.com> schreef in bericht
news:72nYd.8583$DW.5660@newssvr17.news.prodigy.com...
> OK. One more question on the same "drive space" tangent. My Exchagne logs
> are still not being flushed and I am confused as to what is happening.
Here
> is my backup log.
>
> 3/9/2005 11:00 PM
>
> -------------------------------
>
> Date: 3/9/2005
>
> Time: 11:00 PM
>
> User: SYSTEM
>
> -------------------------------
>
>
>
> Backup Runner started.
>
> NTMS session started successfully.
>
> EnumerateNtmsObject(NTMS_LIBRARY) succeeded.
>
> Will enumerate on 4 media libraries found.
>
> GetNtmsObjectInformation(NtmsLibraryInfo) succeeded.
>
> GetNtmsObjectInformation(NtmsLibraryInfo) succeeded.
>
> GetNtmsObjectInformation(NtmsLibraryInfo) succeeded.
>
> Found an enabled library.
>
> InventoryNtmsLibrary(NtmsInventoryOmid) succeeded.
>
> Identify Media completed
>
> EnumerateNtmsObject(NTMS_MEDIA_TYPE) succeeded.
>
> Will enumerate on 0 media types found.
>
> GetNtmsObjectInformation(NtmsLibraryInfo) succeeded.
>
> Found an enabled library.
>
> InventoryNtmsLibrary(NtmsInventoryOmid) succeeded.
>
> Identify Media completed
>
> EnumerateNtmsObject(NTMS_MEDIA_TYPE) succeeded.
>
> Will enumerate on 1 media types found.
>
> GetNtmsObjectInformation(NtmsPhysicalMediaInfo) succeeded.
>
> GetNtmsObjectInformation(NtmsMediaTypeInfo) succeeded.
>
> Found a tape media type in the library (miniQIC).
>
> Launching NTBackup: ntbackup.exe backup "@C:\Program Files\Microsoft
Windows
> Small Business Server\Backup\Small Business Backup Script.bks" /d "SBS
> Backup created on 3/9/2005 at 11:00 PM" /v:yes /r:no /rs:no /hc:on /m
normal
> /j "Small Business Server Backup Job" /l:s /p "miniQIC" /UM
>
> NTBACKUP LOG FILE: C:\Documents and Settings\SBS Backup User\Local
> Settings\Application Data\Microsoft\Windows NT\NTBackup\data\backup09.log
>
> =====================<BEGIN NTBACKUP LOG FILE>=====================
>
> Backup Status
>
> Operation: Backup
>
> Active backup destination: miniQIC
>
> Media name: "Media created 3/9/2005 at 11:00 PM"
>
>
>
> MSDEWriter has reported a VSS error 0x800423f4.
>
> NtBackup does not support backing up SQL databases which are configured in
> non-simple recovery mode.
>
> If the database has been backed up, it is likely corrupted. Please do not
> restore this database.
>
> The recommended way of backing up non-simple SQL database is to use the
> backup solution that comes with SQL Server.
>
>
>
> Backup (via shadow copy) of "C: "
>
> Backup set #1 on media #1
>
> Backup description: "SBS Backup created on 3/9/2005 at 11:00 PM"
>
> Media name: "Media created 3/9/2005 at 11:00 PM"
>
>
>
> Backup Type: Normal
>
>
>
> Backup started on 3/9/2005 at 11:08 PM.
>
> The requested media failed to mount. The operation was aborted.
>
> The operation was ended.
>
> Backup completed on 3/10/2005 at 2:52 AM.
>
> Directories: 1948
>
> Files: 65722
>
> Bytes: 20,110,346,491
>
> Time:  3 hours,  43 minutes, and  48 seconds
>
>
>
> ----------------------
>
>
>
> The operation did not successfully complete.
>
>
>
> ----------------------
>
>
>
> =======================<END NTBACKUP LOG FILE>=====================
>
> NTBackup finished the backup with errors.
>
>
>
> For more information about failed backups, see the article on
> troubleshooting your backup at the following Web page:
> http://go.microsoft.com/fwlink/?LinkId=18414
>
>
>
> Backup ended at Thursday, March 10, 2005 2:52 AM
>
> Backup Runner finished.
>
>
>
> What am I doing wrong? I get errors about the SQL not being able to be
> backed up but the wizard will not allow me to exclude SQL because it is
need
> for system restore.
>
>
>
> Aaron
>
>


Relevant Pages

  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.server)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.programming)
  • Re: "Best Practices" way to distribute MSDE
    ... > Restore a users's selected backup. ... for dayly house-keeping I do usually provide scripted job for database ... that file copy operation (not SQL Server backup!) can be performed.. ... my personala advice is to perform dayly house-keeping actions ...
    (microsoft.public.sqlserver.msde)
  • Re: NT Backup Causes Server to Hang
    ... Thanks for using the SBS newsgroup. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: Copy SQL Server Objects Task
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> You do not need sa privileges to backup a database. ... When a password is defined on a media set, ... >> password and backup set password are specified in the restore command. ...
    (microsoft.public.sqlserver.dts)

Quantcast