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
    Commented Aug 15, 2023 at 7:17
  • Right click on database and CREATE new database and then overwrite the database with a backup
    – Imran Qadir Baksh - Baloch
    Commented Aug 15, 2023 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
    Commented Aug 15, 2023 at 7:32

0

Reset to default

Your Answer

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