I thought so, but I no expert in SQL.
So my users are able to insert records into another database in SQL, but when I perform the maintenance plan to run it, it errors out:
Executing the query "USE [model]
" failed with the following error: "Database 'model' cannot be opened. It is in the middle of a restore.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I not able to restore back to previous date or stop the restore process.