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 Tuesday, February 7, 2012 2:32 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
kellithompson (2/7/2012)
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

Nevermind. I finally got it working. Because of the failover cluster, I want to use high safety w/o auto failover (synchronous), right?
Post #1248529
Posted Tuesday, February 7, 2012 4:04 PM


SSC Eights!

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

Group: General Forum Members
Last Login: Monday, June 30, 2014 5:15 AM
Points: 827, Visits: 1,361
If I don't recall something wrong: are the two instances running under the same domain account? Have you verified that this account has sufficient permissions?



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

Concatenating Row Values in Transact-SQL
Post #1248607
Posted Thursday, February 9, 2012 8:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 6,191, Visits: 13,340
kellithompson (2/7/2012)
Nevermind. I finally got it working. Because of the failover cluster, I want to use high safety w/o auto failover (synchronous), right?

Offhand i'm not entirely certain, what makes you think that? You would at least need to ensure that you adjust the mirroring timeout to take account of the cluster failover time. The default mirror timeout is 10 secs and i'm guessing your cluster failover takes longer than that.


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1249736
Posted Friday, January 4, 2013 2:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 11:22 AM
Points: 2, Visits: 59
When mount points are being used together with the physical disks, each mount point must appear as a cluster resource. Additionally, each mount point must also be added as a SQL Server dependency. If only the root physical disks dependency is added and the mount points are not added, database corruption will occur on failover. Database corruption may also occur when SQL Server is restarted without failing over (http://support.microsoft.com/kb/819546).
Post #1403127
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse