Upgrading from SQL Server 2008 to 2012

Associate
Joined
22 Nov 2007
Posts
1,707
Location
Staffordshire
I might have to do an upgrade from SQL Server 2008 and 2012. I'll be honest, apart from a few SQL statements (select, update, insert, etc), I know nothing about SQL Server.

The DBAs at work have refused to do it as they don't look after the database so it's left to myself and another guy who's got some knowledge.

Does anyone have an idiots guide to do this?

I can take a snapshot of the server before doing the work in case there's an issue, but I would prefer to do it right the 1st time.
 
Cheers buddy, thought it would be a simple process. Is there anything I should look out for that might cause issues?
 
Brilliant stuff.

I've been given the go a head to start the process so I'm going to start planning it with the relevant members of staff.
 
I done the upgrade yesterday, had a few issues but that was down to permissions, which I managed to sort. A lot easier than I thought tbh
 
Back
Top Bottom