Post reply

Running rebuildm in SQL server 2000

  • December 12, 2007 at 1:11 am

    #71198

    Can anyone tell me how long it will take to run the rebuildm as I need to change the SQL Server collation. We have just migrated to new servers and are getting collation errors but are live on the new servers (the old ones have been de-commissioned so cannot go backwards). The total size of all the databases is 1224mb but those that need to change (i.e. the defaut Master, Tempdb etc) are only a total of 71mb.

    Any further advice/information you can give would be appreciated.

    Thanks,

    Sonia

  • December 12, 2007 at 2:08 am

    #759298

    hi,

    I already did it on production server, you need to be careful. (it could take a long time a couple of hours, but if you are well organized it just fews minutes).

    Your server will be down during the process.

    Check the following link it's the best (follow the following phases in the link bellow)

    http://www.informit.com/articles/article.aspx?p=27566

    For logins transfer

    http://support.microsoft.com/kb/246133

    Regards,

    Ahmed

  • December 13, 2007 at 4:50 pm

    #760051

    Hi Ahmed,

    Thank you very much for this it will be a great help. I plan to do it on Monday morning.

    Thanks again,

    Sonia

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

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