Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
sha1023012
Starting Member
4 Posts |
Posted - 2013-03-06 : 20:40:28
|
Hello everyone I am learning how to restore a database. I am being ask to verify that you can read the data but not modify it and Verify that the departments that were added are missing from the database. This is my second attempt to do the restore I dont know if I type something in wrong the last time so my question is what would be the codes to do the verify so I am not putting the restore in an online mode cause thats what I think i did the last time.Thanks |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-03-07 : 01:00:12
|
[code]ALTER DATABASE <db name> SET READ_ONLY;[/code] |
|
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2013-03-07 : 01:34:29
|
Hi,Give Read only access to the user. if you give read only access to databse then no one can modify the data. if you want to restrict data to be modified for particular user then you have set at access level. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-03-07 : 06:21:40
|
Once you restore the database, then execute the statment Russell mentioned. That will turn that database to be only in ReadOnly mode.CheersMIK |
|
|
|
|
|