By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,685 Members | 1,654 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,685 IT Pros & Developers. It's quick & easy.

Can someone help me get started on administering MSSQL?

100+
P: 310
Hi,

this is quite a newby question. I have years of experiences with administering MySQL databases on Linux using the mysql console application, ini files, and other non-GUI tools.

Now I am given the task to administer the MSSQL databases located on our company's Windows server.

I would like to quickly come up to speed on how this is normally done. Can someone briefly point out what tools are used for administration (for example, scheduling or manually making database backups in order to free up log file space, creating tables, examining table structures, etc.).

I am not asking here for a HowTo, just someone to point me in the right direction of where to locate the various tools available. Tips to good online how to sites, or useful books would also be appreciated.

Thank you very much for any help!

Regards,
Steve, Denmark
Mar 4 '08 #1
Share this Question
Share on Google+
7 Replies


ck9663
Expert 2.5K+
P: 2,878
Hi,

this is quite a newby question. I have years of experiences with administering MySQL databases on Linux using the mysql console application, ini files, and other non-GUI tools.

Now I am given the task to administer the MSSQL databases located on our company's Windows server.

I would like to quickly come up to speed on how this is normally done. Can someone briefly point out what tools are used for administration (for example, scheduling or manually making database backups in order to free up log file space, creating tables, examining table structures, etc.).

I am not asking here for a HowTo, just someone to point me in the right direction of where to locate the various tools available. Tips to good online how to sites, or useful books would also be appreciated.

Thank you very much for any help!

Regards,
Steve, Denmark

All versions of MSSQL comes with a Management Console. You can start using that as your tool. Most of the task you need to do to administer a sql-server can handle it efficiently. For specific requirements, you can just search the net for third party utilities.

-- CK
Mar 4 '08 #2

100+
P: 310
Thanks! Sounds like this Management Console is what I need. Now I just need to find out how it is started up. I assume it can be found somewhere amongst the other MSSQL program files?

Regards,
Steve, Denmark
Mar 5 '08 #3

ck9663
Expert 2.5K+
P: 2,878
What version are you using?
Mar 5 '08 #4

100+
P: 310
As far as I can see, from a readme.txt file located in the folder with the MSSQL files, it is something called MSSQL 2000 server.

I notice there is a tool called "books online" which seems to contain quite a bit of information. I wonder if this is portable so I can move it or access it from another machine? I do not wish to stay logged on very long on our actual company server where this is now located, to avoid any potential accidents or mistakes.

Steve, Denmark
Mar 5 '08 #5

ck9663
Expert 2.5K+
P: 2,878
You can actually install the console on any machine and access your SQL Server (provided, of course, you can access the network). For now, click Start-All Programs-Microsoft SQL Server-Enterprise Manager...

For now, depending on your installation, you might be able to login using your domain user name. If not, you might need to have the necessary authentication information to login.

Good luck.

-- CK
Mar 5 '08 #6

100+
P: 310
Thanks for the help! I should have (somewhere) all the access information, and I certainly can access the server from my office workstation, so I will try to install the console on my PC and connect to the database from there.

Thanks again!

Steve, Denmark
Mar 6 '08 #7

ck9663
Expert 2.5K+
P: 2,878
Good luck. Just post here if you hit a wall.

-- CK
Mar 6 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.