April 24, 2008 at 8:06 am
Hi all,
tomorrow we going to change disk system from a MSA to an EVA of a server with SQL Server 2000 SP4.
it has files of SQL Server(.EXE, binn, dll, ......) in C:, some database´s files in D: and other database´s files in E:
Do you think that if we add two disk (F: and G:), then we copy, with MSSQL service stopped, all folder and files of units D and E to F: and G: units and finally we rename the new units F: and G: by D and E: and then start SQL server service, would run properly?
many thanks and regards for all
April 24, 2008 at 8:47 am
Jose,
In theory that should work. Naturally I'd test this on a test box or somewhere.
Another option would be to detach the databases, move them to the new drives and reattach them. That way you wouldn't need to change the drive letters - but if you're going to change the drive letters anyway then you might as well stick with your original plan.
April 24, 2008 at 8:57 am
It should work. SQL server just looks at paths. Be sure the entire path is the same.
Alternatively you could "move" the current databases, detach and attach on the new drives if they're attached.
April 24, 2008 at 9:08 am
thanks a lot for your help. i tried it yesterday and it worked but i´m afraid to do it while the people its working. I´ll adivise you when i know the real result.
In the server we have 20 databases more or less if we stop the services and we copy the tree files directory and after change the drive letters and finally we start the services it´s fast and it work ok.
I tested intall SQL server in c: and after move all databases ( system and users ) to d:, after copy database files to other drive e:, finally we change the drive letters and start the services and it worked properly.
Thanks again and pray with me jejejejej
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply