Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: SQL Server and Read-Only Databases

Author  Topic 

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.

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 Sovers
Database Professional
Go to Top of Page

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 message

Cannot Copy <DB>: It is being used by another person or program.

I guess we can expect a production database to be pretty busy.
Go to Top of Page

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.
Go to Top of Page

- Advertisement -