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 |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2012-05-09 : 10:23:21
|
| Hello All,We have SQL 2005 SP2 server and we need to move it to VM keeping the SAME NAME. When I install SQL server, I don't want to create new system databases (msdb, master and model) as we have our logins, jobs, dtsx there. Is there any way I could install the SQL 2005 without system databases and then move these DBs from old box to the new by backup and restore. Or I can overwrite these DBs if that's the way to go.Also, this server has SSRS service and a few important reports. Will they have any impact as I will be installing SSRS also. I donlt know where the DataSource and security reside.Please provide suggestions so the migration would be smooth.Thanks much, |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-05-09 : 15:17:08
|
| Have you spoken to the VM administrator about doing a Physical to Virtual Migration (P2V)? Obviously , if you're changing OS it's a problem.If you do a new install - the system databases are created. You can migrate the relevant dataJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Moving databases to VM