Viewing 15 posts - 3,541 through 3,555 (of 9,241 total)
znetznet (2/19/2014)
Provider=SQLOLEDB;Data Source=.\MyMACHINE\SQLEXPRESS;Initial Catalog=mydbase;Integrated Security=SSPI;
when I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 7:26 am
Yuri55 (2/20/2014)
no, it (failover) did not happen yet 🙂
We recently moved standalone server to cluster one but on Active node put Service Start Mode to Automatic one...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 6:27 am
Lempster (2/20/2014)
By 'pretty much' I meant because mirroring involves the transaction log
everything involves the t-log, it's an integral part of the database structure
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 5:15 am
TerrenceTheCat (2/20/2014)
Just a quick follow up....
From your guidance I was able to track down a hourly full backup that was being undertaken outside of the SQL Server by a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 4:38 am
on server 2008 onwards the default option is to logoff, you dont see the old style logoff or shutdown. Main reasson for preventing users from connecting diectly to the server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 4:36 am
MysteryJimbo (2/20/2014)
No, I still disagree.
Really??? You wouldn't be the first :Whistling:
Perform the following and read my guide at this link[/url], then tell me if you still disagree
take full backup on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 4:09 am
Lempster (2/19/2014)
Pretty much the same way. Check out this link:http://technet.microsoft.com/en-us/library/ms189852(v=sql.105).aspx
Regards
Lempster
The synch method between LS and mirroring are completely different. LS involves sending t-log backups across the network to the secondary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 3:32 am
MysteryJimbo (2/20/2014)
george sibbald (2/19/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 3:30 am
Yuri55 (2/19/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 2:09 am
oskargunn (2/18/2014)
Ok, so it requires that Windows Failover cluster feature is installed.Thanks for the info, and btw awesome Article on AlwaysON 🙂
If you like that you'll love this[/url], in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2014 at 11:45 am
oskargunn (2/18/2014)
Hello,I´ve been reading that SQL Server 2012 Always On is dependent on having a Windows Failover Cluster setup. Is that correct ?
Yes, for more information see my guide at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2014 at 8:00 am
Are the servers on separate sites?
In this scenario you should work to get the principal online as soion as possible, i've never tested but with both witness and principal down...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2014 at 5:42 am
k.arkenau (2/17/2014)
I got a problem with a user who needs to log on to the integration services.
The user ist is "sysadmin" on the SQL Server and I granted him...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2014 at 10:50 am
lmpotthoff (2/16/2014)
I've opened port...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2014 at 10:38 am
Welsh Corgi (2/11/2014)
The article listed below describes the action necessary to do so:
http://dba.stackexchange.com/questions/37583/moving-sql-server-to-different-domain
Does anyone have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2014 at 10:31 am
Viewing 15 posts - 3,541 through 3,555 (of 9,241 total)