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 «««1234»»

Using and Creating Mount Points in SQL Server Expand / Collapse
Author
Message
Posted Friday, December 9, 2011 10:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:13 PM
Points: 6,466, Visits: 13,919
Hi sorry, my bad totally missed the cluster part. Yes for a new clustered instance you will need to add another root drive and letter to the new application group

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1219598
Posted Friday, December 9, 2011 10:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 16, 2012 1:18 PM
Points: 7, Visits: 21
Got it. Thanks...
Post #1219605
Posted Wednesday, December 21, 2011 12:44 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 17, 2014 7:33 AM
Points: 839, Visits: 1,377
A little piece of missing information: You describe some of the differences between MBR and GPT, but in my opinion you lack the most important one: MBR can only host partitions up to 2TB. Obviously, if you are trying to create a partition bigger than this, you need to have a GPT disk. More importantly though, if you think your partition can possibly be resized to more than 2TB in the future, you should go for GPT to allow for this.



Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL
Post #1224923
Posted Wednesday, December 21, 2011 2:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:13 PM
Points: 6,466, Visits: 13,919
okbangas (12/21/2011)
A little piece of missing information: You describe some of the differences between MBR and GPT, but in my opinion you lack the most important one: MBR can only host partitions up to 2TB. Obviously, if you are trying to create a partition bigger than this, you need to have a GPT disk. More importantly though, if you think your partition can possibly be resized to more than 2TB in the future, you should go for GPT to allow for this.

<sigh> please read the article.
I make a recommendation that if your disk will be under 500GB and have 1 partition use MBR otherwise consider GPT. It's not meant to be a comprehensive guide on disk types that is why I include the link to that KB. I do however cover the important aspects regarding partition constraints.

You're just being petty, good day


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1224951
Posted Wednesday, December 21, 2011 5:57 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 17, 2014 7:33 AM
Points: 839, Visits: 1,377
I do definitely not want to be petty, I do however think that the 2TB partition limit is an important knowledge regarding GPT vs MBR, in most cases actually more imporant than then number of partitions you can create, which you do mention. But, if this is the kind of response which I can expect if I try to point out something which could have been better, then I'll better keep it for myself.

That said, I do realize that I should have read the article more thoroughly, but I do still think that the 2TB limit should have been mentioned.




Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL
Post #1225056
Posted Wednesday, January 18, 2012 10:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 16, 2012 1:18 PM
Points: 7, Visits: 21
Perry,

This is a little off topic, but I was wondering if you or someone else on this forum have a step-by-step article on how to add high-performance mirroring on a stand-alone server with a failover cluster as the primary?
Post #1238152
Posted Wednesday, January 18, 2012 4:17 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:13 PM
Points: 6,466, Visits: 13,919
Is the stand alone server part of the same domain as the cluster or is it in a workgroup.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1238374
Posted Friday, January 20, 2012 7:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 16, 2012 1:18 PM
Points: 7, Visits: 21
Yes it is. It's off-site at another location, but it's the same domain. I think I know how to do it, I will give it a whirl today and post back if I have a problem. I do have another question. Let's say my current failover cluster is on SQL 2008 R2 Ent. Can I add another node and install SQL 2008 R2 Std? I want to be able to fail the existing instances on ent over to std. Can my cluster be mixed in that way? I know there are some technical differences between ENT and STD like partitioning, but we're not utilizing that.
Post #1239462
Posted Friday, January 20, 2012 12:17 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:13 PM
Points: 6,466, Visits: 13,919
kellithompson (1/20/2012)
Yes it is. It's off-site at another location, but it's the same domain.

That makes things a whole lot easier. Just set mirroring up as defined in BOL. I have a script which you can use if you want it.


kellithompson (1/20/2012)
Can I add another node and install SQL 2008 R2 Std? I want to be able to fail the existing instances on ent over to std. Can my cluster be mixed in that way? I know there are some technical differences between ENT and STD like partitioning, but we're not utilizing that.

You know what never even tried it and can't think why you would want to. I'm sure it would fail and cause issues somewhere along the line so don't


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1239674
Posted Tuesday, February 7, 2012 1:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 16, 2012 1:18 PM
Points: 7, Visits: 21
Perry Whittle (1/20/2012)
kellithompson (1/20/2012)
Yes it is. It's off-site at another location, but it's the same domain.

That makes things a whole lot easier. Just set mirroring up as defined in BOL. I have a script which you can use if you want it.

Thanks Perry, I would like a script. I just wanted to test if I could get a mirror to work between my clustered instance and an offsite instance. I followed the BOL in creating a new database on my primary. Created a table and added some rows. Backed up the DB and the log fille using the proper method. Restored both w/ NoRecovery. Made sure I could telnet to both primary and mirror server on my designated port. I cannot get past the famous 1418 error w/ severity 16, state 1, line 1. I have removed all the configurations and started over 3 times and I must be missing something simple because each time I get the same error. Let me know if you have any advice.

Thanks in advance. KT
Post #1248504
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse