Post reply

Need to move out all db's to mount points

  • January 19, 2013 at 12:37 pm

    #273200

    Hi all,

    Is there any specific technique to transfer/copy/move out all the db's from one drive to another drive?

    I know about detach/attach, alter move the db's and then take the db offline, copy the physical data & log file and then bring the db online. I would like to know is there any alternate way of doing it, may be a better or a faster way. Let me provide you an example

    Currently we have two drives configured (e:\data & f:\logs). We are planning to set up something like this through mount points on separate spindles for each of these for e.g (e:\mount\data, e:\mount\log, e:\mount\tempdb, e:\mount\backups). I also would like to know will we be able to achieve performance with this configuration and how should I monitor that, do we have some kind of counters available for that (pls. don't provide me any 3rd party tool links or references).

    I hope to see some bright responses from experts out here

    Thanks & Regards,

    Faisal

  • January 19, 2013 at 1:18 pm

    #1578989

    faisalfarouqi (1/19/2013)

    Hi all,

    Is there any specific technique to transfer/copy/move out all the db's from one drive to another drive?

    I know about detach/attach, alter move the db's and then take the db offline, copy the physical data & log file and then bring the db online. I would like to know is there any alternate way of doing it, may be a better or a faster way. Let me provide you an example

    Currently we have two drives configured (e:\data & f:\logs). We are planning to set up something like this through mount points on separate spindles for each of these for e.g (e:\mount\data, e:\mount\log, e:\mount\tempdb, e:\mount\backups). I also would like to know will we be able to achieve performance with this configuration and how should I monitor that, do we have some kind of counters available for that (pls. don't provide me any 3rd party tool links or references).

    I hope to see some bright responses from experts out here

    Thanks & Regards,

    Faisal

    Faisal, please don't take me wrong, but have you google this? If you have can you provide the links you have already search. To measure performance of new Servers I use SQLIO before installing SQL Server. There are plenty of blogs on that. If you want to know which counters to check for performance on an existing SQL Server you can find many articles on the internet about it. Brent Ozar has even videos about how to do it. Try searching the web for information and you will find a lot of it.



    My blog

  • January 19, 2013 at 2:07 pm

    #1578993

    Thanks. for a quick response Ignacio.

    To answer your questions, no I didn't search anything on google yet. I suppose these forums are meant to help others find what they are looking for, and things are a little different when you try to help others by sharing knowledge from your own personal experiences. The forums help us come together unanimously and help each one of us for smooth functioning of our work and solve our legitimate problems (at least! that's what I feel).

    Anyways...thanks. for pointing out to those videos from "Brent, Ozar", and thanks to google being a true friend as always.

    Regards,

    Faisal

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply