InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 14:25:04 GMT20http://www.sqlservercentral.com/Forums/Topic1392760-1550-1.aspxThanks much, that helpsThu, 06 Dec 2012 12:29:48 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1392760-1550-1.aspx[quote][b]sqlfriends (12/5/2012)[/b][hr]So if a database is set to read only , and by just querying the database, it won't create any log transactions, so no affect on log file, is that correct?[/quote]Selects are never logged, in any recovery model in any database setting. Database changes are what are logged. A read only database can't be changed and hence won't get any log records.Thu, 06 Dec 2012 01:52:43 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1392760-1550-1.aspx[quote][b]sqlfriends (12/5/2012)[/b][hr]So if a database is set to read only , and by just querying the database, it won't create any log transactions, so no affect on log file, is that correct?Thanks,[/quote]That is correct. You can confirm that using fn_dblog(null,null).USE [master]GOALTER DATABASE [DBA_Rep] SET READ_ONLY WITH ROLLBACK IMMEDIATEGOSELECT * FROM fn_dblog(null,null)Returned 3 transaction log records in my development environmentSELECT * FROM dbo.Backup_HistorySELECT * FROM fn_dblog(null,null)Returned the same 3 transaction log recordsWed, 05 Dec 2012 16:30:25 GMTGeorge M Parkerhttp://www.sqlservercentral.com/Forums/Topic1392760-1550-1.aspxSo if a database is set to read only , and by just querying the database, it won't create any log transactions, so no affect on log file, is that correct?Thanks,Wed, 05 Dec 2012 16:17:45 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1392760-1550-1.aspx[quote][b]sqlfriends (12/4/2012)[/b][hr]If a database is setup to readonly. Will the log file grow or not?thanks[/quote] NO [quote][b]sqlfriends (12/4/2012)[/b][hr]If a database is setup in simple recovery mode.Will the log file grow or not?thanks[/quote] YesWed, 05 Dec 2012 03:21:51 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1392760-1550-1.aspxIt shouldn't since you can't run insert, update, or delete statements. In addition you can't update the statistics or reorganize or rebuild indexes.Tue, 04 Dec 2012 18:48:13 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1392760-1550-1.aspxIf a database is setup to readonly and in simple recovery mode.Will the log file grow or not?thanksTue, 04 Dec 2012 18:30:26 GMTsqlfriends