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 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

A tape device is not detected by SQL Server Management Studio in SQL Server 2005 or by SQL Server Enterprise Manager in SQL Server 2000

Published 12 June 8 2:1 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New A tape device is not detected by SQL Server Management Studio in...

Filed under: sql server, kba, management studio, backups, enterprise manager, tape

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

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!

Published 25 January 8 3:41 AM | SSQA.net

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...

Filed under: sql server, performance, indexes, cache, users, tsql, best practice, backups, create, online, monitoring, operating system, busy, creation

SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?

Published 19 December 7 6:6 AM | SSQA.net

How do you define the terms "Performance Monitoring"? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes'...

Filed under: dashboard, sql server, performance, databases, microsoft, security, blog, environment, best practice, backups, monitoring, baseline, benchmarking, downloads, performance monitoring

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

New feature in SQL Server 2008 - compression how it works?

Published 3 October 7 9:42 AM | SSQA.net

Since the release of SQL Server 2008 (last 2 CTPs) users are anxiously awaiting for data compression feature, so how it is handled in this version and what it does, is it a good thing? Data compression enables you to store your data more effectively and...

Filed under: sql server, microsoft, team, features, 2008, development, data capture, compression, backups, FAQ

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!

Published 20 September 7 10:40 AM | SSQA.net

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations...

Filed under: sql server, performance, databases, blogs, blocking, query, kba, cpu, execution plan, backups, resources, high cpu, FAQ

FIX: In a maintenance plan, the databases that you selected are no longer selected when you edit a Back Up Database task in SQL Server 2005 Service Pack 2

Published 19 September 7 5:23 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, database, plan, kba, maintenance, service pack2, backups

FIX: Error message when you run a maintenance plan that contains a Back Up Database task in Microsoft SQL Server 2005 Service Pack 2: "0x80004003: Object reference not set to an instance of an object"

Published 19 September 7 11:58 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, kba, service pack2, object, database mirroring, backups, exception

FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: "Msg 3456, Level 16, State 1, Line 1. Could not redo log record"

Published 12 September 7 12:28 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you restore a transaction-log backup that is generated...

Filed under: sql server, transaction log, kba, log, backups, knowledgebase, redo

Description of disaster recovery options for Microsoft SQL Server

Published 8 September 7 4:16 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications Description of disaster recovery options for Microsoft SQL Server http://support...

Filed under: sql server, kba, disaster recovery, options, backups

The following KBA pages were recently modified - SQL Server 2005 webcasts

Published 27 August 7 6:17 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Support WebCast: How to use the DataReader...

Filed under: sql server, webcast, kba, oledb, database mirroring, backups, overview, datareader