September 17, 2014 at 7:07 am
Hi,
When I try to add a file to the file group, I am getting error msg
Backup, file manipulation operations (such as Alter database add file) and encryption changes on a database must be serialized. Reissue the statement after the current backup
Msg 3023, Level 16, State 3, Line1
But when I check there is no backups on that database
select command,
DB_Name (database_id) as databasename,
percent_complete,
from sys.dm_exec_requests
cross apply sys.dm_exec_sql_text(sql_handle)
where command in ('Restore Database', 'Backup Database')
That is test server. There is no backups for sure but still I am getting error. Is there any another reason behind this?
September 17, 2014 at 7:14 am
Can you post the script you are using?
September 17, 2014 at 10:02 am
Actually that database is configured for mirroring.
Is that causing any issue? How to figure out why I am unable to add file the secondary file group.
I created 2 secondary file groups, I am able to add file to the first file group but adding the file to the second filegroup is giving me this error.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply