Browse by Tags

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

Multiple transaction log backups or Single transaction log backup file, which is better?

Published 27 August 7 4:51 AM | SSQA.net

Say which is better, having multiple transaction log backups files or single transaction log backup file during a recovery point of time. In my experience both of them doesn't make any difference and if you are performing further backup to tape then...

Filed under: sql server, performance, restore, transaction log, multiple, log shipping, single

Get backup and restore performance stats with a DMV

Published 12 June 7 8:25 AM | SSQA.net

Normally the backup and restore operation will be quick enough or depends upon the server configuration to complete. Say if you have started with a 2GB size of database and over the time as that database is updated, the amount of data that is included...

Filed under: sql server, stats, performance, restore, backup, dmv, read