Best techniques for databse creation ?

Dear Experts
Any one knows any link regarding best practices for schema and database creation in SQL server 2000 in detail
Faheem Latif
NETWORK SOLUTIONFaheem,
What specifically are you looking for? There are many things on the web if
you search google. However I recommend these links as a start:
SQL Server 2000 Operations Guide
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
Vyas's article on Best Practices
http://www.sql-server-performance.com/vk_sql_best_practices.asp
Microsoft SQL Server 2000 Best Practices Analyzer 1.0 Beta
http://www.microsoft.com/downloads/details.aspx?FamilyId=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
Tinyurl: http://tinyurl.com/upzi
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:189C9EC5-9492-4B34-A0D7-C9908D15BA0E@.microsoft.com...
> Dear Experts,
> Any one knows any link regarding best practices for schema and database
creation in SQL server 2000 in detail .
> Faheem Latif
> NETWORK SOLUTION
>

Best Replication

There are ten DB Servers in live network. Out of 10 DB servers, one of them
has the database and the contents are replicated throughout. The size of
the database is about 20 GB and it is to be updated on weekly basis. The
time frame for replication is limited to 2 hours and all the data must be
updated from the Update DB server within 2 hours given.
What is the best data replication method on this scenario?
Jason,
transactional would be the fastest. Log shipping might be of alternative
interest. I'm assuming that the subscribers don't need to update the data.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Best Practices Analyzer contradicts BOL for SQLSERVERAGENT

The 2005 Best Practices Analyzer (July 2007) contradicts Books Online about what account to run SQLSERVERAGENT under.

BPA says use Network Service Account, BOL explicitly says not to use Network Service Account:

BPA gives a warning saying "SQL Server Service [MY-PC\SQLSERVERAGENT] In Unrecommended Account On Host [MY-PC]. We recommend that the service [SQLSERVERAGENT] on host [MY-PC] be run under Network Service Account. Currently it is designated to run under the account [SOMEDOMAIN\someaccount]."

BooksOnline says "Security Note: Because multiple services can use the Network Service account, it is difficult to control which services have access to network resources, including SQL Server databases. We do not recommend using the Network Service account for the SQL Server Agent service."

So who's right ? BPA or BOL ?

Books online is correct - a non-system account provides more control over access, security.

Just curious...which version of BPA are you running?

-Sue

sql

Best Practice Question

I have a web server that needs access to SQL. The web server is currently in
a DMZ and SQL is in on the internal network. We are currently using standard
security to access SQL, but I have heard that standard security is not as
secure as windows security. Can windows security work across a firewall?
What is the recommended practice in this very common scenario? I'm not
really familiar with ISA server but am also wondering if it could be used to
gain any advantage in this scenario (perhaps with server publishing, etc). I
want to achieve the maximum security with the least administrative overhead.
Any pointers would be appreciated. Thanks.Elmer
Visit at
http://vyaskn.tripod.com/sql_server...t_practices.htm --secu
rity
best practices
"Elmer Miller" <millere@.empireco.nospam> wrote in message
news:%23S6LtXNxEHA.3024@.TK2MSFTNGP14.phx.gbl...
> I have a web server that needs access to SQL. The web server is currently
in
> a DMZ and SQL is in on the internal network. We are currently using
standard
> security to access SQL, but I have heard that standard security is not as
> secure as windows security. Can windows security work across a firewall?
> What is the recommended practice in this very common scenario? I'm not
> really familiar with ISA server but am also wondering if it could be used
to
> gain any advantage in this scenario (perhaps with server publishing, etc).
I
> want to achieve the maximum security with the least administrative
overhead.
> Any pointers would be appreciated. Thanks.
>

BEST NAS on the MARKET?

Hi all the other GURU out there,
My company is trying to find a good NAS system for storage on our
network. We previously bought a IOMega 640Gbytes NAS, which is a
headless Win 2000 Server, it works but not the greatest.
What NAS out there would you recommand me to buy if I am looking for a
1 to 2 Tbytes NAS?
Thanks in advance.
CompGuru WannabeCompGuRu wrote:
> Hi all the other GURU out there,
> My company is trying to find a good NAS system for storage on our
> network. We previously bought a IOMega 640Gbytes NAS, which is a
> headless Win 2000 Server, it works but not the greatest.
> What NAS out there would you recommand me to buy if I am looking for a
> 1 to 2 Tbytes NAS?
> Thanks in advance.
> CompGuru Wannabe
Is this for use with SQL Server? If so, have a look here for issues and
requirements for using NAS devices with SQL Server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks.. It probably just be a backup server for storing drive images
and source files.. I will give it a try..
COmp GuRU|||Decide on the application before you decide the hardware. NAS is not
for SQL Server.
--
David Portas
SQL Server MVP
--

