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 |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2005-10-18 : 08:54:48
|
| HI, I just need some information regarding SQL adminitration.We are having Prodcution Database and Development Database on the same machine,We are also having all the Backups(prod & dev) also on the same single machine. But now I want to request for a new box so that I can have prodcution and Development on different box. Please input your ideas on this and what are the considerations I have to look for, to do this job. |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-10-18 : 09:41:59
|
| Production and Development, Backup on same machine is not a good idea at all. If SQL License is part of an issue, then for development you can go for SQL Server Developer Edition, which is same as Enterprise Edition but you cannot go for production with that. Developer Edition is also pretty less. I'm not sure how much connections it will support. Somebody can shed light on that.You need to store your backups in a different machine or a tape probably.ThanksKarunakaran |
 |
|
|
supersql
Yak Posting Veteran
99 Posts |
Posted - 2005-10-18 : 09:58:50
|
| OK then can I have in this way..Production and their backups on 1 box and development and their backups on another box. If so which versions of sqlserver I need to install on them. |
|
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-10-18 : 11:58:32
|
quote:
Originally posted by supersql
OK then can I have in this way..Production and their backups on 1 box and development and their backups on another box. If so which versions of sqlserver I need to install on them.
Which ever versions your business requires. Which version is installed on the multibox?I'd put the backups on the local machine sine you probably don't have a SAN. From there be 100% certain to send the backups to tape as often as your business requires. If your box fails and you loose all of the local disks then you will loose data without a tape backup or some other type of network storage. So if you choose to do a complete backup at night and do incremental or transactional backups during the day and then send those to tape at night, you could loose a full day of data in a failure. Loosing a full day would still be better than loosing it all though. It's up to you to decide what it is that you need to do for backups. Your business should define a set of rules that will allow you to decide how much data is acceptable to loose in the event of a failure and how long of downtime you can have in that event. Then you can decide where you should put the backups and how often to do them.Have fun,Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
|
|
|
|
|
|
SQL Admin