Post reply

Moving databases from SQL7 to clustered SQL server

  • December 16, 2003 at 6:48 pm

    #66232

    I have a SQL7 server that is quickly running out of space. We have critical databases that need to be move to SQL 2000 server on our SAN. I was planning on using DTS to move them. I know you can't move Master database to SQl 2000, What is the best way to move the logins. Also, the SQL 2000 server have other databases running on it. What is the best to proceed.

  • December 16, 2003 at 7:52 pm

    #486552

    s_detach_db/sp_attach_db or backup/restore.

    For login/password transfer, See http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql2k

  • December 18, 2003 at 6:53 pm

    #487127

    Allen

    Should I use DTS or Backup/Restore? I also want to keep the old database server in case things don't work out. This will be my first time with moving databases in SQL.

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

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