Unsolved
This post is more than 5 years old
20 Posts
0
1244
March 2nd, 2012 07:00
SQL 2005 Database Migration Scripts
mSpecialist,
Does anyone have any scripts or documents readily available regarding the migration of SQL 2005 databases, logs, master, model databases etc from one set of LUNs to another? The host will be the same just difference storage arrays, SQL 2005 database mirroring cannot be used as it will not migrate the master, model databases and requires a new SQL instance on the same host!
Thanks
Mike
No Events found!
LouisLu
161 Posts
1
March 5th, 2012 23:00
Mike,
We believe many method can database in SQL 2005. Could you elaborate further on your requirements of migration? Generally speaking, procedure is divided to two type: moving database files within the same instance of SQL Server and move a database to another instance of SQL Server or to another server.
The different procudures correspond to different methodology, such like moving DB, backup and restore and attach/detach.
As we knew, EMC SANcopy is also a competive option, which depends on specific require?
Lu
Mike_Kiersey
20 Posts
0
March 6th, 2012 01:00
All,
Thanks for all your responses on this, I now have a number of different approaches to move application specific SQL databases and SQL Server system databases using
Thanks for all your responses and ideas.
Mike