473,320 Members | 1,883 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Can someone help me get started on administering MSSQL?

310 100+
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
7 1581
ck9663
2,878 Expert 2GB
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
coolsti
310 100+
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
2,878 Expert 2GB
What version are you using?
Mar 5 '08 #4
coolsti
310 100+
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
2,878 Expert 2GB
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
coolsti
310 100+
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
2,878 Expert 2GB
Good luck. Just post here if you hit a wall.

-- CK
Mar 6 '08 #8

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

Similar topics

11
by: badz | last post by:
Hi frenz Lately I try to use MSSQL and PHP , the problem arise when PHP try to read MSSQL field with 'image' data type, header("Content-type: image/jpeg"); // act as a jpg file to browser I...
7
by: mj | last post by:
Hello, thanks for the help. I am running a WinXP Pro w/ SP2 (my home computer, with ZoneAlarm firewall) Apache 2.0.52 MySQL 4.1.7 PHP 5.1.0-dev I have developed a PHP/MySQL web app that...
1
by: bidalah | last post by:
Hello, I am looking for basic info on installing and using MSDE. I am trying to install and play with MSDE on my PC (Win2000). I finally managed to work my way through installation, and named...
3
by: George | last post by:
VS.NET 2002/VB I would like to begin learning about DB programming, and I'm not quite sure where to start. Before I add MSSQL 2000 to my hosting plan, the question that comes to mind is, how do...
3
by: gharmel | last post by:
I'm trying to get some clues on why I get (much) slower responses from my PHP applications when dealing with a remote sql server as opposed to a local sql server. Here's my situation: Server...
11
by: ralphie | last post by:
hi all since nearly 2 days i fight with mssql and utf-8 as i need to store and retrieve arabic characters. i tried the com approach ...
0
by: Derftics | last post by:
Hi Guys, Is there anyone who have tried installing MSSQL 2000 and MSSQL 2005 servers in one desktop computer? I have tried using MSDE and successfully install the MSSQL 2000 server but when I...
14
by: guswebb | last post by:
Hi. I'm a newbie to PHP and am having a few problems as follows... I have installed PHP successfully on server 1 which is running IIS 6 (W2k3) and hosting multiple sites, some of which connect to...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.