dbTalk Databases Forums  

BACKUP logical drive question

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss BACKUP logical drive question in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
michael [multnomah county]
 
Posts: n/a

Default BACKUP logical drive question - 12-05-2003 , 01:13 PM






We have a cluster setup using 5 servers and 3 environment
(PRD, QAT and DEV): PRD1, PRD2, QAT1, QAT2, DEV1. All
servers are running Windows 2003. We currently have 260
GB of available space and we want to carve out partitions
for the servers. We will be creating separate partitions
for each of the five servers, with a separate DATA and LOG
partition. BUT, my question is regarding a BACKUP logical
drive. Is it a good idea to create a single logical
backup drive that all 5 servers can share, or should we
just backup our databases locally to the DATA drives?

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: BACKUP logical drive question - 12-05-2003 , 01:22 PM






I backup data across the network to a UNC share. I use a specific share per
system, but may or may not have multiple shares on the same underlying
physical storage. I find it completely unnecessary to use expensive SAN
storage for backups. I use fast SCSI disks at a much lower cost per nByte.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com



"michael [multnomah county]" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:dd3701c3bb63$d95cf450$a601280a (AT) phx (DOT) gbl...
Quote:
We have a cluster setup using 5 servers and 3 environment
(PRD, QAT and DEV): PRD1, PRD2, QAT1, QAT2, DEV1. All
servers are running Windows 2003. We currently have 260
GB of available space and we want to carve out partitions
for the servers. We will be creating separate partitions
for each of the five servers, with a separate DATA and LOG
partition. BUT, my question is regarding a BACKUP logical
drive. Is it a good idea to create a single logical
backup drive that all 5 servers can share, or should we
just backup our databases locally to the DATA drives?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.