dcsimg
Results 1 to 2 of 2

Thread: Transfer of Master database in SQL 6.5

  1. #1
    Gerald Reinders Guest

    Transfer of Master database in SQL 6.5

    We are currently in the process of transferring a database from one server (sql 6.5) to another (SQL 6.5) but in order to successfully transfer the database we have to transfer the master database first. Any ideas on how to transfer the Master database successfully ???


  2. #2
    Craig Guest

    Transfer of Master database in SQL 6.5 (reply)

    For the best way is to:
    * Stop sql server and agent on source
    * Rename mssqldatamaster.dat to master.original on destination
    * Copy source master.dat to destination master.dat
    * Reboot destination
    * sp_dropserver and sp_addserver servername, local

    Good to go. This is the easiest way for a one-time deal.

    Craig


    ------------
    Gerald Reinders at 6/14/00 4:48:44 AM

    We are currently in the process of transferring a database from one server (sql 6.5) to another (SQL 6.5) but in order to successfully transfer the database we have to transfer the master database first. Any ideas on how to transfer the Master database successfully ???


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •