SQL server to SAN

  • Hi to all,

    In a few weeks our SAN will be operational and we have to move our data files to it. Basically this is just a copy past action from server to LUN, but I wonder if there are more detailed action needed (to upgrade performance such as I/O matters, backup, log files, log shipping, disaster management etc etc)?

    And how to handle the OLAP environment which is based on some of our OLTP database?

    And how to deal with high availability clusters? 

    Who has any experience or where can i find a "best practice" on this.

    Microsoft and Dell are just telling me about the technical specifications but i'm more interested in the operational part.

    GKramer

    BTW using SQL server 2000 sp3a / evaluating SQL server 2005 ( Yukon Beta 2 )

     

  • This was removed by the editor as SPAM

  • when we moved re rebuilt the server and then ether restored the databases or copied them over. We scripted out all users,permissions, and user objects stored in system databases. I belive it was much easier than trying to restore master on each server. For the clusters you will have to rebuild you can't copy the quarum drive to the san and have it work properly.

    Wes

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

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