January 22, 2013 at 5:03 am
hello experts,
just want to know, if backup is happening for a database and one scheduled job also triggered for the backup of same database at same path with same name. what will happen ??
January 22, 2013 at 5:06 am
Both will go smoothly as sql server will start them sequentialy though there will be IO usage (might be contention if the disk is slow)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 22, 2013 at 6:33 am
Zeal-DBA (1/22/2013)
hello experts,just want to know, if backup is happening for a database and one scheduled job also triggered for the backup of same database at same path with same name. what will happen ??
It's just like anything else, two processes cannot write to the same file at the same time. The second backup operation will fail.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 22, 2013 at 6:40 am
You get the below error on the second backup
Msg 3023, Level 16, State 2, Line 1
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 or file manipulation operation is completed.
Msg 3204, Level 16, State 1, Line 1
The backup or restore was aborted.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
January 23, 2013 at 12:33 am
Zeal-DBA (1/22/2013)
just want to know, if backup is happening for a database and one scheduled job also triggered for the backup of same database at same path with same name. what will happen ??
ohh i missed the same name condition , i will go with OPC here
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply