Browse by Tags

SQL Server databases - checkpoint, cache and I/O request - what you need to know?

Published 22 April 8 1:51 PM | SSQA.net

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...

Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl

SQL Server 2005 Partitioned Tables and Indexes - learning curve

Published 12 March 8 3:1 AM | SSQA.net

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id...

Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse

Relation between SQL Server 2005 and Volume Shadow Copy services?

Published 19 February 8 2:45 AM | SSQA.net

Until last month I was not aware about Volume Shadow Copy and what is the relation between that service & SQL Server services, so here I would like to give the information in this regard that will discuss SQL Server connection issues that you may...

Filed under: sql server, backup, database, disk, best practices, vss, configuration, volume shadow, sqlwriter

SQL 2005 Database Maintenance plan error: Value of 'DD/MM/YYYYHH:MM:SS' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'

Published 9 September 7 3:52 AM | SSQA.net

Here is another common error you will get to see with Database Maintenance plan in SQL Server 2005, though most of it has been resolved with Service Pack 2 and hotfix but still you need to take care few things. Error: Value of 'DD/MM/YYYYHH:MM:SS'...

Filed under: sql server, backup, maintenance plan, database, expiry, reset, value

SQL Server 2005 Maintenance Plan not deleting old backups

Published 7 September 7 3:21 AM | SSQA.net

If you take into account of most Frequently Asked Questions in any SQL community forums, you will get to see problems against database maintenance plans by the users. Personally I don't like them to use (by default) and professionally always depend...

Filed under: sql server, backup, maintenance plan, database, anti-virus, service pack2, directory, exclude

Restore corrupted database - any clause using RESTORE statement?

Published 5 August 7 12:48 PM | SSQA.net

Do you know you can try restore a corrupted database backup using simple clause within RESTORE statement. You may be aware that SQL 2005 version can perform an optional computation a backup checksum on the backup stream; if page-checksum or torn-page...

Filed under: sql server, microsoft, backup, database, corrupted, checksum, clean restore

FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup of a database that is larger than 2 terabytes: "Unable to obtain required information about the server"

Published 28 June 7 12:42 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup...

Filed under: sql server, backup, database, kba, storage

Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the Backup tool: "Restore failed for Server '<ServerName>' (Microsoft.SqlServer.Smo)"

Published 4 June 7 7:28 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the...

Filed under: sql server, restore, backup, ssms, database

Snapshot backups - do I need equivalent database size disk space?

Published 23 May 7 3:17 AM | SSQA.net

Snapshot backups are introduced in SQL Server 2005 version that uses: The underlying backup technology creates an instantaneous copy of the data that is being backed up. The instantaneous copying is typically accomplished by splitting a mirrored set of...

Filed under: sql server, performance, backup, database, disk, space, snapshot