October 25, 2010 at 12:17 pm
I am trying to copy over 300 databases from the 2005 cluster to a new 2008 cluster. I would perfer to not have to detach the databases because of a need to keep the old cluster in production until the new system is fully tested.
I would like to use a SAN volume other that the default DB location to store the transaction logs.
The copy database wizard defaults both filenames to the default location for .mdf storage. I did change the default transaction path for the cluster but it didn't seem to have any impact on the wizard. Any ideas that will keep me from having to manually change the path over 400 times?
Any ideas would be much appreciated.....
October 25, 2010 at 2:57 pm
Would it be easier to back up the databases, and then generate a restore script that puts the files where you want them?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply