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 |
|
bigmac5454
Starting Member
3 Posts |
 Posted - 2014-05-28 : 11:39:30
|
| Hi Anyone have any instructions on moving the sql 2005 databases to a new sql2012 physical server with a new name. |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2014-05-28 : 11:56:32
|
| I have not done that myself. But, I'm pretty sure that you can just do a backup and restore. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-28 : 12:08:12
|
| We used backup/restore with full, diff and log backups. You can also use mirroring or log shipping.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
bigmac5454
Starting Member
3 Posts |
Posted - 2014-05-28 : 12:43:08
|
quote:
Originally posted by tkizer
We used backup/restore with full, diff and log backups. You can also use mirroring or log shipping.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
Since the physical server will be a new name doesn'r code have to be changed to point to the server, like the apps, also we have to create all the users? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-28 : 12:46:28
|
quote:
Originally posted by bigmac5454
quote:
Originally posted by tkizer
We used backup/restore with full, diff and log backups. You can also use mirroring or log shipping.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
Since the physical server will be a new name doesn'r code have to be changed to point to the server, like the apps, also we have to create all the users?
Yes connection strings will have to change unless you are using a DNS alias. But that's not something a DBA handles.Yes you'll need to create any logins, jobs, etc. Anything outside of the user database will need to be scripted.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-05-29 : 01:51:00
|
| Running Upgrade Advisor is useful , it may highlight some obvious issuesJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
bigmac5454
Starting Member
3 Posts |
Posted - 2014-05-30 : 12:45:07
|
quote:
Originally posted by jackv
Running Upgrade Advisor is useful , it may highlight some obvious issuesJack Vamvas--------------------http://www.sqlserver-dba.com
Thanks where do I get upgrade advisor and how to run. I going to move the sql 2005 databases to sql 2012. Do I run the advisor on the sql 2005 box? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-06-02 : 14:49:40
|
| The upgrade advisor comes with SQL Server 2012 feature pack. Point it at the target sql server instance and it will create a report for you. Look for SQLUA.MSI and choose the relevant architectureJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
sql 2012 qnd 2005