Category: DBA
-
How Database Snapshot Works
Its essential that a DBA understands what happens when a snapshot is created. The following process happens, Database snapshots operate at the data-page level. Before a page of the source database is modified for the first time, the original page is copied from the source database to the snapshot. This process is called a copy-on-write…
-
Database Snapshot
What is a Database Snapshot? * The Database Snapshot is a new feature that is available in Enterprise edition of SQL Server 2005. * It provides a read-only, static view of a database. * Multiple snapshots can exist for a single database on the same server instance as the database.
-
Moving System Databases — SQL Server 2000
Introduction: There are lots of articles, Links and sites that describe how to move system databases from the SQL default location to the location described by the DBA but still lot of users find difficult while moving them and land up in trouble. So I thought that I would just do a graphical way of…
-
Installing SQL Server 2005
Before we begin the installation, login into the server with admin rights. 1.) Insert the SQL server CD DVD and wait for auto-menu to popup.
-
How to use Upgrade Advisor
Using Upgrade Advisor This section will provide you a brief about How to upgrade advisor 1.) Go to Start –> All Programs –> Microsoft SQL Server 2005 –> SQL Server 2005 Upgrade Advisor, open upgrade advisor