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 |
|
shaunos
Starting Member
8 Posts |
 Posted - 2011-03-09 : 06:08:45
|
| Yes we are finally dragging our comapanys infrastructure from the renaissance to 2011! :)We are about to upgrade OS and databases to 'modern' versions.We currently have our main database running sqlserver 2000 on a windows 2000 box.We will be upgrading to sqlserver 2008 on a windows server 2008 box.We plan to do this in a test environment before rolling out the new server into a production environment...I have been reading up on the process but there is nothing like real life experience so if anyone here has done it, please send on any info/links and gotchas to look out for.Cheers,~Shaun. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-03-09 : 07:09:38
|
Welcome to the 21st century  You need to post more info of your current server environment,no of databases,their sizes,does it host any replication or log shipping set up etc etc..PBUH |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-09 : 07:31:41
|
| Well...the first thing you need to do is to run the upgrade advisor. If you don't know about it it's a little program that comes in the installation package of sql server 2008 (or you can download it individually) that analyzes your current installation and tells you what is not compatible and if you're using any features that are deprecated.- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
|
|
shaunos
Starting Member
8 Posts |
Posted - 2011-03-11 : 06:15:27
|
| Hi,Thanks for all the replies.In terms of the size of things there are maybe 3-4 major databases each around 10-15 gigs in size and approx 10 other much smaller ones.We have some DTS packages in place, created by the previous masters :) but we have been phasing these out anyway in recent times, I understand there is a tool available to migrate these anyway if necessary. Anyone had any experience with this?There is no replication in place.dinakar, I appear to have a more concise version of that file already, but I'll have a look at that too. Thanks..I have run the advisor already and the report doesn't look too scary tbh, a few stored procedures that need some tweaking and some permissions issues around jobs, some dlls need full paths registered but nothing too daunting by the looks of things (he says naively).Most of our systems run an access front end with linked tables via ODBC connection to database.We plan to do a kind of side by side migration in that we can use disaster recovery tools to do a complete restore of the entire database server and contents onto another box and put it in a test environment with our new server so we can test the process and then hopefully just restore the latest version of the databases prior to putting it into production.We hope to have a complete mini network with new domain controller, new SQLServer database and a few client machines to test the c%^p out of all functionality prior to go-live.It all sounds so easy when you wite it like that :) though I'm sure I'll be somewhat follically-challenged by the end!~S. |
|
|
|
|
|
|
|
|
sqlserver2000 -> sqlserver2008