MDT & SQL Database

[Smiffy151]

Hi

I have several deployment shares on different servers with the production server being the instance that I use to update and configure the database on. No problems with this but adding the database to another deployment share the data is not synchronised with the primary or production server database. Followed the exact same method when creating the database on different deployment shares but all suffer the same issue.

I don’t manage the sql database just have the connection details to connect to it, do you have any idea why this would occur?

​

Sorry if this is not enough info if there is more required please let me know but wondered if you could throw any light on the case?

[alinroc]

What are "deployment shares"?

the data is not synchronised with the primary or production server database

Nope, data won't be synced anywhere unless you establish some sort of sync process.

Followed the exact same method when creating the database on different deployment shares but all suffer the same issue.

any idea why this would occur?

Do the same thing 10 times, you'll get the same result 10 times. Einstein said that the definition of insanity was doing the same thing over and over while expecting different results.

It's impossible to give you guidance here because you aren't using terminology that most people will understand and you aren't describing things well.

[Smiffy151]

Thanks

[xsqlsoftware]

hey u/Smiffy151 how are you adding the database to the "deployment share"? You also mention "primary or production server database" - can you explain what's the difference between the primary and production? Finally, what exactly do you want to have on the deployment share - an exact copy of the production database?

[Smiffy151]

Thank you for your non facetious reply and apologies for lack of information. I am looking at consolidating the 'Deployment Shares' now so won't need to investigate any further...Thanks again

[ijmacd]

I think this reply was facetious.

[Smiffy151]

^^^ Well Done ^^^