Hi peoples...
I am a total newbie when it comes to SQL databases.
I currently work for a company developing software. We use a VB Development environment and connect to Dbase III database files using DAO... ewwwww...
We are looking to upgrade our development environment to VB.net and our database to either MSSQL or mySQL...
My question is - most of our users are on standalone machines. Our software is NOT internet based, nor do we want it that way at the moment.
Is there a way to connect to a MSSQL database (ie the .mdf file) without having a server running? Or are we better advised to stick to an MS Access database if this is the case...
Basically the reasoning behind upgrading is better speed and record locking. Any advice would be greatly appreciated.
I am sorry to sound so dumb...
Cheers,
KevMicrosoft offers MSDE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdeforvs.asp), the Microsoft Data Engine, which sounds like exactly what you need.
MSDE is a "workstation sized" version of Microsoft SQL Server. It offers a version of the database engine that is limited to 2 Gb per database, and is configured to run on a workstation (so it is missing a few of the really "high end" database features), that is 100% upward compatible with Microsoft SQL Server. It allows the developer to create databases that work on the desktop, can be scaled up to a few users (about 5) without any additional cost to either the developer or the user, and allow easy migration to SQL Server for larger groups of users.
While MSDE may not have the high end features such as clustering, replication management, etc., it IS a full blooded version of SQL Server. From the code perspective, it is almost impossible to tell MSDE from any other version of SQL Server. As your users needs grow, MSDE allows a quick and simple upgrade path to full-blown SQL Server. In almost every case I've seen, MSDE offers the best of both worlds... It is cheap and easy to start with, and can grow to support really large projects when necessary.
-PatP|||Thanks for that... so with MSDE, we would get 1 datafile containing all our tables that wouldn't need any software on the users machine?
Out of interest, what would the file extension be?|||You will need to install MSDE on your machine (and install it with your software), and you get at least two files, an MDF with the actual data and an LDF with the log.
The MSDE software is available to Visual Studio Professional (and above) developers, and a license to distribute it as part of an application that you develop is included with Visual Studio. Think of MSDE as part of the Visual Studio runtime environment.
Check out the link to the article from my previous posting. I think that article gives the "30,000 foot view" of MSDE and the distribution model. The whole process really isn't very complex, although you need to think on a bit broader scale than you did with dBase files. Once you make the jump, you'll never want to go back!
-PatP|||I have just tried installing MSDE - when I double click the setup file, it says it can't install because I don't have a "strongpassword" on SAPWD... I go to the knowledgebase article they reference for help on this and do what is says, it says to enter oSQL -U sa at the command prompt and it says oSQL isn't recognised as internal or external command etc etc...
I hate Microsoft.. I truly do|||Check here (http://support.microsoft.com/default.aspx?scid=kb;en-us;814463) for help with strong sa passwords from within code. As a general rule of thumb, just use a license plate or pick a sentence that you'll remember and take the first or last letter from each word to make a strong password.
-PatP|||Hi again Pat...
Ok, I am running windows xp professional... I have downloaded the MSDE file and doubleclicked setup... when I do, it comes up with an error... that link you gave me was about setting with password once it has been installed... from what I could see anyway..|||Hi,
What is the error message? And one more information, at default when u install .NET there is a option to install MSDB (stand alone database). Have u installed .NET?|||No, I have not installed .net.
I am still running VB6 as my development environment... I want to test the options available to me before I make my final decision.sqlsql
Showing posts with label software. Show all posts
Showing posts with label software. Show all posts
Tuesday, 20 March 2012
Saturday, 25 February 2012
Confused about MSDE installation
I needed to distribute the MSDE components to the computers that use my
software so I decided to build a setup program using InstallShield that
included the MSDE files.
After I ran the installation, I noticed that the setup created a folder on
my computer using the MSDE instance name I told the setup program to used
prefixed by a "$" character. So the folder created for an instance named
such as MACHOGRANDE was "C:\Program Files\Microsoft SQL
Server\MSSQL$MACHOGRANDE"
After noticing that, I went on to explore this folder and notice that it had
a bunch of files in it, I was surprised to see that one of the files was
named sqlservr.exe! It almost looked like the installation of my MSDE
instance was like a totally independent sql server installation! Like if it
had nothing to do with the other MSDE instance I had running. I doubt this
is the case since I am pretty sure there must be a gazzilion other files
installed on the computer that are sheared by all the database that use the
MSDE engine.
So my question is,
1. Why did the instance of MSDE crated all of this extra files (such as
sqlservr.exe)? Instead of simply created the ldf and mdf files like a
regular SQL server database? Aren't the MSDE and SQL server supposed to be
the same thing?
2. Also is there a special reason for the "$" character"?
ThanksRene,
what happened is actually exactly what should happen. If you install a
new (named)instance it will always be installed in a folder like
MSSQL$Instancename. It doesn't even matter if you use MSDE or any other
SQL Server edition. A new instance includes it's own sqlserver.exe and
is basically a new installation of the SQL Server engine.
If you just wanted to add a new database you could have done so in your
existing SQLServer installation.
>2. Also is there a special reason for the "$" character"?
I have no idea why MS uses $, probably someone at MS thought this makes
it easier to see that your dealing with a named instance.
M|||Thanks Markus,
If you don't mind, could you tell me if MSDE suffers from the same security
issues as the regular SQL Server?
For example, if a security vulnerability was found in SQL Server where the
server could be exploited by a hacker from the Internet, will I also have
the same problem with the MSDE instance? Or do MSDE instances only run
locally therefore its immune to those types of attacks?
Thanks.
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1126682536.660588.222940@.f14g2000cwb.googlegroups.com...
> Rene,
> what happened is actually exactly what should happen. If you install a
> new (named)instance it will always be installed in a folder like
> MSSQL$Instancename. It doesn't even matter if you use MSDE or any other
> SQL Server edition. A new instance includes it's own sqlserver.exe and
> is basically a new installation of the SQL Server engine.
> If you just wanted to add a new database you could have done so in your
> existing SQLServer installation.
>>2. Also is there a special reason for the "$" character"?
> I have no idea why MS uses $, probably someone at MS thought this makes
> it easier to see that your dealing with a named instance.
> M
>|||Hi Rene,
Welcome to use MSDN Managed Newsgroup!
I have noticed you posted a duplicated post in the
microsoft.public.sqlserver.msde. To keep the integrity of newsgroup, I will
reply and follow up in that post. Thank you for your patience and
cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Rene" <nospam@.nospam.com> wrote in message
news:O73fJRQuFHA.3452@.TK2MSFTNGP14.phx.gbl...
> Thanks Markus,
> If you don't mind, could you tell me if MSDE suffers from the same
> security issues as the regular SQL Server?
> For example, if a security vulnerability was found in SQL Server where the
> server could be exploited by a hacker from the Internet, will I also have
> the same problem with the MSDE instance? Or do MSDE instances only run
> locally therefore its immune to those types of attacks?
>
MSDE is SQL Server, but in order to reduce the possibility that widely
dispersed MSDE machines could be vulnerable to a network attack, network
connectivity is off my default in MSDE (and its sucessor SQL 2005 Express
Edition).
See
http://support.microsoft.com/?kbid=814130#XSLTH5167121121120121120120
David
software so I decided to build a setup program using InstallShield that
included the MSDE files.
After I ran the installation, I noticed that the setup created a folder on
my computer using the MSDE instance name I told the setup program to used
prefixed by a "$" character. So the folder created for an instance named
such as MACHOGRANDE was "C:\Program Files\Microsoft SQL
Server\MSSQL$MACHOGRANDE"
After noticing that, I went on to explore this folder and notice that it had
a bunch of files in it, I was surprised to see that one of the files was
named sqlservr.exe! It almost looked like the installation of my MSDE
instance was like a totally independent sql server installation! Like if it
had nothing to do with the other MSDE instance I had running. I doubt this
is the case since I am pretty sure there must be a gazzilion other files
installed on the computer that are sheared by all the database that use the
MSDE engine.
So my question is,
1. Why did the instance of MSDE crated all of this extra files (such as
sqlservr.exe)? Instead of simply created the ldf and mdf files like a
regular SQL server database? Aren't the MSDE and SQL server supposed to be
the same thing?
2. Also is there a special reason for the "$" character"?
ThanksRene,
what happened is actually exactly what should happen. If you install a
new (named)instance it will always be installed in a folder like
MSSQL$Instancename. It doesn't even matter if you use MSDE or any other
SQL Server edition. A new instance includes it's own sqlserver.exe and
is basically a new installation of the SQL Server engine.
If you just wanted to add a new database you could have done so in your
existing SQLServer installation.
>2. Also is there a special reason for the "$" character"?
I have no idea why MS uses $, probably someone at MS thought this makes
it easier to see that your dealing with a named instance.
M|||Thanks Markus,
If you don't mind, could you tell me if MSDE suffers from the same security
issues as the regular SQL Server?
For example, if a security vulnerability was found in SQL Server where the
server could be exploited by a hacker from the Internet, will I also have
the same problem with the MSDE instance? Or do MSDE instances only run
locally therefore its immune to those types of attacks?
Thanks.
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1126682536.660588.222940@.f14g2000cwb.googlegroups.com...
> Rene,
> what happened is actually exactly what should happen. If you install a
> new (named)instance it will always be installed in a folder like
> MSSQL$Instancename. It doesn't even matter if you use MSDE or any other
> SQL Server edition. A new instance includes it's own sqlserver.exe and
> is basically a new installation of the SQL Server engine.
> If you just wanted to add a new database you could have done so in your
> existing SQLServer installation.
>>2. Also is there a special reason for the "$" character"?
> I have no idea why MS uses $, probably someone at MS thought this makes
> it easier to see that your dealing with a named instance.
> M
>|||Hi Rene,
Welcome to use MSDN Managed Newsgroup!
I have noticed you posted a duplicated post in the
microsoft.public.sqlserver.msde. To keep the integrity of newsgroup, I will
reply and follow up in that post. Thank you for your patience and
cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Rene" <nospam@.nospam.com> wrote in message
news:O73fJRQuFHA.3452@.TK2MSFTNGP14.phx.gbl...
> Thanks Markus,
> If you don't mind, could you tell me if MSDE suffers from the same
> security issues as the regular SQL Server?
> For example, if a security vulnerability was found in SQL Server where the
> server could be exploited by a hacker from the Internet, will I also have
> the same problem with the MSDE instance? Or do MSDE instances only run
> locally therefore its immune to those types of attacks?
>
MSDE is SQL Server, but in order to reduce the possibility that widely
dispersed MSDE machines could be vulnerable to a network attack, network
connectivity is off my default in MSDE (and its sucessor SQL 2005 Express
Edition).
See
http://support.microsoft.com/?kbid=814130#XSLTH5167121121120121120120
David
Sunday, 12 February 2012
configuring antivirus protection
i'm about to install a file antivirus software on my sql
standard 2000. anybody have any suggestions or
recommendations on how i should go about configuring
this? are there any folders specific to sql that i should
stay away from? please let me know. your help is very
much appreciated.
thanks a lot in advance,
ed
Hi
Check out:
http://support.microsoft.com/default...;en-us;q309422
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
> i'm about to install a file antivirus software on my sql
> standard 2000. anybody have any suggestions or
> recommendations on how i should go about configuring
> this? are there any folders specific to sql that i should
> stay away from? please let me know. your help is very
> much appreciated.
> thanks a lot in advance,
> ed
|||hi john,
thanks!! i've actually seen this already. i have basic
knowledge of sql and i was hoping to find something that
tells what folder are that are related to sql that i
should stay away from or should i just do a scan and just
exclude the files with the suffix extension mentioned in
this article? please let me know...
thanks,
ed
>--Original Message--
>Hi
>Check out:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q309422
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
sql[vbcol=seagreen]
should
>
>.
>
|||Hi
Doing a scan may produce some files with the extension although this may
include files that are miss-named
Running something like the following command in Query Analyser should show
the file being used:
EXEC master..sp_MSForEachdb 'SELECT filename FROM ?..sysfiles'
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1f84e01c45879$c30c8040$a601280a@.phx.gbl...[vbcol=seagreen]
> hi john,
> thanks!! i've actually seen this already. i have basic
> knowledge of sql and i was hoping to find something that
> tells what folder are that are related to sql that i
> should stay away from or should i just do a scan and just
> exclude the files with the suffix extension mentioned in
> this article? please let me know...
> thanks,
> ed
> us;q309422
> message
> sql
> should
|||thanks!!!
-ed
>--Original Message--
>Hi
>Doing a scan may produce some files with the extension
although this may
>include files that are miss-named
>Running something like the following command in Query
Analyser should show
>the file being used:
>EXEC master..sp_MSForEachdb 'SELECT filename
FROM ?..sysfiles'
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1f84e01c45879$c30c8040$a601280a@.phx.gbl...
that[vbcol=seagreen]
just[vbcol=seagreen]
in[vbcol=seagreen]
very
>
>.
>
standard 2000. anybody have any suggestions or
recommendations on how i should go about configuring
this? are there any folders specific to sql that i should
stay away from? please let me know. your help is very
much appreciated.
thanks a lot in advance,
ed
Hi
Check out:
http://support.microsoft.com/default...;en-us;q309422
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
> i'm about to install a file antivirus software on my sql
> standard 2000. anybody have any suggestions or
> recommendations on how i should go about configuring
> this? are there any folders specific to sql that i should
> stay away from? please let me know. your help is very
> much appreciated.
> thanks a lot in advance,
> ed
|||hi john,
thanks!! i've actually seen this already. i have basic
knowledge of sql and i was hoping to find something that
tells what folder are that are related to sql that i
should stay away from or should i just do a scan and just
exclude the files with the suffix extension mentioned in
this article? please let me know...
thanks,
ed
>--Original Message--
>Hi
>Check out:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q309422
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
sql[vbcol=seagreen]
should
>
>.
>
|||Hi
Doing a scan may produce some files with the extension although this may
include files that are miss-named
Running something like the following command in Query Analyser should show
the file being used:
EXEC master..sp_MSForEachdb 'SELECT filename FROM ?..sysfiles'
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1f84e01c45879$c30c8040$a601280a@.phx.gbl...[vbcol=seagreen]
> hi john,
> thanks!! i've actually seen this already. i have basic
> knowledge of sql and i was hoping to find something that
> tells what folder are that are related to sql that i
> should stay away from or should i just do a scan and just
> exclude the files with the suffix extension mentioned in
> this article? please let me know...
> thanks,
> ed
> us;q309422
> message
> sql
> should
|||thanks!!!
-ed
>--Original Message--
>Hi
>Doing a scan may produce some files with the extension
although this may
>include files that are miss-named
>Running something like the following command in Query
Analyser should show
>the file being used:
>EXEC master..sp_MSForEachdb 'SELECT filename
FROM ?..sysfiles'
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1f84e01c45879$c30c8040$a601280a@.phx.gbl...
that[vbcol=seagreen]
just[vbcol=seagreen]
in[vbcol=seagreen]
very
>
>.
>
configuring antivirus protection
i'm about to install a file antivirus software on my sql
standard 2000. anybody have any suggestions or
recommendations on how i should go about configuring
this? are there any folders specific to sql that i should
stay away from? please let me know. your help is very
much appreciated.
thanks a lot in advance,
edHi
Check out:
http://support.microsoft.com/defaul...b;en-us;q309422
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1fdf001c45870$2bbb8eb0$a401280a@.phx
.gbl...
> i'm about to install a file antivirus software on my sql
> standard 2000. anybody have any suggestions or
> recommendations on how i should go about configuring
> this? are there any folders specific to sql that i should
> stay away from? please let me know. your help is very
> much appreciated.
> thanks a lot in advance,
> ed|||hi john,
thanks!! i've actually seen this already. i have basic
knowledge of sql and i was hoping to find something that
tells what folder are that are related to sql that i
should stay away from or should i just do a scan and just
exclude the files with the suffix extension mentioned in
this article? please let me know...
thanks,
ed
>--Original Message--
>Hi
>Check out:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q309422
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1fdf001c45870$2bbb8eb0$a401280a@.phx
.gbl...
sql[vbcol=seagreen]
should[vbcol=seagreen]
>
>.
>|||Hi
Doing a scan may produce some files with the extension although this may
include files that are miss-named
Running something like the following command in Query Analyser should show
the file being used:
EXEC master..sp_MSForEachdb 'SELECT filename FROM ?..sysfiles'
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1f84e01c45879$c30c8040$a601280a@.phx
.gbl...[vbcol=seagreen]
> hi john,
> thanks!! i've actually seen this already. i have basic
> knowledge of sql and i was hoping to find something that
> tells what folder are that are related to sql that i
> should stay away from or should i just do a scan and just
> exclude the files with the suffix extension mentioned in
> this article? please let me know...
> thanks,
> ed
> us;q309422
> message
> sql
> should|||thanks!!!
-ed
>--Original Message--
>Hi
>Doing a scan may produce some files with the extension
although this may
>include files that are miss-named
>Running something like the following command in Query
Analyser should show
>the file being used:
>EXEC master..sp_MSForEachdb 'SELECT filename
FROM ?..sysfiles'
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1f84e01c45879$c30c8040$a601280a@.phx
.gbl...
that[vbcol=seagreen]
just[vbcol=seagreen]
in[vbcol=seagreen]
very[vbcol=seagreen]
>
>.
>
standard 2000. anybody have any suggestions or
recommendations on how i should go about configuring
this? are there any folders specific to sql that i should
stay away from? please let me know. your help is very
much appreciated.
thanks a lot in advance,
edHi
Check out:
http://support.microsoft.com/defaul...b;en-us;q309422
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1fdf001c45870$2bbb8eb0$a401280a@.phx
.gbl...
> i'm about to install a file antivirus software on my sql
> standard 2000. anybody have any suggestions or
> recommendations on how i should go about configuring
> this? are there any folders specific to sql that i should
> stay away from? please let me know. your help is very
> much appreciated.
> thanks a lot in advance,
> ed|||hi john,
thanks!! i've actually seen this already. i have basic
knowledge of sql and i was hoping to find something that
tells what folder are that are related to sql that i
should stay away from or should i just do a scan and just
exclude the files with the suffix extension mentioned in
this article? please let me know...
thanks,
ed
>--Original Message--
>Hi
>Check out:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q309422
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1fdf001c45870$2bbb8eb0$a401280a@.phx
.gbl...
sql[vbcol=seagreen]
should[vbcol=seagreen]
>
>.
>|||Hi
Doing a scan may produce some files with the extension although this may
include files that are miss-named
Running something like the following command in Query Analyser should show
the file being used:
EXEC master..sp_MSForEachdb 'SELECT filename FROM ?..sysfiles'
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1f84e01c45879$c30c8040$a601280a@.phx
.gbl...[vbcol=seagreen]
> hi john,
> thanks!! i've actually seen this already. i have basic
> knowledge of sql and i was hoping to find something that
> tells what folder are that are related to sql that i
> should stay away from or should i just do a scan and just
> exclude the files with the suffix extension mentioned in
> this article? please let me know...
> thanks,
> ed
> us;q309422
> message
> sql
> should|||thanks!!!
-ed
>--Original Message--
>Hi
>Doing a scan may produce some files with the extension
although this may
>include files that are miss-named
>Running something like the following command in Query
Analyser should show
>the file being used:
>EXEC master..sp_MSForEachdb 'SELECT filename
FROM ?..sysfiles'
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1f84e01c45879$c30c8040$a601280a@.phx
.gbl...
that[vbcol=seagreen]
just[vbcol=seagreen]
in[vbcol=seagreen]
very[vbcol=seagreen]
>
>.
>
configuring antivirus protection
i'm about to install a file antivirus software on my sql
standard 2000. anybody have any suggestions or
recommendations on how i should go about configuring
this? are there any folders specific to sql that i should
stay away from? please let me know. your help is very
much appreciated.
thanks a lot in advance,
edHi
Check out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q309422
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
> i'm about to install a file antivirus software on my sql
> standard 2000. anybody have any suggestions or
> recommendations on how i should go about configuring
> this? are there any folders specific to sql that i should
> stay away from? please let me know. your help is very
> much appreciated.
> thanks a lot in advance,
> ed|||hi john,
thanks!! i've actually seen this already. i have basic
knowledge of sql and i was hoping to find something that
tells what folder are that are related to sql that i
should stay away from or should i just do a scan and just
exclude the files with the suffix extension mentioned in
this article? please let me know...
thanks,
ed
>--Original Message--
>Hi
>Check out:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q309422
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
>> i'm about to install a file antivirus software on my
sql
>> standard 2000. anybody have any suggestions or
>> recommendations on how i should go about configuring
>> this? are there any folders specific to sql that i
should
>> stay away from? please let me know. your help is very
>> much appreciated.
>> thanks a lot in advance,
>> ed
>
>.
>|||Hi
Doing a scan may produce some files with the extension although this may
include files that are miss-named
Running something like the following command in Query Analyser should show
the file being used:
EXEC master..sp_MSForEachdb 'SELECT filename FROM ?..sysfiles'
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1f84e01c45879$c30c8040$a601280a@.phx.gbl...
> hi john,
> thanks!! i've actually seen this already. i have basic
> knowledge of sql and i was hoping to find something that
> tells what folder are that are related to sql that i
> should stay away from or should i just do a scan and just
> exclude the files with the suffix extension mentioned in
> this article? please let me know...
> thanks,
> ed
> >--Original Message--
> >Hi
> >
> >Check out:
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;q309422
> >
> >John
> >
> >"ed" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
> >> i'm about to install a file antivirus software on my
> sql
> >> standard 2000. anybody have any suggestions or
> >> recommendations on how i should go about configuring
> >> this? are there any folders specific to sql that i
> should
> >> stay away from? please let me know. your help is very
> >> much appreciated.
> >>
> >> thanks a lot in advance,
> >> ed
> >
> >
> >.
> >|||thanks!!!
-ed
>--Original Message--
>Hi
>Doing a scan may produce some files with the extension
although this may
>include files that are miss-named
>Running something like the following command in Query
Analyser should show
>the file being used:
>EXEC master..sp_MSForEachdb 'SELECT filename
FROM ?..sysfiles'
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1f84e01c45879$c30c8040$a601280a@.phx.gbl...
>> hi john,
>> thanks!! i've actually seen this already. i have basic
>> knowledge of sql and i was hoping to find something
that
>> tells what folder are that are related to sql that i
>> should stay away from or should i just do a scan and
just
>> exclude the files with the suffix extension mentioned
in
>> this article? please let me know...
>> thanks,
>> ed
>> >--Original Message--
>> >Hi
>> >
>> >Check out:
>> >http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;q309422
>> >
>> >John
>> >
>> >"ed" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
>> >> i'm about to install a file antivirus software on my
>> sql
>> >> standard 2000. anybody have any suggestions or
>> >> recommendations on how i should go about configuring
>> >> this? are there any folders specific to sql that i
>> should
>> >> stay away from? please let me know. your help is
very
>> >> much appreciated.
>> >>
>> >> thanks a lot in advance,
>> >> ed
>> >
>> >
>> >.
>> >
>
>.
>
standard 2000. anybody have any suggestions or
recommendations on how i should go about configuring
this? are there any folders specific to sql that i should
stay away from? please let me know. your help is very
much appreciated.
thanks a lot in advance,
edHi
Check out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q309422
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
> i'm about to install a file antivirus software on my sql
> standard 2000. anybody have any suggestions or
> recommendations on how i should go about configuring
> this? are there any folders specific to sql that i should
> stay away from? please let me know. your help is very
> much appreciated.
> thanks a lot in advance,
> ed|||hi john,
thanks!! i've actually seen this already. i have basic
knowledge of sql and i was hoping to find something that
tells what folder are that are related to sql that i
should stay away from or should i just do a scan and just
exclude the files with the suffix extension mentioned in
this article? please let me know...
thanks,
ed
>--Original Message--
>Hi
>Check out:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q309422
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
>> i'm about to install a file antivirus software on my
sql
>> standard 2000. anybody have any suggestions or
>> recommendations on how i should go about configuring
>> this? are there any folders specific to sql that i
should
>> stay away from? please let me know. your help is very
>> much appreciated.
>> thanks a lot in advance,
>> ed
>
>.
>|||Hi
Doing a scan may produce some files with the extension although this may
include files that are miss-named
Running something like the following command in Query Analyser should show
the file being used:
EXEC master..sp_MSForEachdb 'SELECT filename FROM ?..sysfiles'
John
"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:1f84e01c45879$c30c8040$a601280a@.phx.gbl...
> hi john,
> thanks!! i've actually seen this already. i have basic
> knowledge of sql and i was hoping to find something that
> tells what folder are that are related to sql that i
> should stay away from or should i just do a scan and just
> exclude the files with the suffix extension mentioned in
> this article? please let me know...
> thanks,
> ed
> >--Original Message--
> >Hi
> >
> >Check out:
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;q309422
> >
> >John
> >
> >"ed" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
> >> i'm about to install a file antivirus software on my
> sql
> >> standard 2000. anybody have any suggestions or
> >> recommendations on how i should go about configuring
> >> this? are there any folders specific to sql that i
> should
> >> stay away from? please let me know. your help is very
> >> much appreciated.
> >>
> >> thanks a lot in advance,
> >> ed
> >
> >
> >.
> >|||thanks!!!
-ed
>--Original Message--
>Hi
>Doing a scan may produce some files with the extension
although this may
>include files that are miss-named
>Running something like the following command in Query
Analyser should show
>the file being used:
>EXEC master..sp_MSForEachdb 'SELECT filename
FROM ?..sysfiles'
>John
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1f84e01c45879$c30c8040$a601280a@.phx.gbl...
>> hi john,
>> thanks!! i've actually seen this already. i have basic
>> knowledge of sql and i was hoping to find something
that
>> tells what folder are that are related to sql that i
>> should stay away from or should i just do a scan and
just
>> exclude the files with the suffix extension mentioned
in
>> this article? please let me know...
>> thanks,
>> ed
>> >--Original Message--
>> >Hi
>> >
>> >Check out:
>> >http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;q309422
>> >
>> >John
>> >
>> >"ed" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:1fdf001c45870$2bbb8eb0$a401280a@.phx.gbl...
>> >> i'm about to install a file antivirus software on my
>> sql
>> >> standard 2000. anybody have any suggestions or
>> >> recommendations on how i should go about configuring
>> >> this? are there any folders specific to sql that i
>> should
>> >> stay away from? please let me know. your help is
very
>> >> much appreciated.
>> >>
>> >> thanks a lot in advance,
>> >> ed
>> >
>> >
>> >.
>> >
>
>.
>
configuring antivirus
i'm about to install a file antivirus software on my sql
standard 2000. anybody have any suggestions or
recommendations on how i should go about configuring
this? are there any folders specific to sql that i should
stay away from? please let me know. your help is very
much appreciated.
thanks a lot in advance,
ed"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:201a201c45875$e3709280$a001280a@.phx
.gbl...
> i'm about to install a file antivirus software on my sql
> standard 2000. anybody have any suggestions or
> recommendations on how i should go about configuring
> this? are there any folders specific to sql that i should
> stay away from? please let me know. your help is very
> much appreciated.
What product are you installing? If it's similar to what we are using, I can
share our configuration.
You could check with the antivirus vendor on best practice when installing
on a device with SQL Server, ask if the software scans open files? If not,
then your data and log files are safe -- at least from the antivirus
software <g>.
Steve|||You'd want to exclude your data and log files. Additionally,
the following article has some guidelines:
INF: Consideration for a Virus Scanner on a Computer That Is
Running SQL Server
http://support.microsoft.com/?kbid=309422
-Sue
On Tue, 22 Jun 2004 09:28:02 -0700, "ed"
<anonymous@.discussions.microsoft.com> wrote:
>i'm about to install a file antivirus software on my sql
>standard 2000. anybody have any suggestions or
>recommendations on how i should go about configuring
>this? are there any folders specific to sql that i should
>stay away from? please let me know. your help is very
>much appreciated.
>thanks a lot in advance,
>ed|||thanks!!
-ed
>--Original Message--
>You'd want to exclude your data and log files.
Additionally,
>the following article has some guidelines:
>INF: Consideration for a Virus Scanner on a Computer
That Is
>Running SQL Server
>http://support.microsoft.com/?kbid=309422
>-Sue
>On Tue, 22 Jun 2004 09:28:02 -0700, "ed"
><anonymous@.discussions.microsoft.com> wrote:
>
sql[vbcol=seagreen]
should[vbcol=seagreen]
>.
>|||thanks!!!
-ed
>--Original Message--
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message
> news:201a201c45875$e3709280$a001280a@.phx
.gbl...
sql[vbcol=seagreen]
should[vbcol=seagreen]
>What product are you installing? If it's similar to what
we are using, I can
>share our configuration.
>You could check with the antivirus vendor on best
practice when installing
>on a device with SQL Server, ask if the software scans
open files? If not,
>then your data and log files are safe -- at least from
the antivirus
>software <g>.
>Steve
>
>.
>
standard 2000. anybody have any suggestions or
recommendations on how i should go about configuring
this? are there any folders specific to sql that i should
stay away from? please let me know. your help is very
much appreciated.
thanks a lot in advance,
ed"ed" <anonymous@.discussions.microsoft.com> wrote in message
news:201a201c45875$e3709280$a001280a@.phx
.gbl...
> i'm about to install a file antivirus software on my sql
> standard 2000. anybody have any suggestions or
> recommendations on how i should go about configuring
> this? are there any folders specific to sql that i should
> stay away from? please let me know. your help is very
> much appreciated.
What product are you installing? If it's similar to what we are using, I can
share our configuration.
You could check with the antivirus vendor on best practice when installing
on a device with SQL Server, ask if the software scans open files? If not,
then your data and log files are safe -- at least from the antivirus
software <g>.
Steve|||You'd want to exclude your data and log files. Additionally,
the following article has some guidelines:
INF: Consideration for a Virus Scanner on a Computer That Is
Running SQL Server
http://support.microsoft.com/?kbid=309422
-Sue
On Tue, 22 Jun 2004 09:28:02 -0700, "ed"
<anonymous@.discussions.microsoft.com> wrote:
>i'm about to install a file antivirus software on my sql
>standard 2000. anybody have any suggestions or
>recommendations on how i should go about configuring
>this? are there any folders specific to sql that i should
>stay away from? please let me know. your help is very
>much appreciated.
>thanks a lot in advance,
>ed|||thanks!!
-ed
>--Original Message--
>You'd want to exclude your data and log files.
Additionally,
>the following article has some guidelines:
>INF: Consideration for a Virus Scanner on a Computer
That Is
>Running SQL Server
>http://support.microsoft.com/?kbid=309422
>-Sue
>On Tue, 22 Jun 2004 09:28:02 -0700, "ed"
><anonymous@.discussions.microsoft.com> wrote:
>
sql[vbcol=seagreen]
should[vbcol=seagreen]
>.
>|||thanks!!!
-ed
>--Original Message--
>"ed" <anonymous@.discussions.microsoft.com> wrote in
message
> news:201a201c45875$e3709280$a001280a@.phx
.gbl...
sql[vbcol=seagreen]
should[vbcol=seagreen]
>What product are you installing? If it's similar to what
we are using, I can
>share our configuration.
>You could check with the antivirus vendor on best
practice when installing
>on a device with SQL Server, ask if the software scans
open files? If not,
>then your data and log files are safe -- at least from
the antivirus
>software <g>.
>Steve
>
>.
>
Subscribe to:
Posts (Atom)