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
7 1581
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
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
What version are you using?
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
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
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
Good luck. Just post here if you hit a wall.
-- CK
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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
...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
| |