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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-07-03 : 10:32:09
|
This article discusses creating read-only databases to improve performance throughput. This can be especially handy in a web environment where many users want to view information.
Article Link. |
|
|
BSovers
Starting Member
1 Post |
Posted - 2009-06-04 : 18:59:17
|
| If a database is readonly, and nothing is logged, then why does it need an .LDF file?Bob SoversDatabase Professional |
 |
|
|
guerven
Starting Member
1 Post |
Posted - 2009-09-22 : 05:53:13
|
| "if you go one step farther and actually make the database files read-only you can back up the database without shutting SQL Server down while the files are in use"I tried to copy the files while they are in use. I got this messageCannot Copy <DB>: It is being used by another person or program.I guess we can expect a production database to be pretty busy. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-22 : 07:53:20
|
| Backing up a database is not the same thing as copying the data files. See "BACKUP DATABASE" in Books Online. |
|
|
|
|
|
|
Article: SQL Server and Read-Only Databases