Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

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

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 22 2008
Filed under: 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

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Mar 12 2008
Filed under: 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?

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Feb 19 2008
Filed under: 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'

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Sep 9 2007
Filed under: Filed under: sql server, backup, maintenance plan, database, expiry, reset, value
SQL Server 2005 Maintenance Plan not deleting old backups

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Sep 7 2007
Filed under: Filed under: sql server, backup, maintenance plan, database, anti-virus, service pack2, directory, exclude
Restore corrupted database - any clause using RESTORE statement?

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Aug 5 2007
Filed under: 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"

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 28 2007
Filed under: 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)"

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jun 4 2007
Filed under: Filed under: sql server, restore, backup, ssms, database
Snapshot backups - do I need equivalent database size disk space?

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, May 23 2007
Filed under: Filed under: sql server, performance, backup, database, disk, space, snapshot

Page 1 of 1 (9 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.