They will not have a schema in the production database. Yes, providing read write access to them in the "sample" or "sandbox" database would have made life a lot easier...

Thank you. The role of the users are developers. I would create a database in the production database server. These users will work on creating tables in that database which...

Just wanted to update.

Scenario was: SQL server agent service account was domain based and same for both instances. The SQL service account was domain based and same for both instances....

@Jeffery

I did come across those articles. However, I have other environments with multi instance where it is the same set up (sql agent uses a domain account and is same...

The owner is sa for the sys policy purge job. The two instances in SQL server uses the same domain account for sql agent. The instance that was create first...

Thank you all!

I think I will have a separate disk for tempdb of each of the instances. But have system databases reside in the drive of the user databases since...

• This reply was modified 3 years, 5 months ago by  noobdba.

Thank you

Thank you! That clarifies a lot. It must have been that there was a new log backup taken by the backup software last time it didn't work for me. Great...

In 2014 environment, when I tried that once it didn't work. In that case, the secondary database showed in "restoring state". I ended up getting rid of the secondary and...

Thank you. I will need to create a test lab to try it. One more question. After step 3 'restore with recovery' is performed we would have two copies of...

Thank you.

so the process would be as below then?

Remove the db from AG.

Delete the db that is in restoring state from secondary.

Add the db from primary into AG which would...

Re-thinking on what you mentioned. So, we have databases that have the service broker disabled on both replicas and also some databases that have it enabled on both replicas.

But I...

Thank you. All the databases show the same value/flag for service broker on both the replicas. Example, databaseA shows 0 on both replicas, and databaseB shows 1 on both replicas.

Thank you. There are only three databases that have service broker set to 0. And its the same value on the primary and the secondary replicas.

It is set to synchronous commit on both. I do not see "target database participating in availability group" at this time. The listener was set up. But after setting that...