Browse by Tags

SQL Server 2000 and 2005 versions: set databae option Page_Verify Option to CheckSum, to be or not to be?

Published 4 September 8 3:0 AM | SSQA.net

Recently we had a discussion at work place about setting up the PAGE_VERIFY option to CHECKSUM for few databases on one of the SQL Server 2005 instance (dedicated) that is being used extensively by an application that has very limited maintenance window...

Filed under: sql server, blogs, best practices, pages, backups, checksum, dbcc checkdb, Corruption, page_verify

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 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?

Published 29 April 8 5:14 AM | SSQA.net

As a DBA you might be aware that since SQL Server 2005 database maintenace plans have given flexibility in deploying the workflow of tasks required to make sure that your database is optimized, is regularly backed up, and is free of inconsistencies in...

Filed under: sql server, database, dba, blog, best practices, responsibilties, backups, strategy, size