Re: Move databases between servers

You will want to transfer the logins and passwords:

HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133

Then you will want to move your databases.
BACKUP and RESTORE and sp_detach_db and sp_attach_db work very well. Both
are documented within Books Online.

If you move your msdb database you will want to update originating_server
within the sysjobs table. Change the old server name so that it matches the
new server name.

--
Keith Kratochvil


"Tarek" <Tarek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A8B2E822-7EA3-4274-9E36-87441141FA52@xxxxxxxxxxxxxxxx
Hi,
I want to move my databases from an old server to a new one.
We have bought new hardware and installed sqlserver.
New Version is sqlserver 2000 with sp4.
Old version was sqlserver 2000 with sp3.
What is the best way to move those databases (about 20 db's) from one
server to the new one?
Is there a document or guideline to follow?
Thanks in advance.



.

Relevant Pages

  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)
  • Re: Open DB using OLE DB
    ... In the DataSource setup, once the user enter the server name, it will ... Can I get the list of databases available ... May I know why do you recommend getting away from user IDs and passwords ... > Windows Authentication instead, ...
    (microsoft.public.vb.general.discussion)
  • 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... the server. ... MSDE either from the Setup or from the SQL2KDeskSP3 execute. ... it does look like some of the sample databases have been ... >> and they directed me to install MSDE and they attached a ConfigSamples ...
    (microsoft.public.sqlserver.msde)
  • RE: Server Explorer & Databases
    ... As for the visual studio's database server explorer, ... oracle, visual studio generally use the OLD DB provider which is for Oracle ... and support of most general funcctionalitis in latest version of Oracle. ... #Server Explorer for Oracle Databases ...
    (microsoft.public.vsnet.ide)
  • Re: 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... The fact that the other databases exists phyiscally doesn´t mean that they ... can try to connect to SQL Server using OSL or a GUI. ... The Command OSQL ist for the commandline under DOS. ... > this MSDE either from the Setup or from the SQL2KDeskSP3 execute. ...
    (microsoft.public.sqlserver.msde)
Loading