Author: Deepak
-
Replication Components and Agents
Replication Components SQL 2005 replication is based on the Publish and Subscribe metaphor. Let us look at each of the individual components in detail.
-
Upgrading SQL 2005 Evaluation to Enterprise Edition Without Uninstalling
Can we upgrade SQL 2005 Evaluation edition to SQL 2005 Enterprise edition without uninstalling the evaluation edition? This seems to be lingering in the minds of many DBA and hence I thought of explaining it in simple terms. Yes it is possible to perform the operation without uninstalling Trial edition of SQL 2005 prior to…
-
How to Rebuild System Databases in SQL Server 2005
We need to rebuild the system databases if the master database is corrupted or damaged. Let us discuss in detail how to rebuild system databases in SQL server 2005. Step 1: Take a full backup of all the System and User databases prior to rebuilding the system databases as we need to restore it later…
-
Dedicated Administrator Connection
SQL Server 2005 provides a special diagnostic connection for administrators when standard connections to the server are not possible. This diagnostic connection allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests.
-
Types of backup in SQL 2005
One of the most important roles of a DBA is performing regular backups of SQL Server data. Creating backups of critical business data should be one of the foremost concerns of a database administrator (DBA) because backups provide a way to restore data that otherwise could be completely lost. Now let us discuss the types…