Viewing 15 posts - 2,761 through 2,775 (of 9,241 total)
dajonx (11/13/2014)
We are running SQL Server 2008 R2 on a two-node Windows Server 2012 R2 failover cluster.
During unexpected network outages, we noticed that the failover cluster attempted to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2014 at 8:41 am
Brandie Tarvin (11/12/2014)
1) Both FCI and AG require windows clustering in order to work.
Yes, both technologies require a functional Windows Server Failover Cluster.
Note that you may also use an FCI...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2014 at 8:24 am
Sathvik (11/13/2014)
Thanks for your clarification :).Excuse me if I am asking basic question, why clearing DCM Page(full DB backup and Diff backup) doesn't support for readonly databases?
Thanks.
What would happen if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2014 at 7:54 am
i don't believe that information is available
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2014 at 7:53 am
John Langston (11/11/2014)
SQL 2008 R2 - drive hosting tempdb was lost.
Do you plan to replace the drive?
If so, recreate the folder structure and apply the correct permissions for the service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 12, 2014 at 3:33 am
scantoria (11/10/2014)
This is interesting. Currently, our Diff runs every Wednesday and Full every Sunday.
With once a week fulls i'd prefer more regular diffs
scantoria (11/10/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2014 at 9:57 am
balasaukri (11/11/2014)
They are SAN drives! Not local drives.
OK so engage the help of your SAN administrator and as previously suggested capture perfmon counters to check for throughput and latency.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2014 at 9:16 am
BWFC (11/11/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2014 at 9:14 am
Yuri55 (11/10/2014)
I am afraid it's not an IP issue
I havent said it is yet!!
I've asked you to list out the IPs from the cluster group!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2014 at 9:08 am
why not just create unique backup file names by using either the date and time of the backup or the current LSN number??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2014 at 9:06 am
balasaukri (11/11/2014)
Perry Whittle (11/11/2014)
Yes all are Virtual machines only in my Environment. Absolutely there is no physical servers.
what is the back end storage configuration for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2014 at 9:04 am
is server B a virtual machine?
what is the back end storage configuration for Server B?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2014 at 6:55 am
what trace flags do you have set on the service startup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2014 at 4:09 am
sp_seeker (11/10/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2014 at 4:07 am
cstrati (11/10/2014)
Can you please clarify for me what would happen if the database owner was running as an account which was then disabled?
From memory, nothing. If the user were deleted...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2014 at 4:05 am
Viewing 15 posts - 2,761 through 2,775 (of 9,241 total)