It is a test server. Yes we have replications. It is not a prod server

Thank you.

I just spoke with a team here and I think we may have a problem....

They say that if I do a snapshop (involves two databases) and then revert back...

Hello, thank you for the feedback. Yes it is enterprise edition.

Can I create the snapshot using t-sql instead of using GUI?

What about to re-apply or delete the snapshot? can I...

OK. If I understood well your suggestion is:

1) Keep the regular backup jobs ongoing (one per week the full, once per day the dif. and every hour the logs)

2) Before...

Hello. The answer to the question is: this is a test server and what I would like to accomplish is:

1) make a backup of the database before test starts

2) Start...

This is a very valid point. If I will have or not someone using the environemnt to test. Probably yes. I am not sure. Let me try to clarify and...

Hello I cannot develop new things. I need to use SQL Server funcionalities.

This is why it is interesting to understand if I should use snapshot or backups to revert back...

Clear. Thank you very much

Thanks

Sorry. If I use the GUI instead of the sql, will it also automatically assume the change? Or do I have to restart it?

thank you

Separated sql tasks means that each species is executed inside is sql tasks. Task are connect through success arrows ( green arrows). So, exactly as the sp I created,...

ForEach

Hello,

The ssis as a loop also. It is a forearm loop container. It loops the same number of times as the sp.

Also, tests are being executed on the same machine

The ssis package was not done by me. But the for loop that exists in the spring should be fast. Faster then cursor, correct?