Viewing 15 posts - 1,936 through 1,950 (of 6,401 total)
The link details 2005 not 2008R2 but it has raised something else to look at changing.
The remote login timeout is set to 15 seconds, going to add a change control...
October 27, 2015 at 6:32 am
Logins exists on both sides of the mirror.
Primary is active 24/7 unless we issue manual failover
Secondary is always restoring
Partner timeout is 60 seconds
No linked servers in the mix.
The jobs all...
October 27, 2015 at 6:14 am
I would recommend SQL Compare from Red-Gate, I use it all the time, great tool.
Others are available, SSDT has one, also one from ApexSQL.
There is a freeware tool called DBComparer...
October 27, 2015 at 5:27 am
Perry's stairway has all the steps necessary on setting up the cluster from the ground up for Always-On
http://www.sqlservercentral.com/stairway/112556/
The share has to be aware from the cluster, eg on your corporate...
October 27, 2015 at 5:13 am
Your loosing quorum so the cluster is going offline.
You need an odd number of objects to get a true quorum, add in a 3rd node or add in a file...
October 27, 2015 at 4:46 am
The 18456 error is happening on the mirror node.
The connection strings / connection managers are all set to point to the principal node.
October 27, 2015 at 4:07 am
Yeah my thoughts where to have 2 DB's one to load the copy of the tables you needed into
Eg, DB1 has TableA_Today, TableA_Yesterday, DB2 has TableA, run a checksum...
October 27, 2015 at 4:04 am
You could also firewall off people from connecting to the DB server by blocking your active port for the instance out for everyone, then only punching a hole into the...
October 27, 2015 at 3:54 am
ChrisM@Work (10/27/2015)
anthony.green (10/27/2015)
Ed Wagner (10/26/2015)
Lynn Pettis (10/23/2015)
Did some one post an ad somewhere that said we had a surplus of silver spoons? :w00t:
I think we always have silver spoons on...
October 27, 2015 at 3:44 am
Does the report have to run as the user running the report?
If not then change the data source to use a generic account to run the queries, this is the...
October 27, 2015 at 3:41 am
Do you need the full source DB or is it just a subset?
October 27, 2015 at 3:26 am
Ed Wagner (10/26/2015)
Lynn Pettis (10/23/2015)
Did some one post an ad somewhere that said we had a surplus of silver spoons? :w00t:
I think we always have silver spoons on hand. ...
October 27, 2015 at 3:15 am
Yep the login is defaulted to master, I am guessing that the initial catalog in the connection string/connection manager is forcing it to ignore the default db and go straight...
October 27, 2015 at 2:37 am
Use a central management server or register all your servers in SSMS and run a query against the registered server group
October 23, 2015 at 8:53 am
Ed Wagner (10/23/2015)
anthony.green (10/23/2015)
djj (10/23/2015)
anthony.green (10/23/2015)
Ed Wagner (10/22/2015)
MathSchool
Study
Invest
Risk
Assessment
October 23, 2015 at 5:42 am
Viewing 15 posts - 1,936 through 1,950 (of 6,401 total)