SQL SERVER ADMINISTRATION

Question

SQL SERVER ADMINISTRATION

joemai

Hall of Fame

Points: 3496
More actions
May 25, 2006 at 10:45 am

#115230

Hello Administration World!
I'd just like to ask for some info so that I can propose to my manager. According to the current market, how many databases and how many sqlservers should a DBA can handle without special tools to help?
Is there any tool that can help a DBA to do daily maintenance tasks? I heard of SQLTool. That tool sounds to be a good tool. Does anyone use it?
The reason I'm asking is because I'm the only DBA for a internet company. I have 10 sql servers with 57 databases differents in sizes to maintain. They are from 500M -40GB. My daily task is always full from the bottom to my head. I definitely needs help, but my manager keeps delaying it. Until yesterday, we had a server crash issue. We lost 1 day of data because the backup server was completely run out of spaces.
I don't have MS Exchange to configure SQLMail to inform me when the jobs failed. Is there any other ways to make the SQLMail working without the MAPI profile.
Please help. Any ideas will be deeply appreciate.
An exhauted DBA 🙁
Minh Vu

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 1

As far as mailing goes, I've had some success using XP_SMTP (http://sqldev.net/xp/xpsmtp.htm) instead of SQL Mail. Usually if I have a job with 3 steps, I'll add a 4th step with an xp_smtp call notifying me of job failure. Then I change them like this:

Step 1: On Failure go to Step 4, On Success go to next step

Step 2: On Failure go to Step 4, On Success go to next step

Step 3: On Failure go to Step 4, On Success quit the job reporting success

Jules Bonnot SSCertifiable Points: 5488 More actions · Answer 2

bmail is also a very good tool

http://www.beyondlogic.org/solutions/cmdlinemail/cmdlinemail.htm

use xp_cmdshell to call the tiny exe. As above put it in as a step only reached if the job fails.

www.sql-library.com[/url]

Scott Begin Say Hey Kid Points: 672 More actions · Answer 3

Actually, you can run SQL Mail without Exchange under the following conditions (I've done it):

You have to use Outlook 2000. No other version will work.

You have to configure Outlook when logged in using the same account SQL Server and SQL Server Agent use to start (use the same account to make thing easier).

You have to have your console autologin using the same account as SQL Service is running and stay logged in.

You have to start Outlook when starting the autologin account and leave it running.

You need to select the correct mail profile in SQL Server Agent and restart Agent after setting it.

The biggest problem I have is installing the Outlook Client on the server (most of my SQL databases were set up by outside vendors who don't want other software running on the server) and the security implications of leaving a logged on console.

swede SSCommitted Points: 1773 More actions · Answer 4

We have been sucessful using BLAT (see http://www.blat.net) on SQL7, SQL2000 and SQL2005.

raj-247939 SSCertifiable Points: 5999 More actions · Answer 5

Hi Dear,

DBArtisan is also a good DBA tool.

Start writing SP for ur full Database Backup.Tlog backup on a standby server with good spec.

or Create DBMP and delete the backup enough old to be used.

Being a responsible DBa don't blame ur Manager for Datal Loss.U might get fired on this.

Be carefull in future.

HTH

from

Killer

Stephen Pierce SSC Veteran Points: 251 More actions · Answer 6

> We have been sucessful using BLAT (see http://www.blat.net) on SQL7, SQL2000 and SQL2005

I also use blat and have had great success with it. PLUS... its free.

Also, DBArtisan is a great Administration tool if you can afford it.