sqlfriends (12/5/2012)
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,
That is correct. You can confirm that using fn_dblog(null,null).
USE [master]
GO
ALTER DATABASE [DBA_Rep] SET READ_ONLY WITH ROLLBACK IMMEDIATE
GO
SELECT * FROM fn_dblog(null,null)
Returned 3 transaction log records in my development environment
SELECT * FROM dbo.Backup_History
SELECT * FROM fn_dblog(null,null)
Returned the same 3 transaction log records