over 5 years ago
Databases whose data is not required to be changed should be considered to be set as READ ONLY.Databases can be set to READ ONLY mode and back using T-SQL and SSMS.
Following are the scripts that can be used to set database read only and back:
---Make Database Read Only
ALTER DATABASE [DBNAME] SET READ_ONLY WITH NO_WAIT
---Make Database Read/Write
ALTER DATABASE [DBNAME] SET READ_WRITE WITH NO_WAIT
Once a database is changed to READ ONLY nothing can change in it.So certain changes should be made to optimize the performance of a READ ONLY database.
1) Permissions cannot be edited from a READ ONLY database.
2) Users cannot be added or removed from a READ ONLY database
3) Statistics will not be automatically updated (not required) and you would not be able to update statistics of a READ ONLY database
4) READ ONLY databases will not shrink automatically neither manually
5) You cannot create indexes on a READ ONLY database.
6) You cannot defragment indexes of a READ ONLY database
Hence we should complete such tasks before we set the database to READ ONLY mode.
We can verify the READ ONLY state of database by using the below query where a value of 1 corresponds to READ ONLY state.
SELECT name, is_read_only
WHERE name = 'DBName'
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using