Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Alwayson failover deleted logs and database file Expand / Collapse
Author
Message
Posted Monday, May 20, 2013 11:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 18, 2014 7:40 AM
Points: 76, Visits: 353
We have a Alwayson availibility group setup on two clustered Windows 2008R2 machines. There is no shared storage setup, the database files reside on each nodes local drive. We stopped the sql service on one of them and it failed over fine. We started the service and it caught up. We next rebooted the replica machine. When the machine came back up the drive that held the database files and logs was completely empty. So the databases on the rebooted machine say recovery pending.

Is this normal?
Post #1454645
Posted Wednesday, May 22, 2013 3:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:03 AM
Points: 1,380, Visits: 2,708
That is definately not normal

Something happened during/after the reboot.

Check error logs etc..
Post #1455389
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse