Beginners Question

[fdservices]

I ask this here because I know absolutely nothing about MSSQL.

I recently uninstalled McAfee from our Windows SBS 2003 (with MSSQL Express) server and it in turn uninstalled it's EPOSERVER MSSQL service.

As a result of this, apparently, the Accounts software ceased to run.

I assume that in some way the Accounts software had been installed and linked to the EPOSERVER instance instead of creating its own instance. Could this be a correct assumption I wonder?

Also, I understand that Express holds all its data in one .msf file. Can I therefore simply backup the one file, as Wikipedia suggests, or do I need to do a "proper" sql backup?

Andrew

 

[bborissov]

No software can create INSTANCE of SQL Server. That could be don ONLY during the installation of SQL Server.
Also SQL Server databases have MDF extension.
You should check your accounting software if it has some setting where it should look for its databases. Also if the Database is installed for one instance tit can't be used in another. You should Detach it first (if that instance of SQL Server is running) and attach it back in the instance you want.

Also HOW the F...g anti virus will stop SQL Server Service?
You should report that immediately to McAfee!!!!
That is very dangerous if it is true. Can you imagine what will happen if McAfee stops SQL Server service in some Bank?
(no, you can't )))


Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[philhege]

Oh, I could, in my worst nightmares.

Phil H.
Some Bank
-----------
Time's fun when you're having flies.

 

[philhege]

Try stopping MSDTC and see what happens ;^).

Methinks there's a service dependency chain in there somewhere.

Phil H.
Some Bank
-----------
Time's fun when you're having flies.

 

[fdservices]

Wow lightening response - thanks

I realise my terminology is wrong, because I do not knwo what I am talking about, but I see in a VBS script file the libe
SERVER = access, and I find in a MSSQL set up page some aliases being Eposerver and Access, so I assume that these aliases are some sort of "hook" into the SQL server, and that using Eposerver, which is the McAfee "hook" was a bad idea, whereas using Access, which is a different "hook" was a better idea. Total rubbish?

If I had time to list all the McAfee problems then I would not have time for anything else. I simply bin it whenever I find it!

Andrew