49760: Acronis Cyber Protect: Single-Pass Backup of MS SharePoint Server Fails with "Database is already open and can only have one user at a time"

Last update: 25-08-2021

Symptoms

  1. You are backing up a SharePoint Server.
  2. Backup fails with:

Error code: 54
Module: 482
LineInfo: 5c71ebf434f0c47a
Fields: $module : disk_bundle_vs_38774
Message: Failed to collect all of the data required for single-pass backup of Microsoft SQL Server.
--------------------
Error code: 4354
Module: 87
LineInfo: e4fe5c9fd5e63de8
Fields: $module : aaib_mssql_backuper_vs_38774
Message: Cannot back up SQL Server database 'Databasename' of instance 'INSTANCENAME'.
--------------------
Error code: 16
Module: 87
LineInfo: b19b368b2754d2f3
Fields: $module : ArsAgentProvider_vs_38774
Message: Failed to execute SQL statement 'SELECT COLUMNPROPERTY(OBJECT_ID('[Databasename].sys.filegroups'), '', 'ColumnId')'.
--------------------
Error code: 2048
Module: 87
LineInfo: b19b368b2754d2f4
Fields: $module : ArsAgentProvider_vs_38774
Message: 42000 (924): [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'Databasename' is already open and can only have one user at a time. 

Cause

The database you are trying to back up runs in Single User mode. It needs to be run in Multi User mode.

Solution

  1. Start the SQL Server Management Studio and connect to the Instance specified in the error message.
  2. Select New query, type:
    exec sp_who
  3. Press Execute.
  4. You will get a list of current sessions. Identify the session and type:
    kill <SPID>
    go
    where <SPID> is the SPID of the session using the database
  5. Press Execute.
  6. Type: 
    exec sp_dboption 'Databasename', 'single user', 'FALSE';
    go

    where <Databasename> is the name of your database
  7. Press Execute.
  8. Start the backup.

More information

Please contact Acronis Support if you need assistance.

Tags: