Share via

Microsoft server 2012 - broken write command during backup

Zuzana Šalková 1 Reputation point
2021-10-07T10:56:27.82+00:00

Hello,

it is used Microsoft server 2012.
External device is writing to sql. Once per day is run backup procedure.
When backup process is starting and writing is in progress, then is interrupted.
How can be possible create sql backup without interruption and writing process, please?
Thanks a lot.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 14,016 Reputation points Microsoft External Staff
    2021-10-08T03:22:57.63+00:00

    Hi Zuzanaalkov-7478,

    Welcome to Microsoft Q&A.
    In addition, please check if there are any error message in the Windows application log and SQL Server error log. Please refer to this doc to help you find it.
    And please try to install the latest SP for SQL Server 2012.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

    0 comments
  2. Olaf Helper 47,621 Reputation points
    2021-10-07T13:34:57.047+00:00

    How do you backup the database? A "classic" SQL backup don't disturbe any transaction nor break connections.
    Or are you using VSS? Then the database goes into a short frozen state, but also that's all.

    Which SQL Server version arte you using? There was a known issue in VSS backup, but fixed, see
    https://support.microsoft.com/en-us/topic/kb4523102-fix-sql-server-database-remains-in-frozen-i-o-state-indefinitely-when-backed-up-by-vss-bd46bb50-2443-c3ee-fdd7-cb7d11c1b6cc

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.