Best Enterprise Manager clone/wannabe?

Hi,
When working with environments that use the MSDE, we usually plug a laptop
into their network that has Enterprise Manager on it, and work that way.
Is there a good possibly third partry product that is not too expensive and
can be loaded on their machine so we don't have to do this? That way I could
go in via the Net and work with out going to their location.
I know there are a couple out there, I just haven't been able to find anyone
who has experience with them.
Thanks,
Steve
Why can't you load EM (Client Tools) only?
http://sqlservercode.blogspot.com/
"SteveInBeloit" wrote:

> Hi,
> When working with environments that use the MSDE, we usually plug a laptop
> into their network that has Enterprise Manager on it, and work that way.
> Is there a good possibly third partry product that is not too expensive and
> can be loaded on their machine so we don't have to do this? That way I could
> go in via the Net and work with out going to their location.
> I know there are a couple out there, I just haven't been able to find anyone
> who has experience with them.
> Thanks,
> Steve
|||My ignorance maybe. . . I was under the impression that legally you could not.
Steve
"SQL" wrote:
[vbcol=seagreen]
> Why can't you load EM (Client Tools) only?
> http://sqlservercode.blogspot.com/
> "SteveInBeloit" wrote:
|||Legally you may not be allowed to so you aren't being
ignorant. Check the following articles for an explanation
and tools to manage MSDE- there are some free ones listed.
Of the third party tools, DbaMgr is good.
If you are just looking for a query tool, Toad for SQL
Server works well.
-Sue
On Thu, 6 Oct 2005 13:59:06 -0700, "SteveInBeloit"
<SteveInBeloit@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>My ignorance maybe. . . I was under the impression that legally you could not.
>Steve
>
>"SQL" wrote:
|||SteveInBeloit wrote:

> Is there a good possibly third partry product that is not too expensive and
http://www.sqlmanager.net/
|||Sorry...forgot the link:
http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 06 Oct 2005 22:44:08 -0600, Sue Hoegemeier
<Sue_H@.nomail.please> wrote:
[vbcol=seagreen]
>Legally you may not be allowed to so you aren't being
>ignorant. Check the following articles for an explanation
>and tools to manage MSDE- there are some free ones listed.
>Of the third party tools, DbaMgr is good.
>If you are just looking for a query tool, Toad for SQL
>Server works well.
>-Sue
>On Thu, 6 Oct 2005 13:59:06 -0700, "SteveInBeloit"
><SteveInBeloit@.discussions.microsoft.com> wrote:
|||SteveInBeloit wrote:
> Hi,
> When working with environments that use the MSDE, we usually plug a laptop
> into their network that has Enterprise Manager on it, and work that way.
> Is there a good possibly third partry product that is not too expensive and
> can be loaded on their machine so we don't have to do this? That way I could
> go in via the Net and work with out going to their location.
Buy SQL Server Developer Edition for $50 and get it all.
Steve Troxell
|||Have you tried, EMS sql manager lite
http://www.hotscripts.com/Detailed/47270.html
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:196C5DC7-6942-4EF3-A057-1126BDE7BC20@.microsoft.com...
> Hi,
> When working with environments that use the MSDE, we usually plug a laptop
> into their network that has Enterprise Manager on it, and work that way.
> Is there a good possibly third partry product that is not too expensive
> and
> can be loaded on their machine so we don't have to do this? That way I
> could
> go in via the Net and work with out going to their location.
> I know there are a couple out there, I just haven't been able to find
> anyone
> who has experience with them.
> Thanks,
> Steve

benefits/disadvantages of activex/sql-dmo

i have just setup my main sql server as a central publisher/distributor and a number of laptops (only connect to network once a week) with msde as annonymous pull subscribers, using merge replication. Using windows synchronisation manager i have run the c
ommon conflicts i expect to occur and everything works ok.
Could anyone tell me the benefits/pitfalls of using SQL Merge Control or SQL-DMO, over Windows Syncronisation Manager?
Is there a way during syncronisation to determine which side publisher/subscriber has priority on each conflict as and when they occur?
Please bear in mind this is the first time I have worked with SQL Server and I am the only IT person in a small company so I am avoiding over-complicating things for users as much as possible. These message boards are brilliant for advice from people more
experienced than me.
Thanks for your help
SQL DMO is what the replication wizards use. Under the covers it runs replication stored procedures.
Think of the Active
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"James P" wrote:

> i have just setup my main sql server as a central publisher/distributor and a number of laptops (only connect to network once a week) with msde as annonymous pull subscribers, using merge replication. Using windows synchronisation manager i have run the
common conflicts i expect to occur and everything works ok.
> Could anyone tell me the benefits/pitfalls of using SQL Merge Control or SQL-DMO, over Windows Syncronisation Manager?
> Is there a way during syncronisation to determine which side publisher/subscriber has priority on each conflict as and when they occur?
> Please bear in mind this is the first time I have worked with SQL Server and I am the only IT person in a small company so I am avoiding over-complicating things for users as much as possible. These message boards are brilliant for advice from people mo
re experienced than me.
> Thanks for your help
>
|||sorry that last message was send prematurely.
Think of the ActiveX controls as a lightweight version of SQL DMO. Windows Synchronization Manager uses the ActiveX controls.
Here is a brief rundown of the differences. BTW - I only use SQL DMO, although its more complex to code with, it is more feature rich.
1) If you are building publications, you must use SQL-DMO. You cannot build publications or push subscriptions with ActiveX replication controls.
2) The ActiveX replication controls' functionality is limited to copying subscription databases (but not attaching them), managing the Snapshot and Distribution Agents, creating pull subscriptions, and reinitializing subscriptions.
3) Despite their limitations, the ActiveX replication controls have proven to be far more popular than SQL-DMO is as they contain only three classes, and are simpler to work with .
4) you can't control the ActiveX agents through the agents folder in EM.
To answer your specific question regarding priority in SQL DMO its the priority property of the MergePublication class, in ActiveX its the SubscriptionPriority and SubscriptionPriorityType of the SQLMerge class.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"James P" wrote:

> i have just setup my main sql server as a central publisher/distributor and a number of laptops (only connect to network once a week) with msde as annonymous pull subscribers, using merge replication. Using windows synchronisation manager i have run the
common conflicts i expect to occur and everything works ok.
> Could anyone tell me the benefits/pitfalls of using SQL Merge Control or SQL-DMO, over Windows Syncronisation Manager?
> Is there a way during syncronisation to determine which side publisher/subscriber has priority on each conflict as and when they occur?
> Please bear in mind this is the first time I have worked with SQL Server and I am the only IT person in a small company so I am avoiding over-complicating things for users as much as possible. These message boards are brilliant for advice from people mo
re experienced than me.
> Thanks for your help
>

BDE Connection via ODBC to MS SQL Server fails

Hi,

I have a strange problem accessing a MS SQL Database from my network.
I'm using an application that is based on BDE which uses ODBC to connect to a MS SQL DB.
When I tried to connect from the network with BDE,I got this error message:

BDE Error : 13059
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).

On the server side I'm using W2003 EE ,MS SQL 2000 Standard with SP4, BDE5.11.
On the client side it's an XP SP2 with MS SQL Client installed, same BDE 5.11
When I create an alias using ODBC and mapping to my server, it connects and the communication with the Database Server succeds:
TESTS COMPLETED SUCCESSFULLY!
When I'm trying to connect using BDE Admin and double clicking on the + sign of the alias I created usind ODBC admin I get the message I listed above.
Any help would be appreciated,

Thanks.May check this http://support.plato.com/kb/tip.asp?psid=23252 link fyi.|||Thank you for replying me...in the meantime i solved the problem.
It was the incorrect settings in the registry for BDE. After erasing the keys from the registry and having reinstalled the BDE everything worked fine.
There are some files used by BDE when connecting to SQL server which are not installed when using Delphi 5 or later :(

However thank you for the usefull link.

best regards,
Sanyi|||Glad the issue is resolved and appreciate your feedback on posting the solution, that helps.