Re: Moving SQL Databases.

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

From: John Bandettini (JohnBandettini_at_discussions.microsoft.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 08:11:09 -0800

Jeff

Here are some more links you might find useful

http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf http://www.support.microsoft.com/?id=307775 Disaster
Recovery Articles for SQL Server

Hope this helps

John

"Yih-Yoon Lee" wrote:

> Hi Jeff,
>
> There is a step by step guide for doing this from Microsoft. Take a look
> at this article. There are other things to consider other than moving
> the databases itself.
>
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
>
> Either backup/restore or attach/detach will work fine. I may go for
> backup/restore since the backup file might be smaller than the actual
> file and you can keep the original server up and running until the new
> server is ready
>
> If your server settings are exactly the same as the old machine (server
> installation path, drives assignment etc), it is even simpler. For more
> details, look at my post
> http://groups-beta.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/a9ea3d1f09a92346/6bcba5592c502b09?q=Yih-Yoon+Lee+move+database+copy&_done=%2Fgroups%3Fq%3DYih-Yoon+Lee+move+database+copy%26&_doneTitle=Back+to+Search&&d#6bcba5592c502b09
>
> Yih-Yoon Lee
> My blog http://www.mssql-tools.com/blog
> E-mail: yihyoon.online@gmail.com
> /* remove .online to send me e-mail */
>
> Jeff wrote:
> > Greetings Everyone!
> >
> > I currently have a Win2000 Server running SQL 2000 with cubes and databases
> > running properly. I want to add more but my current server is not strong
> > enough.
> > So we have purchased a new server with Win2003 Server.
> > I have installed SQL Server 2000 on the new server as well.
> >
> > I know there are many different ways to transfer the databases and cubes
> > from the old server to the new.
> >
> > I am curious which ones you all feel is the best route?
> > For example Backup/Restore VS Attach/Dettach or any other ways you are aware
> > of.
> >
> > Thank You in advance for your assistance!
> >
>

Relevant Pages

  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • Re: Copying WSS to another Server
    ... the data in sync I back the SQL databases up and restore them to the replica ... It already has WSS installed. ... > on one server and copy it to another for dev/test purposes, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Two Disaster Recovery Questions
    ... I support the Professional Association for SQL Server ... > recovery site ... > second restore at the recovery site. ...
    (microsoft.public.sqlserver.server)
  • Re: Exchange DR, what to do
    ... setup blank databases on theDRexchangeserver, ... data out of the RSG, it tries to restore it to the original server, ... the cluster exchange virtual server name was, ...
    (microsoft.public.exchange.admin)
  • Re: Off-Site Duplicate Server Setup
    ... the normal process for databases is backing up the ... backup the backup files to tape/disk/offline/whatever. ... Which is good until restoration when you need to restore the original, ... likely have a live replicated server available. ...
    (microsoft.public.windows.server.general)