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 you must consider the hardware such as RAID, as the software data block ...

To cut the long story short, during a recent implementation of Cumulative Update 6 and 7 on a particular 'application domain' server we have had major application issues due to a mix up of application code & these SQL cumulative update fixes. Actually this server was not under our support structure that would definetly go ...

Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure. The same methods/process has been completely rebuilt in SQL Server ...

Backup and restore practices are at the core of today's best business continuity plans. While backup and restore provides many benefits, it simultaneously presents a variety of challenges with lost data, the time it takes to restore data, and the costs of restoring lost data.This web seminar will explore SAN copy and replication methodologies, in ...

The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 EditionNotification Contents: New and All Modifications FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server ...

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 the reasons). But one thing is sure that SQL Server 2005 offers a number of ...

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 take care of data which is a prime task for every DBA. Usage of third party tools has been ...

If you have been using the database diagrams from SQL Server 2000 onwards and when it is upgraded to SQL 2005 you might get the following error:  TITLE: Microsoft SQL Server Management Studio------------------------------Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, ...

Say which is better, having multiple transaction log backups files or single transaction log backup file during a recovery point of time. In my experience both of them doesn't make any difference and if you are performing further backup to tape then ensure to test them by restoring on to the standby server. This is a best practices than assuming ...

What if I told you to take your latest production backup, restore it on a different machine and try using the database? Are you comfortable with that task? Do you think it will work? When was the last time you tested your backups? Denis Gobo has listed a best practice blogpost that you need to deploy in order to take care important ...