0

We have installed SQL Server 2017 in 2 servers. Then created 2 databases same way in both servers. In one server I see my database snapshot isolation level is ON and another server its OFF.

enter image description here

enter image description here

So, how can I check/change isolation level at server/instance level, so that whenever we create new databases then result should be same?

Improve this question
3
  • Should be inherited from model AFAIK. Though top picture doesn't look like that. When you say "created 2 databases same way" what was that way?
    – Martin Smith
    Aug 15 at 7:17
  • Right click on database and CREATE new database and then overwrite the database with a backup
    – Imran Qadir Baksh - Baloch
    Aug 15 at 7:19
  • What risk should I have to update both DB to use snapshot level as DBs are recently created?
    – Imran Qadir Baksh - Baloch
    Aug 15 at 7:32

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.