The Running of Microsoft SQL Server Enterprise Manager is very straightforward activity that is very common for many database administrators and the developers that are using Microsoft SQL Server 2000. Enterprise Manager is a tool which is included with the SQL Server 2000 to maintain and manage SQL Server databases. While this tool can also be used for writing and executing SQL queries and it is well known that this task suits better to it’s “sister” application known as Query Analyzer.
Step by step procedure to run Microsoft SQL Server Enterprise Managerfor many database administrator and developers using Microsoft SQL Server 2000:
Let suppose the Enterprise Manager is not installed on your computer, so first you have to install it using Microsoft SQL Server 2000 setup program which is found on SQL Server 2000 CD or file can be found inside the cd from its installation files. The package “Client Tools” includes Enterprise Manager. It’s not necessary to install whole database engine to your PC in order to run the Enterprise Manager. After this you have to run the Enterprise Manager from Start Menu of your computer or you can run it within Computer Management. Now you have to register one or more than one servers in the Enterprise Manager so that it can keep track of SQL Servers and make it available for quick access for different servers. You can do this by just right-clicking on your Microsoft SQL Servers item in left tree view and then choosing the “New SQL Server Registration…”
After you perform the step, Database should be created. For this you have to expand a registered server to show Databases folder. Now right-click on the databases and then click on “New Database…” then provide a name for database. Optionally, if you wish to do all this process manually then you have to specify the location and the size of database, then click on “Data Files” tab and enter file information. Now you have to create DTS Packages. To create a DTS package you have to expand a registered server, so that the Data Transformation Services folder is shown. Now right-click on Data Transformation Services folder and then click on “New Package…” Now by using the DTS package editor you have to design a process using visual programmatic elements on left toolbar.
Another thing you have to do after the above step is to take back Up of Database. To take the back up you have to right-click on a database and then click on “All Tasks” and then on “Backup Database…” after that you have to provide a name for backup. Naming your database will help you to identify your backup later. Now you have to choose whether you want a complete, transaction log, incremental or specific file/file group backup. A complete backup will make a back up of all data in the database. Now click “Add…” button to add your backup to your desired destination and then enter a filename for the backup. Now, finally you have to click “OK” to begin the backup.
This is how we can run the Microsoft SQL Server Enterprise Manager for many database administrator and developers using Microsoft SQL Server 2000.