Viewing 15 posts - 2,011 through 2,025 (of 9,253 total)
either use failover cluster manager or the following PowerShell command
Get-ClusterResource | ?{$_.resourcetype -EQ "IP Address"} | ft OwnerNode,State,Name,OwnerGroup
June 23, 2015 at 5:03 am
SQL!$@w$0ME (6/18/2015)
Servers are on the same site. But the 3rd node will not be configured for high availability, just for reporting (no vote for quorum?)
If the servers are same site...
June 18, 2015 at 10:05 am
Run this query on the primary, change the job name first, and post the output please
SELECT j.name
, jh.[step_id]
, jh.[step_name]
, jh.[message]
...
June 18, 2015 at 8:46 am
antonio.estima 4150 (6/18/2015)
June 18, 2015 at 8:34 am
thank you Johan for the correction 😉
June 18, 2015 at 8:32 am
the log shipping backup job should be taking log backups and not full backups. Check the job step history and post here
June 18, 2015 at 4:57 am
so what have you done about cluster disk 1 and cluster disk 2?
June 18, 2015 at 4:51 am
SQL!$@w$0ME (6/17/2015)
June 18, 2015 at 4:40 am
alex_pixley (6/17/2015)
June 18, 2015 at 4:09 am
To do the same in powershell only requires a few lines of code 😉
June 18, 2015 at 1:06 am
simon.harvey 41170 (6/16/2015)
June 16, 2015 at 4:05 am
Try these, no gaps
-dE:\DATA\master.mdf
-eE:\log\ERRORLOG
-lE:\DATA\mastlog.ldf
-T272
June 16, 2015 at 3:58 am
please post the results of the following powershell query
Get-ClusterResource | FL name,state,resourcetype,ownergroup,restartthreshold,restartdelay,restartperiod
June 16, 2015 at 3:54 am
Viewing 15 posts - 2,011 through 2,025 (of 9,253 total)