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

SQL Server- TSQL to see which object reside under which file groups?

Published 24 December 7 4:40 AM | SSQA.net

To continue the FIND-FilegroupFull post on the filegroups, here is the most common question on the forums to get which object reside under which filegroup if there are multiple ones associated: select si.rows as 'Rows', SO.Name as Table, SI.name...

Filed under: sql server, filegroup, tsql, object_name, tablename, files

What is the significance of .TUF file in Log shipping?

Published 12 November 7 12:55 PM | SSQA.net

One of the user has been confused to see lot of .TUF file within their server where the log shipping is enabled. Basically this .tuf file is the T ransaction U ndo F ile, which is created when performing log shipping to a server in Standby mode. So if...

Filed under: sql server, high availability, transaction log, log file, log shipping, files, .tuf