Re: Move System BD's?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: AnthonyThomas (Anthony.Thomas_at_CommerceBank.com)
Date: 12/14/04 

Date: Mon, 13 Dec 2004 20:10:54 -0600

The only issue with moving the master database is that you install the same
Version and Edition and Service Pack and Hotfix level. After that, you can
move the old master in place of the new one. Be careful that the SQL Server
service accounts have login privleges to the old master before you bring it
offline. After the old one is on the new server, execute the sp_dropserver
sp_addserver with local parameter so the old master knows which host it now
resides on.

Again, the biggest challenge for jobs and the use of the old msdb database
is one of permission and the SQL Server service accounts.

Sincerely,

Anthony Thomas 

-- 
"Rick Sawtell" <quickening@msn.com> wrote in message
news:%233nfhHW4EHA.3416@TK2MSFTNGP09.phx.gbl...
Which system databases specifically are you referring to?
You cannot move the master database.  Tempdb would be a worthless exercise
to move.
You can backup the model and restore it as well as the msdb database,
however with a new ServerName, you may have some issues with jobs performing
properly from the msdb database.
Replication will be a problem if you are using it.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Steve Gould" <steve.gould(at)apawood.org> wrote in message
news:eSeIYzV4EHA.4092@TK2MSFTNGP14.phx.gbl...
>I am getting ready to move SQL server from a failing server to a new one.
>It houses Great Plains and SQL 2000. I want to move the system databases
>also.
> I am having a hard time finding the correct KB article to tell me how to
> move the system databases. Can someone point me in the right direction?
>
> Thanks
>

Relevant Pages

  • Re: unable to start SQL Service ... error code 3417
    ... How about just create a new instance and restore databases to the new instance? ... I wouldn't go with restoring master from another instance. ... The supported route is to rebuild your master database, start SQL Server in single user mode, ...
    (microsoft.public.sqlserver.server)
  • Re: FK Relation
    ... >Yes the detail table has cascading delete too(at database level). ... >I use to connect ADO and OLEDB provider for sql server. ... Do you have any triggers on the Master table that update the master based on ... Borland's ADO components use all the fields in the record's selected fields to ...
    (borland.public.delphi.database.ado)
  • New Login Question
    ... I have been programming with Sql Server 2000 for 2-3 years ... I noticed that at the bottom of the New login dialog there ... One selects a database to log in to ... dropdown always has master listed. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Disaster Recovery
    ... You can start sql server without the master database as follows. ... start SQL Server in single user mode to restore the master database. ...
    (microsoft.public.sqlserver.server)
  • Cannot open database Properties window
    ... I'm trying to open the master database Properties window when running SSMS as ... a local user which I have only created a sql server login for it. ...
    (microsoft.public.sqlserver.security)