Share via

Database backup fails

Avyayah 1,291 Reputation points
2024-11-11T23:38:23.9133333+00:00

Backuperror

But no issues when manual backup in the same location. THere is no space issue. I have another server with same service pack and has no issues. This is the eversion #: Microsoft SQL Server 2016 (SP2-GDR) (KB4583460) - 13.0.5108.50 (X64) May 20 2022 20:28:29 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,148 questions
Accepted answer
  1. ZoeHui-MSFT 38,621 Reputation points
    2024-11-12T05:42:15.1133333+00:00

    Hi @Avyayah，

    Are you using BACKUP command directly, or are you using some third-party software?

    If you are using third-party, please make sure SQL VSS Writer is started.

    To open the services through control panel, click Start, click Control Panel, double-click Administrative Tools, and then double-click Services. In the Services pane, double-click the SQL writer service and modify the "Startup Type" property to "Automatic".

    Service should then be started by selecting the "Start" button under the "Service Status" property in the service property screen mentioned above.

    Make sure the SQL Server can access this backup device location.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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