network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 7 months |
| seen | May 10 at 0:16 | |
| stats | profile views | 10 |
|
May 8 |
accepted | How does SQL Server AlwaysOn work with help with scheduled jobs and SSIS packages? |
|
Apr 24 |
awarded | Popular Question |
|
Dec 12 |
comment |
How does SQL Server AlwaysOn work with help with scheduled jobs and SSIS packages? That's sounds promising. I only want the jobs to run on the primary server (which ever server that may be at the time). |
|
Dec 11 |
asked | How does SQL Server AlwaysOn work with help with scheduled jobs and SSIS packages? |
|
Dec 10 |
accepted | How to handle sql server database logins when using AlwaysOn. (they aren't syncing) |
|
Dec 6 |
awarded | Teacher |
|
Dec 6 |
revised |
How to handle sql server database logins when using AlwaysOn. (they aren't syncing) deleted 1 characters in body |
|
Dec 6 |
comment |
How to handle sql server database logins when using AlwaysOn. (they aren't syncing) I figured it out and posted a new answer appropriate for AlwaysOn. |
|
Dec 6 |
answered | How to handle sql server database logins when using AlwaysOn. (they aren't syncing) |
|
Dec 6 |
comment |
How to handle sql server database logins when using AlwaysOn. (they aren't syncing) Keep in mind that I am asking about AlwaysOn, not mirroring. I tried the script, however the sys.servers table only contains the local server so I get the following error when I run the stored proceedure: Msg 7202, Level 11, State 2, Line 1
Could not find server 'otherserver' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. |
|
Dec 5 |
asked | How to handle sql server database logins when using AlwaysOn. (they aren't syncing) |
|
Oct 24 |
awarded | Supporter |
|
Oct 24 |
accepted | Can the SQL Server 2012 Always On feature provide seamless failover (with no query failures)? |
|
Oct 24 |
comment |
Can the SQL Server 2012 Always On feature provide seamless failover (with no query failures)? Perfect, thanks! |
|
Oct 24 |
comment |
Can the SQL Server 2012 Always On feature provide seamless failover (with no query failures)? I see, so that requires a smarter client app. |
|
Oct 24 |
awarded | Editor |
|
Oct 24 |
comment |
Can the SQL Server 2012 Always On feature provide seamless failover (with no query failures)? With "read-only secondaries" enabled, do any read requests occur on the primary or are they always done on the secondaries? And what happens if the secondary server has a fault in that situation? |
|
Oct 24 |
revised |
Can the SQL Server 2012 Always On feature provide seamless failover (with no query failures)? added 97 characters in body |
|
Oct 24 |
asked | Can the SQL Server 2012 Always On feature provide seamless failover (with no query failures)? |
|
Oct 17 |
comment |
Does Sql Server 2012 Always On support Active/Passive? Thanks. Apparently this isn't a simple question... I was on the phone with Microsoft for an hour and was then required to wait for an email response. To sum it up, active/passive is possible when using Always On, however there are some Always On features which require Active/Active. |
