Viewing 15 posts - 286 through 300 (of 5,394 total)
I am right in thinking that the instance root directory (instance configuration screen) is for the binaries and the data root directory (data directories) is where I can point...
November 2, 2015 at 9:12 am
SQLRNNR (10/31/2015)
For thread posterity: [/snip]
Great picture!
It was fantastic meeting you guys!
BTW, Wayne is as tall as me, so he's the giant 🙂
November 2, 2015 at 2:27 am
How many instances are running on that cluster?
Mixing service pack levels is supported.
You can have different instances with different service pack levels.
What is not supported is having the same...
October 15, 2015 at 3:15 am
elmnas (9/15/2015)
(it's very important that I don't modify/change/delete any data on any circumstances)
Then don't use a production database. Making changes to a test database would have less dire consequences.
Moreover, if...
September 15, 2015 at 8:43 am
Paresh Motiwala (9/15/2015)
I Cannot load sql server logs.
SQL Server logs are simple text files. By default, you will find them in the data root, under the Log folder. File names...
September 15, 2015 at 8:41 am
The page you linked describes how to change the server collation. It should work and if it doesn't check the setup logs for errors.
However I'm under the impression that you...
September 15, 2015 at 3:27 am
BallaKet (9/9/2015)
I followed the instructions you gave me (I hope I followed your instructions correctly) and here are the error messages;
Instruction (part 1):
Don't bother changing the parameters of the service,...
September 9, 2015 at 5:26 pm
Blackdog (9/9/2015)
Just got confused!
You're not alone. Bad move from MS in my opinion.
September 9, 2015 at 2:35 pm
Don't bother changing the parameters of the service, jut run it manually.
Stop the service, open the service properties and copy the executable location. Paste it to a new command prompt...
September 9, 2015 at 2:33 pm
AlwaysOn Failover Clustered Instances is available in Standard edition, limited to 2 physical nodes.
"AlwaysOn" is a marketing name and it does not correspond directly to a single feature. Stop using...
September 9, 2015 at 6:55 am
MAX columns accept data up to 2GB of text.
If the text is truncated, it may be due to some function you're applying to the data before inserting. For instance, REPLICATE...
September 9, 2015 at 3:29 am
Oh, I see. Bad day...
You should be fine restoring your master database. What error are you getting?
September 8, 2015 at 3:57 pm
You have everything you need in the script I linked in my previous reply.
September 8, 2015 at 12:20 pm
If I understand correctly, you are moving your default and sharepoint instances from a previous server.
I have no direct experience with moving sharepoint databases, but I suspect that restoring...
September 8, 2015 at 12:17 pm
There's an undocumented function that could help you here. It's called fn_replgetparsedddlcmd and is used by replication. Basically, it parses the DDL commands and strips away the CREATE part, that...
September 8, 2015 at 11:35 am
Viewing 15 posts - 286 through 300 (of 5,394 total)