Browse by Tags
All Tags »
sql server »
backup (RSS)
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
Read More...
No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures. Where the
Read More...
Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility
Read More...
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]
Read More...
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
Read More...
I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out
Read More...
Interesting question: how can we know the difference between a native backup and backup taken by third party tool? Say you have started newly in a enterprise wide platform and your task is to find out what methods of BACKUP and RESTORE are followed to
Read More...
How can you copy the database maintenance plans from one SQL Server instance to another SQL Server instance using 2005 version. Using the Database Maintenance plans has been increased since SQL Server 2005 is released, also lot more once Microsoft fixed
Read More...
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' is
Read More...
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 (suggest)
Read More...
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
Read More...
As I have blogged previously that SQL2005BPA is out from CTP now. The BPA for SQL 2005 release in July 2007 is complete package that gathers data from Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations
Read More...
When using SNAPSHOT backups in SQL Server there are few things you need to consider, that included monitoring the disk space usage where the database backups & snapshot files are stored. BOL confirms about SNAPSHOT backups as: The underlying backup
Read More...
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
Read More...
Have you ever wondered you can recover a corrupted database when you have optimum backup & restore strategy in place, well I'm not talking about usage of third party tools or use high-end hardware. With simple backup and restore features in SQL Server
Read More...