for example I will need to migration database online to Azure SQL MI . during the cutover , I but the database into single_user mode and do the log backup backup log dbname to disk='path' backup log dbname to disk='path' with norecovery,no_truncate which one I should use ? and what's the difference ?

@sakuraime Please check this document for more details. This details the use of these arguments: Regards Navtej S

Azure sql mi migration Online

sakuraime 2,321

for example I will need to migration database online to Azure SQL MI . during the cutover , I but the database into single_user mode and do the log backup

backup log dbname to disk='path'
backup log dbname to disk='path' with norecovery,no_truncate

which one I should use ? and what's the difference ?

1 answer

Navtej Singh Saini 4,216 Reputation points Microsoft Employee

2021-04-29T15:22:34.72+00:00

@sakuraime

Please check this document for more details. This details the use of these arguments:

Regards
Navtej S
Please sign in to rate this answer.
sakuraime 2,321 Reputation points

2021-04-30T03:57:33.443+00:00

so what's the conclusion ?

1 or 2 ?

if I choose option 2 , the original database is in restoring state after backup log dbname to disk='path' with norecovery

and if I would like to resume the database , I need to do 1 or 2 ?

restore database dbname with recovery

restore log dbname from disk ='path to the last logbackup'

Navtej Singh Saini 4,216 Reputation points Microsoft Employee

2021-05-04T02:02:38.433+00:00

@sakuraime

As the document says for best effort log back up that skips log truncation and put the database in restoring state, you should be using both No_recovery and No_Truncate when restoring.

Navtej S

sakuraime 2,321 Reputation points

2021-05-11T01:38:49.777+00:00

I am talking about backup .
I just wonder if the database already in single_user mode

what's the difference between

backup log with the option norecovery and without norecovery ?
Sign in to comment