@ypercubeᵀᴹ It's not uncommon for migrations to SO to fail, at least initially. I understand this is mostly about volume/contention, and there is some retry logic. If it doesn't go through after a reasonable period, seems best to hit it with a hammer.
Migrations can fail for other reasons e.g. author being q-banned on the target site, but that's not the case here.
@PaulWhite If there's an attempt to migrate a question to where the OP is Q-banned, will the result be the same as in this case (the question ends up stuck in the Locked state)?
@AndriyM Yes. The final close vote might see a red error message box briefly, but I'm not certain about that, and the message doesn't hang around anyway.
The procedure to move databases seems to involve creating an alias in sql server client configuration
but since sharepoint was installed on the same machine as SQL Server (serverA) and the databases are now moved to serverB I would need to create an alias on serverA redirecting itself to serverB
I'm not too keen on that
since the old server might not be entirely decommissioned and reused for other DEV crap
pointing "localhost" to another server seems a recipe for disaster
Yes apparently the sharepoint best practices say to configure your server with an alias at time of install, so you can point the alias anywhere later on
but that's not the case with this setup
it can be if you are running 2013+
then there is a powershell command to point everything to a new server
this might do the trick I think
beat me to it; what I would suggest is that you setup the alias on the existing SharePoint server so that is c:\windows\system32\cliconfig.exe to launch that enable TCPIP and setup your alias. Then use the command as Steve describes; stsadm -o renameserver -oldservername "OLD_SQL_INSTANCE" -newservername "ALIAS_NAME". Once you've executed this then you can move your databases to the new database server and simply update your alias accordingly. — pigeonJun 15 '12 at 12:15
> This site is currently in read-only mode; we’ll return with full functionality soon. Follow @StackStatus or visit our status blog for more info.
It gets worse
> We apologize for any inconvenience, but an unexpected error occurred while you were browsing our site. It’s not you, it’s us. This is our fault. Detailed information about this error has automatically been recorded and we have been notified.
I did actually laugh when I saw this Azure Data Lake Analytics bug. This is tpc-h test data turning up in the middle of someone else’s Stream Analytics / ADLA job. dbo.lineitem if I’m not mistaken: social.msdn.microsoft.com/Forums/azure/en-US/…
Architect's Prayer God (of Visio), grant me the serenity to accept the Visio I cannot change, Courage to change the Visio I can, And wisdom to know the different versions of Visio, how to use Stencils and other non-specified Visio know-how.
@MaxVernon Don't cross the streams!
I sometimes look at posts (like this one) and think "If you'd have started doing that when you wrote this post, you'd have finished by now." but ...
someone gave me around 300 fixed-width files today, all different tables, different formats, so I'm trying to think of a good way to import them into SQL Server.
Lord knows my BIML is not up to it.
Any suggestions?
I'm thinking about scripting out bcp format files from the respective table definitions but open to suggestions ...
I think it's biml'able but we're in the middle of a minor production fire so my brain isn't fully engaged. Ping me again in 6-ish hours and I'll be able to engage my brain on it
there is progress in SSIS to be released after vNext is GA
so they claim
@MaxVernon They are using "pacemaker" instead of FCS and they think it works, log shipping depends on agent working and AG should work with pacemaker also
I am trying to get a definitive version of what is First Normal Form. Everything I read has a slightly different spin.
Many authorities, such as Date, say that by definition a relation is always in First Normal Form, while others give a list of requirements. This means that there are from zero t...
Verb: define (third-person singular simple present defines, present participle defining, simple past and past participle defined)
To determine with precision; to mark out with distinctness; to ascertain or exhibit clearly.
Sir Isaac Newton
Rings […] very distinct and well defined.
the defining power of an optical instrument
(obsolete) To settle, decide (an argument etc.). [16th-17th c.]
(19 more not shown…)
Noun: define (plural defines)
(programming) A kind of macro in source code that replaces one text string with another wherever it occurs.
1996, James Gosling, Henry McGilton, The Java Language Environment
From the computer programming perspective, Java looks like C and C++ while discarding the overwhelming complexities of those languages, such as typedefs, defines, preprocessor, unions, pointers, and multiple inheritance.
1999, Ian Joyner, Objects unencapsulated: Java, Eiffel, and C++ (page 309)
Anyone who has attempted to do OO programming in a conventional language using defines will find out that it is impossible to realize the benefits easily, if at all, without compiler support.
"Buffalo buffalo Buffalo buffalo buffalo buffalo Buffalo buffalo" is a grammatically correct sentence in American English, used as an example of how homonyms and homophones can be used to create complicated linguistic constructs. It has been discussed in literature in various forms since 1967, when it appeared in Dmitri Borgmann's Beyond Language: Adventures in Word and Thought.
The sentence uses three distinct meanings of the word buffalo:
the city of Buffalo, New York;
the verb (uncommon in usage) to buffalo, meaning "to bully, harass, or intimidate" or "to baffle"; and
the animal, bison (often...
It's time to choose a Question of the Week! The Question of the Week demonstrates what a good on-topic question looks like. Last week, we picked:
What is the importance of the vision document and how it helps development? by user1620696
Suggest the next Question of the Week by answering here wi...