Coming Soon: GET-IT: Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET-IT: Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET

SQL maintenance full backup woes on SQL 2005

Home Forums Other Microsoft Servers and SaaS SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2016 SQL maintenance full backup woes on SQL 2005

Viewing 1 post (of 1 total)
  • Author
    Posts

  • ranjb
    Participant
    #167406

    Hi Fellow Techs

    I was wondering if I could get some support/advice from some SQL Guru’s as I been having a problem with a legacy SQL server being backed up and have tried a number of steps however I not been able to get this issue resolved. This legacy server unfortunately runs 2005 ver 9.0.5069.

    So I have setup some SQL maintenance backup plans to schedule a full backup of a Database every night. What I have found is sometimes the backup works as expected but most of the time its just runs and takes days for the job to finish.

    When looking at the error logs I am seeing codes related to the following as well as one message which consistently comes up.

    Error: 3041, Severity: 16, State: 1.
    Error: 3023, Severity: 16, State: 2.
    Source spid20s

    Message
    Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.

    I attach the full recent log with this.

    What I have tried:

    • Created a maintenance task to check database integrity and rebuild the index, update the statistics. This job runs successfully once a week.
    • Rebooted the server and SQL related services.
    • Tried an alternative 3rd party backup software Redgate SQL Backup and have the same problem with the 3 party tool.

    It saying the database must be serialized. What exactly does this mean?

    Any help on this would be appreciated.

    Thanks

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: