Transfer of Master database in SQL 6.5

[Gerald Reinders]

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 ???

[Craig]

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 ???