|
Home > Archive > BizTalk Server General > May 2005 > Moving Biztalk DB's to a different SQL server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Moving Biztalk DB's to a different SQL server
|
|
|
| I have a Biztalk 2004 server using a remote SQL 2000 server for all it's DB's. I now have a new SQL 2000 server in production with the old SQL server being decommisioned soon. How do I move all of Biztalk's DB's to the new SQL 2000 server?
Any help or pointers to documentation would be great.
Thanks,
AV
| |
| Joel West 2005-05-26, 5:55 pm |
| You'll need to take your system offline to do this (and I mean completely
offline, all services/hosts shut down, no db activity at all; consider
putting the dbs into single user mode). Once the system is offline you can
simply use sql's detach/attach to get the databases over to the new server.
If its possible use the same server name for the new sql server as the old
one. Obviously this isn't always possible or practical. If the server has
a different name there is various cleanup you must do to replace the old
server name with the new one. Follow the guidance in
http://www.msdn.microsoft.com/libra...y/en-us/operati
ons/htm/ebiz_ops_backuprestore_prqu.asp.
HTH,
Joel
--------------------
| From: "AV" <dont@got.one>
| Subject: Moving Biztalk DB's to a different SQL server
| Date: Thu, 26 May 2005 13:12:36 -0600
| Lines: 46
| MIME-Version: 1.0
| Content-Type: multipart/alternative;
| boundary="----=_NextPart_000_0006_01C561F4.95E73800"
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <e7JthbiYFHA.3356@TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.biztalk.general
| NNTP-Posting-Host: s142-179-147-100.ab.hsia.telus.net 142.179.147.100
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:14179
| X-Tomcat-NG: microsoft.public.biztalk.general
|
| I have a Biztalk 2004 server using a remote SQL 2000 server for all it's
DB's. I now have a new SQL 2000 server in production with the old SQL
server being decommisioned soon. How do I move all of Biztalk's DB's to
the new SQL 2000 server?
| Any help or pointers to documentation would be great.
| Thanks,
| AV
|
| |
|
| Thanks for the help. Looks like since the new server has a different name
that I've got some work ahead of me.
"Joel West" <jdwest@mail.microsoft.com> wrote in message
news:YKbsbQkYFHA.3052@TK2MSFTNGXA01.phx.gbl...
| You'll need to take your system offline to do this (and I mean completely
| offline, all services/hosts shut down, no db activity at all; consider
| putting the dbs into single user mode). Once the system is offline you
can
| simply use sql's detach/attach to get the databases over to the new
server.
| If its possible use the same server name for the new sql server as the old
| one. Obviously this isn't always possible or practical. If the server
has
| a different name there is various cleanup you must do to replace the old
| server name with the new one. Follow the guidance in
|
http://www.msdn.microsoft.com/libra...y/en-us/operati
| ons/htm/ebiz_ops_backuprestore_prqu.asp.
|
| HTH,
| Joel
|
|
| --------------------
|| From: "AV" <dont@got.one>
|| Subject: Moving Biztalk DB's to a different SQL server
|| Date: Thu, 26 May 2005 13:12:36 -0600
|| Lines: 46
|| MIME-Version: 1.0
|| Content-Type: multipart/alternative;
|| boundary="----=_NextPart_000_0006_01C561F4.95E73800"
|| X-Priority: 3
|| X-MSMail-Priority: Normal
|| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
|| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
|| Message-ID: <e7JthbiYFHA.3356@TK2MSFTNGP15.phx.gbl>
|| Newsgroups: microsoft.public.biztalk.general
|| NNTP-Posting-Host: s142-179-147-100.ab.hsia.telus.net 142.179.147.100
|| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
|| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:14179
|| X-Tomcat-NG: microsoft.public.biztalk.general
||
|| I have a Biztalk 2004 server using a remote SQL 2000 server for all it's
| DB's. I now have a new SQL 2000 server in production with the old SQL
| server being decommisioned soon. How do I move all of Biztalk's DB's to
| the new SQL 2000 server?
|| Any help or pointers to documentation would be great.
|| Thanks,
|| AV
||
|
|
|
|
|
|