I am getting the following error while restoring the Diff back up after restoring the Full backup in Norecovery mode.
I am unable use
dbcc checkdb as the database in restoring db.Issues happens only in three instance where there is totally 6 instance. In other instance restore is working fine.
Msg 5052, Level 16, State 1, Line 4
ALTER DATABASE is not permitted while a database is in the Restoring state.
Msg 5069, Level 16, State 1, Line 4
ALTER DATABASE statement failed.
Expression: newTree.IsInArchive ()
Process ID: 1956
Msg 3013, Level 16, State 1, Line 22
RESTORE DATABASE is terminating abnormally.
Msg 3624, Level 20, State 1, Line 22
A system assertion check has failed. Check the SQL Server error log for details.
Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.
Help me in resolving this issue.