Viewing 15 posts - 16 through 30 (of 1,318 total)
As already stated, this is a one-way upgrade. You can fail over to a higher version but you can't fail back to a lower one. As long as you have...
November 18, 2019 at 9:43 am
This is in the 2008 forum, is it meant to be? If not, which version of SQL will you be using? You usually need a cluster.
November 11, 2019 at 2:53 pm
Yes, don't worry about this. (I would personally cap Max Server Memory at 26 GB on that server, but that's within tolerance.)
November 11, 2019 at 2:48 pm
Could you not just do a backup and restore instead?
November 7, 2019 at 10:18 am
An older version may well be easier to use in this case. Try it with both if you can. I've connected to SQL 2005* with SSMS 18 so it can...
November 6, 2019 at 12:17 pm
Sometimes there is some useful information in the installation log files. The default location is listed here:
November 6, 2019 at 12:15 pm
Yes, it should be ok. The only thing I can think of that might be an issue is that if there is any mirroring in place, sometimes it's not visible...
November 6, 2019 at 10:27 am
In that case you need to put the instance name in here (instead of MSSQLSERVER). Also the port will probably be different:
/INSTANCENAME=MSSQLSERVER
October 23, 2019 at 8:14 am
In addition to what Michael L John has already covered, if you use a secondary replica for reporting, there's a requirement to license that replica as well as the primary.
Also...
October 22, 2019 at 2:52 pm
Have you checked that the endpoints are in a STARTED state?
select * from sys.endpoints
October 22, 2019 at 1:58 pm
I'd go for 2017, personally. Don't bother with 2016 in that scenario.
AndrewL65, do you mind me asking what you're finding interesting about it? (Also, is it true that the cardinality...
October 22, 2019 at 9:05 am
October 21, 2019 at 1:11 pm
How its written for DBAs because they can't code
Charming. I dislike SSIS, and try not to use it. Fortunately I've rarely needed to.
October 21, 2019 at 7:52 am
Viewing 15 posts - 16 through 30 (of 1,318 total)