Viewing 15 posts - 3,361 through 3,375 (of 9,253 total)
No, I think the SPN formats section is getting people confused, it's an either\or situation. If you check the material it's detailed that when using TCP an SPN is always...
April 17, 2014 at 9:09 am
Francis Apel (4/16/2014)
Bill (DBAOnTheGo) (4/16/2014)
April 16, 2014 at 10:23 am
Cody K (4/16/2014)
Perry Whittle (4/16/2014)
You'll always deploy to a dev and\or test system first so you'll know beforehand if the patch has an impact.
Sure, in the land of unlimited budgets....
April 16, 2014 at 9:35 am
the first question is, which protocol are you using to accept connections to your sql server, which protocols do you have bound?
from memory IPX\SPX would not be able to provide...
April 16, 2014 at 6:00 am
Jagadeesh Chowdary (4/16/2014)
Can please Elaborate the above Step.
I have observed that restore job is not running and showing the following error message but when i checked that all the...
April 16, 2014 at 5:37 am
It's a permission issue on the AD side, you'll need to pre stage the VCO, this link gives more detail
April 16, 2014 at 5:27 am
firstly check permissions to the backup share location where the log backups are to be copied from. The sql server agent service on the LS secondary will need permission to...
April 16, 2014 at 5:09 am
The fact that there is an ALTER statement to achieve this should assure you it's a supported action 😉
Internally within the system, filegroups are referenced by their allocated id "data_space_id"...
April 16, 2014 at 5:06 am
I'm astounded, after picking myself up off the floor in amazement let's look closer
Francis Apel
Probably the biggest reason someone would choose to cluster...
April 16, 2014 at 4:37 am
Microsoft introduced the ability to modify user database file paths for a very good reason, so you don't have to detach databases.
Whilst it may seem a good idea I'd prefer...
April 15, 2014 at 9:32 am
mlwiller2 (4/14/2014)
But yeah its x86. Both SQL (standard) and windows server 2003 (standard) are 32bit versions.
Unfortunately, with Windows 2003 Standard 32 bit the OS will not support more than 4GB...
April 14, 2014 at 2:18 pm
balasach82 (4/11/2014)
SQL 2008
For the above configuration, is there a way or query to find if the Cluster is active/active or active/passive or active/active/passive...
April 14, 2014 at 2:08 pm
Lynn Pettis (4/12/2014)
Port1433 (4/12/2014)
I can't grasp the meaning of instance as it is being used in various contexts. For example SQL SERVER 2000,SQL server 2005, SQL Server 2008 and...
April 12, 2014 at 12:17 pm
I think what you're asking is can you 2 separate Availability groups. Yes you can. What are you trying to achieve though?
April 11, 2014 at 7:31 pm
Viewing 15 posts - 3,361 through 3,375 (of 9,253 total)