files, performance - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

SQL Server data and log files initialization, think multiple files, backup & restore performance! Published 25 July 8 6:1 AM | SSQA.net: Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization...

Filed under: sql server, performance, restore, best practices, multiple, filegroup, backups, disks, throughput, files, tapes

SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)