Viewing 15 posts - 2,521 through 2,535 (of 9,244 total)
why on earth would you want that scenario?
Firstly check why you have the disconnections, you undoubtedly have an underlying issue maybe with the network (most common)?
What does a cluster validation...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2015 at 11:08 am
Joy Smith San (1/15/2015)
I have never set up a SQL Server cluster hence not familiar with cluster setup.
I just want to know what are the prerequisites for installing a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2015 at 7:20 am
I get that totally thats why i said page allocations shift to account for more space in one file than another.
In a previous database i came across with 52 files...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2015 at 1:25 am
GilaMonster (1/14/2015)
For user databases isn't not particuarly critical.
I would say it's just as critical, you still have a proportional fill rate and files of differing size\freespace will just cause the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2015 at 10:40 am
sm_iransoftware (1/14/2015)
I Want to test for Automatic switch between primary and secondary.How do i do it ?
Shutdown the node the primary is running on
sm_iransoftware (1/14/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2015 at 10:20 am
Joy Smith San (1/14/2015)
Hi,We have a requirement to configure a 2 node cluster (active/passive).
As per my understanding, we do it in SQL Server 2012 std. edition. Please confirm.
Thanks,
San.
You may...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2015 at 5:33 am
sm_iransoftware (1/14/2015)
We need to run Always on , on our sql servers.
Is there any upgrade or benefits on sql server 2014 about Always on ?
Or
Should I Upgrade to 2014...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2015 at 5:31 am
jasona.work (1/12/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2015 at 9:55 am
What quorum configuration have you employed for the 2 node cluster?
What settings have been applied to the AlwaysOn group, synch or asynch, manual or auto failover?
Are the databases synchronised?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 13, 2015 at 5:59 am
JarJar (1/8/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 9, 2015 at 4:14 am
Grant Fritchey (1/8/2015)
And I'm with Perry. I'd use .bak for all sorts of backup files, but differentiate them in the name.
Or .TRN for tran log backups. The Microsoft provided defaults...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 9, 2015 at 3:59 am
bryanasaurus (1/8/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 9, 2015 at 3:57 am
i would put the full or diff identifier in the filename
i.e. mysqlbackup_full_20150106_1120.bak
mysqlbackup_diff_20150106_1130.bak
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2015 at 6:04 am
GilaMonster (1/8/2015)
jacksonandrew321 (1/8/2015)
Yes, I did and path is valid.Except that it's missing a file name in one place and missing the entire path in the other.
Check the permissions on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2015 at 5:46 am
ramyours2003 (1/7/2015)
Can any one send me the document how to configure and trouble shoot the always on in sql 2012 ?
Follow my stairway series on this site starting at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2015 at 5:44 am
Viewing 15 posts - 2,521 through 2,535 (of 9,244 total)