Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TreeDude
Starting Member
2 Posts |
 Posted - 2009-04-02 : 11:31:52
|
| Hi everyone,We just had our SQL admin (among other things he did) quit. So I now have the task of managing our SQL server (I have a little knowledge of SQL, but not a whole lot, luckily I am a pretty fast learner). We were on the path to upgrade it as it is pretty much maxed out and cannot take anymore databases. The current setup is 2 dual core Xeon 5160s and 16gb of ram running Server 2003 R2 and SQL 2005 (all 32bit).I already know the hardware we want (2 quad core Xeon 55xx series and 32gb of ram) as he had it speced out before he left. But what do I do about OS and SQL version? I know he wanted to go 64bit, but can I go with Server 2008 and SQL 2008? Will I be able to run some sort of compatibility mode for my current databases till they natively support 2008 (I know if 2005 you can set a database as being from a different version of SQL, not sure how well it works though)? I know they are all fine on 2005 right now. We don't really have any SQL devs, all of our databases are from third party software, so I don't really need to worry about that aspect.This will probably be a slow migration. As long as I can get a few databases off the main server it will give me enough headroom that we can move forward getting some of our other servers off of using MDSE (we have a few that are not performing that great but we can't risk taxing the main server anymore). |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-04-02 : 11:41:47
|
| RE: running database in older compatability level inside 2008 - when you restore from a 2005 backup file inside 2008, the database compatability level remains at the 2005 level. |
 |
|
|
TreeDude
Starting Member
2 Posts |
Posted - 2009-04-02 : 11:52:30
|
| Is that something that generally works well? I know compatibility modes sometimes are not perfect (I keep thinking of the compatibility modes in XP and Vista and how much they don't work a lot of the time) |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-04-02 : 12:10:56
|
| Congratulations on your unexpected promotion!________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
|
|
|
Just got a SQL server tossed at me...