Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
'hot' backup site
Message
From
14/01/2009 08:57:47
 
 
To
14/01/2009 08:15:23
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01373503
Message ID:
01373522
Views:
16
Where did you get your information that mirroring is not recommended for commercial use?

>I did not get much response last time, so I thought I might try again. I am investigating the means to have a 'hot' backup site, where, if the primary site goes down, the backup site (not local) will pick up with little or no time / intervention. When the primary site comes back on-line, it should get updates from the backup site, and then be able to be promoted back to its primary status.
>
>My area of investigation of this is with SQL Server (2005). My understanding is (so far) that:
>
>1) Replication does not meet the needs, because it can't capture all areas of the database (stored procedures, tables w/o index, views, etc.).
>
>2) Log shipping does not meet the needs, because it requires intervention at each switch, and perhaps a few hours of down time (depending on the people, etc.).
>
>3) Mirroring does not meet the needs, among other things, because it is not recommended for commercial use (i.e. it is not ready??).
>
>Am I missing something here? Do I understand these correctly? If so, it would seem the only 'hot' backup site solutions would be non-SQL server, and perhaps only 3rd party solutions. All help is very much appreciated.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform