Server 2000 Net Send Problem! (Its sort of to do with SQL too..)

onechewy

Hi.

Okay, here's what I'm trying to do..

I backup SQL 2000 everyday, 3 times a day, from Enterprise Manager in Windows Server 2000.

I know SQL can be backed up while people are in the database, but we've had problems before restoring to backups that were done while people were working in the system. SO, for this reason, we boot everyone out of the
application that runs on top of SQL each time I run a backup.

At the moment I'm manually sending a net send message to the domain ordering everyone out, but I want to integrate this into the backup job in Enterprise Manager so I don't have to do anything.

Enterprise manager won't send a regular net send message (I've tried a million different ways to get it to work, and this is the error I always get - A specified logon session does not exist. It may already have been terminated).

So I'm using Fomine Net Send which has command line functionality. I created a batch file sending the required
message and outputted it to a text file to see whats goin on:
__________________________________________________________________

netsend username "test" >> c:\docume~1\Admini~1\Desktop\test.txt
__________________________________________________________________

When it works,the output is:
______________________________________________________________________
Copyright (C) 2007 Fomine Software
All rights reserved.
http://www.winpopup-lan-messenger.com
http://www.fomine.com

Initialization.......Ok
Parse command line...Warning
Messenger was not specified, the Net Send GUI is messenger by default.
Sending message......Ok

Report:
username,
_______________________________________________________________________

But when I try to call the batch file from Enterprise Manager, I get the following error:

___________________________________________________________________________
Initialization.......Ok
Parse command line...Warning
Messenger was not specified, the Net Send GUI is messenger by default.
Sending message......Failed
Messenger not found.
___________________________________________________________________________

Just to mix it up a bit... my batch file just randomnly stops working and I get the same error as above...

BUT, double-clicking a desktop batch file with a net send (as opposed to netsend, the Fomine exe) command works perfectly.

Do you think maybe it's an application problem or is it Windows not liking what I'm doing?

All I want is an automated message that will tell everyone to get out of an application just before the backup starts... it can't be that hard!!

This is incredibly annoying, and confusing, and my head is completely wrecked so any help, much appreciated!!

onechewy

¬_¬

matt-dublin

you should be able to add a batch script to the backup.

or you could try:

cmd.exe "netsend username test >> c:\docume~1\Admini~1\Desktop\test.txt"

but remember, if your users are using xp, the message won't get through to them as the messenger service is disabled by default.

You should also be able to configure the backup software to send an SMTP email.