Back to Browse

SQL SERVER - II|| How to set a Database in Read-only?

31 views
Nov 7, 2025
7:29

Reasons for setting Database in Read-Only Mode: 1. Archival Database 2. Reporting Databases 3. Testing Environment 4. Performance Optimization Alter Database (db_name) SET Read_Only WITH No_Wait Alter Database (db_name) SET Read_Write WITH No_Wait

Download

1 formats

Video Formats

360pmp49.2 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

SQL SERVER - II|| How to set a Database in Read-only? | NatokHD