Exclusive access to the database is not available because the database is in use

Tag: Backup arc executes data LLB datastore DIV Replace

Execute SQL Statement restore DATABASE times "exclusive access to the database is not available because the database is in use"

Plus these two sentences will solve the problem:

ALTER DATABASE [datebase] SET  with ROLLBACK IMMEDIATE -- SQL RESTORE Statements ALTER  Database  [  datebase]  Set   Online  

As follows:

Declare @strDataBaseName varchar( -)Declare @FileFlag varchar( -) --define the database name of the backupSet @strDataBaseName='Database name'Set @FileFlag='D:\db_backup\'+@strDataBaseName + '_db_' + Replace(Convert(Char( -),getdate(), the),' ',"')+'. bak'--Add this sentence to prevent the database from being used resulting in unsuccessful executionALTER DATABASE [Database name] SETOFFLINE with ROLLBACKIMMEDIATERestore Database [Database name] from Disk=@FileFlag   with file=1,REPLACE, RecoveryALTER  Database  [Database name]  SetOnline

Exclusive access to the database is not available because the database is in use