dbTalk Databases Forums  

SQL Server Backup

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


Discuss SQL Server Backup in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vince
 
Posts: n/a

Default SQL Server Backup - 08-11-2004 , 02:26 PM






Can SQL server be mirrored between two drives in the same
box, and can this be used as a backup strategy?

Thanks Vince

Reply With Quote
  #2  
Old   
Andy Ball
 
Posts: n/a

Default Re: SQL Server Backup - 08-11-2004 , 05:23 PM






SQL Data can be mirrored using either Windows built in software mirroring,
hardware mirroring (better).

However , this is not a backup strategy as a corruption introduced by faulty
controller card / driver / firmware will be mirrored also.

Also you need to get your data offsite in case of a site related disaster

cheers,
Andy.

"Vince" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Can SQL server be mirrored between two drives in the same
box, and can this be used as a backup strategy?

Thanks Vince



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.