Category: DBA
-
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…
-
Migrating Moving SQL2005 db to SQL2000 db
There are lot of ways by which we can migrate SQL2000 to SQL2005 where we can easily copy SQL2000 databases to SQL2005. While migrating lower to higher version its possible to migrate easily, but in some cases if needed to revert back SQL2000 its a question in everybodys mind that is it possible to do…
-
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…
-
How to Schedule SSIS package
Scheduling a SSIS package is not like scheduling DTS packages in SQL 2000. In SQL 2000, you will move to DTS package and then right click from there you can get the schedule menu, but for SQL 2005 its no more like that. You should schedule the SSIS packages as below.
-
Partitioning
Partitioning is all about dividing of datas to make it faster access either by reading or writing into the table. i.e improving query execution time. Partitioning can be done at Table and Index level. These are the new features in SQL server 2005 and these are supported only at Enterprise and Developer edition. The data…