Browse by Tags

Script to perform database backup, restore and optimization tasks without maintenance plans - SQL Server 2008

Published 29 September 8 2:15 AM | SqlServer-QA.net

In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans? blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking...

Filed under: sql server, restore, database, dba, backups, task, new features, scripting

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

List of modified Knowledge Base articles in SQL Server 2005 Enterprise X64 Edition

Published 16 November 7 5:14 PM | SSQA.net

The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A gradual...

Filed under: sql server, restore, database, kba, service pack2, x64, backups, modified