Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-05 : 08:32:21
|
| Cyrus writes "Dear sir,We are a set of 2 companies with multiple business applications. At present we have one sql server and the two databases related to each company reside on one instance of SQL server on one SQL server machine. Do you think if it is more suitable to separate the applications to 2 separate SQL servers on 2 machines? These two companies are located in one building. What do you think about backup strategy? do you think if two other standby servers are suitable or not ? Your prompt reply is greatly appreciated.Thanks in advance.Sincerely,Cyrus EtezadiEtezadi@iomco.com" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-09-05 : 11:06:08
|
| depends on many things..... how many users are there in each company ?how big are the databases ?Is the database/network administrator(s) the same for both companies ?What is the spec of the server ?How transactional are your databases ?If both DBs are small (<1GB) with few users (<50 say) then provided your server is suitably armed with RAM and decent processor(s) you should be ok with one server and one for standby.Yes backup !! Hard to say a strategy without knowing how big the DBs are. Backup the transaction log often though (every 3 hours say).===========Paul |
 |
|
|
|
|
|
Multiple SQL server or One