Thank you, that works!

Thanks for the script, this is the one of the best scripts used to store db to another sever.

At Luke's powershell script , at bottom lines of the code as below, if I want the source server and destination server has different data file physical path how can...

Ok I will do it in script.

However I just wonder why this happens on SSMS, is it a bug?
I don't have many backups on these server, only...

By the way the restore from production server to test server for database 2 is done by using powershell script.

I do clean up histories every 2 months.
Also if I did a full backup for database2 instead of differential, then I run the same steps I described above, I...

thanks all.
I also see the cursor is used for the reason to log or handle errors for  the specific record (id, or other columns) that caused the error, while set based cannot...

Thanks Sue, that makes a lot of sense.
The stored procedure I saw in the database can mostly be replaced by set based standard queries,  other than some log and...

I agree that, just wonder why Jeff said it is not a procedure language. but the website said it is :

PL/SQL (Procedural Language/Structured Query Language)

I see on this page:  https://en.wikipedia.org/wiki/PL/SQL

PL/SQL (Procedural Language/Structured Query Language

But use many dml in cursors in pl_sql caused context switch between sql engine and plsql engine which affects performance. My question is why not just use standard sql statements...

This is the one, thank you!

Thank you, it is good article.
It seems it is allowed to add  a where statement to when not matched then insert........ where....

That's what I did. But I...

Thank you. Just checked, you are right, it be added in T_SQL .

I thought this is the same in  in oracle PL_SQL.

I am in fact working on a...

Thank you, I am not ver clear, it looks the same to me the first and the second example

Thank you. I think I need to read and understand snapshot more , and when to use it.
You explanation is greatly appreciated.