Creating a new database
In order to create
a new database, simply click the Create New Database link and enter the name of
your new database. For example, create a database called Databasejournal, as
shown in Figure D. Once the database is created, you can manage the
objects by choosing the appropriate task, as shown in Figure E.
also view the objects by clicking Server Tools | Databases and choosing the
database that you want to manage objects on. For example, if we click Server
Tools | Databases | Pubs, we can view all the tables by choosing the
appropriate link. Next, we can create a query and execute it for information as
shown. Finally, we can run a quick backup if necessary, as shown in Figure F.
Exporting/importing a new database
importing a database is just as simple as creating a database. Just select
Server Tools | Export/Import and choose the database and objects. Once that is
complete, click Export or Import as shown in Figure G. Remember to save
the file to an appropriate place on your computer.
Creating logins and server roles
You can quickly
create a login by choosing Server Tools | Security and then clicking the
Security icon. Next, choose the Create New Login link on the right side of the
screen (Figure H). You can also add and edit server roles (Figure I)
by choosing the Roles icon.
In the age of 24 x
7 Web sites with no downtime, a DBA often needs a way to perform tasks quickly
when off-site. The SQL Server Web Data Administrator is very powerful and gives
you the ability to do a multitude of things with your SQL Server remotely. I
recommend that you download it and give it a try.
See All Articles by Columnist Steven S. Warren