Results 1 to 13 of 13
-
12-03-2019, 11:40 AM #1
IT Mags - updating SQL database MDF file
I know a couple of you know how to do this. I have a SQL database that needs to be updated/upgraded from sql 2008 to 2017. I imagine it is a very simple procedure, but I'm not familiar with it and my IT department is mostly non-responsive until you tell them exactly what you need and how to do it.
From what I've found so far, it seems like you just need to open and close it from the SQL server manager. Is that it?I've concluded that DJSapp was never DJSapp, and Not DJSapp is also not DJSapp, so that means he's telling the truth now and he was lying before.
-
12-03-2019, 03:17 PM #2
really big picture - back the database up and restore on new sql server
it will be running at the 2008 compatibility level. this is probably what you want if you have applications running on it that aren't upgraded to run on the SQL version of the new server
-
12-03-2019, 03:53 PM #3
-
12-03-2019, 03:56 PM #4
Fuck IT departments. This exact issue is why we're moving more and more to SAS. Can't get those guys to do shit. And when they do they fuck it up. I'm two years behind on a major enterprise wide application because they can't seem to upgrade the SQL.
Start moving all your stuff to the cloud and have the real pros take care of it.
-
12-03-2019, 04:17 PM #5
Ok - then run a sql script on the database to set the compatibility to the correct level
Put in a support ticket with the vendor and ask for the upgrade documentation
Sent from my iPhone using TGR Forums
-
12-03-2019, 05:05 PM #6
you really should do all this in test first...
-
12-03-2019, 06:51 PM #7
+1 to having a back up (or two) before attempting that kind of upgrade.
Go that way really REALLY fast. If something gets in your way, TURN!
-
12-04-2019, 12:06 AM #8
Move to AWS while you’re at it and can the IT staff if they can’t figure out dba basics.
-
12-04-2019, 01:35 AM #9
-
12-04-2019, 02:09 AM #10
Living on the edge!
DJ, what about new SQL licenses? Included with the app software or purchased separately?
Does performance matter for this app? How large is the db and how many users? Physical server or Vm? What kind of disks? Sql on the same sever as the app? (Not good)
Make sure at least to set min/max memory on SQL do you don't overallocate on your server. Leave at least 4gb free for the opsys.
Sent from my SM-A505FN using Tapatalk
-
12-04-2019, 08:25 AM #11
-
12-04-2019, 12:00 PM #12
The IT gang got it done last night. Thanks all.
I've concluded that DJSapp was never DJSapp, and Not DJSapp is also not DJSapp, so that means he's telling the truth now and he was lying before.
-
12-04-2019, 10:26 PM #13
Bookmarks