| Author |
Topic |
|
mikr33
Starting Member
5 Posts |
 Posted - 2012-03-15 : 15:34:30
|
| Hi,we have two identical standalone machines with MS Sql server2008 std. edition with shared disk storage (no cluster, no mirroring, second one is standby).In case of hw failure of first one is there some procedure to run second one like :1. to have all dbs including system dbs on shared storage2. map this storage to second machine3. in config. manager set parameter for folder on shared storage3. change server name, ip addr.4. reboot5. server is up and runningis it wrong idea ?regards Miroslav |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mikr33
Starting Member
5 Posts |
Posted - 2012-03-15 : 16:16:03
|
| Yes, log shipping is an option. I am trying to find some solution without direct connection between servers. There will be some backup but it means lost data.So you mean, it is not possible at least attach dbs from shared storage ?Miroslav |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-03-15 : 16:21:29
|
| It's possible but not guaranteed. In order to attach database files to another server, the files need to be in a good state. If there was activity on the files at the time the first server went down, the files are probably in a bad state and therefore not attachable. I'm generalizing here, but you should never rely on a solution that would require you to try to attach files that were open by SQL Server on another server. There are no guarantees. If you won't have a direct connection between the two servers and therefore mirroring can't be used, then implement log shipping or similar. Yes there will be data loss if you can't backup the tail of the log on the first server, but if you cared about data loss, you would architect your system better so that you could use mirroring or clustering.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mikr33
Starting Member
5 Posts |
Posted - 2012-03-15 : 16:31:52
|
| we can do consistent snapshot e.g every 10 minutes, so I suppose it can be used for restore. can be restored objects on instance level likepackages, logins ...? |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-03-15 : 16:34:15
|
| If you are going to the trouble of setting up shared storage - why are you not also looking at setting up a cluster? It seems to me you want the benefits of clustering and the ability to have your shared storage presented to both servers in case of failure.That is exactly what clustering does for you.For either mirroring or log shipping, you have to have additional storage available for the other system. |
|
|
|
mikr33
Starting Member
5 Posts |
Posted - 2012-03-15 : 16:43:05
|
| yes, you are right, sql server is already in production env. so we have to migrate data somewhere, setup cluster and migrate back .... |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-15 : 17:55:46
|
quote:
Originally posted by X002548
Just read that Log shipping is to be deprecated "in the near future"
No, log shipping's not deprecated in 2008 R2 nor in 2012.--Gail ShawSQL Server MVP |
|
|
|
mikr33
Starting Member
5 Posts |
Posted - 2012-03-16 : 01:05:23
|
| ok, thanks, I have to leave first idea - only attach or map dbs from another server (in case of abnormal end). |
|
|
|
|
To be prepared for recovery