Novice to sql > Small Business Server Support Forum

ForumsSurveysChat

Support

Forum

Download

About

Registered users

	Membership:
	Latest:Tony lai kit
	New Today:11
	New Yesterday:13
	Overall:23318

Private messaging

You must be logged in to use this module.

Top 10 posters

Name	Posts
Mariette Knap	12890
Marina Roos	12507
Eriq Neale	2114
Stan Guinn	1913
Michael Patrick	1912
Robert Pearman	1770
Nick Pieters	1425
Stewart Brown	616
william warren	593
Kevin D.	579

Articles

»	Antivirus
»	Backup and restore
»	BlackBerry
»	Branch offices
»	Configuring routers
»	CRM
»	Exchange Server 2000
»	Exchange Server 2003
»	Exchange Server 2007
»	ISA Server 2000
»	ISA Server 2004
»	Macintosh integration
»	Network configuration
»	Planning and installing your SBS server
»	Press releases
»	Project server
»	Public articles
»	Remote Access
»	SBS 2000
»	SBS 2003
»	SBS 2003 R2
»	SBS 2008
»	Securing your SBS 2003 network
»	Server issues
»	Service Packs
»	Sharepoint
»	SQL 2000
»	SQL 2005
»	SQL 2008
»	Subscriber articles
»	Terminal Servers
»	Third party solutions
»	Workstations

View all articles

Welcome unauthorized visitor

If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.

Small Business Server Support Forum

Unanswered Active Topics

Forums Search

Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000

Subject: Novice to sql

Prev Next

You are not authorized to post a reply.

Author

Messages

S Alamsjah User is Offline

The Netherlands
Member since
5/24/2006

Platinum Membership
Posts: 87

9/26/2008 09:14 AM
Hi All, Im new to SQL so i have some basic questions. We're running a SBS2003 Standard server. Fully patched except sp2 for Windows2003. We're using a ERP system that uses SQL so the supplier gave us a cd with SQL server with SP4 to run the ERP system. We installed it on a different partition than the SBS2003 system. That all works fine. Now we want to try this Blackberry software. I read the procedure from Mariette. My questions: Do i have to run the SQL cd again to install an new SQL installation besides the one we are already running or do i have to just create a new database? Probably we will not run more than 5 users with Blackberry so we could use MSDE but i think its saver to stick as close to the described procedure as possible. How do i make sure the ERP database and the database for Blackberry dont get mixed up? Can i easily undo the Blackberry installation and database if needed? Is there anythin else to watch out for? Thanx in advance, Sal

Edwin Sarmiento User is Offline

Singapore
Member since
2/13/2007

Microsoft MVP
Posts: 133

9/27/2008 10:20 AM
You can either just create a new database on your existing SQL Server instance for ease of management. But better check with your ERP vendor for their recommendation. Installing a separate instance has a lot of benefits, including allocating dedicated CPU and memory resources although management cost would increase as you now have to manage two instances - meaning, two separate backups and database maintenance plans

MCP MCDBA MCAD MCSD MCT MCTS MCITP : DBA MCSA http://bassplayerdoc.blogspot.com Need a remote SQL Server DBA?

You are not authorized to post a reply.

Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Novice to sql

ActiveForums 3.7

Forum policy

These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:

No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving/removing a thread or post or comment.