It is suggested to place transaction logs on separate physical hard drives. In this manner, data can be recovered up to the second in the event of a media failure. In SQL 2005 When database is created without specifying a transaction log size, the transaction log will be re-sized to 25 percent of the size… Continue Reading...
Source: SQL SERVER – Performance Optimization of SQL Query and FileGroups | Journey to SQL Authority with Pinal Dave
No comments:
Post a Comment