Moving ALL DBs to new server

I am building a new SQL server and would like to copy ALL DBs (user and
system) to it. The server will eventually have the same name, but the
DB files will be in different locations (paths). Are there any links I
should check out or MSFT KB articles? I tried searching but wasn't
able to get anything for my specific issues. (Also, upgrading Windows
2000 to Windows 2003, but still on SQL Server 2000 SP3.)I found this one.
http://support.microsoft.com/default.aspx/kb/224071
"tommydogs@.sickoflosers.com" wrote:
> I am building a new SQL server and would like to copy ALL DBs (user and
> system) to it. The server will eventually have the same name, but the
> DB files will be in different locations (paths). Are there any links I
> should check out or MSFT KB articles? I tried searching but wasn't
> able to get anything for my specific issues. (Also, upgrading Windows
> 2000 to Windows 2003, but still on SQL Server 2000 SP3.)
>|||In addition to the link posted by Jen, here are some more articles that you
may find helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
<tommydogs@.sickoflosers.com> wrote in message
news:1107283271.072157.290890@.c13g2000cwb.googlegroups.com...
> I am building a new SQL server and would like to copy ALL DBs (user and
> system) to it. The server will eventually have the same name, but the
> DB files will be in different locations (paths). Are there any links I
> should check out or MSFT KB articles? I tried searching but wasn't
> able to get anything for my specific issues. (Also, upgrading Windows
> 2000 to Windows 2003, but still on SQL Server 2000 SP3.)
>|||Thanks for the help! One of the questions I have that doesn't seem to
be answered is this: I detach all user DBs from my current SQL server,
then copy over the master, model, msdb, & tempdb system DBs to the new
server. Can I then copy and reattach user DB files?
Keith Kratochvil wrote:
> In addition to the link posted by Jen, here are some more articles
that you
> may find helpful:
>
>
> INF: Disaster Recovery Articles for Microsoft SQL Server
> http://www.support.microsoft.com/?id=307775
> INF: Moving SQL Server databases to a new location with Detach/Attach
> http://www.support.microsoft.com/?id=224071
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://www.support.microsoft.com/?id=314546
> INF: Using the WITH MOVE Option with the RESTORE Statement
> http://support.microsoft.com/?id=221465
> PRB: User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
> http://www.support.microsoft.com/?id=246133
> PRB: "Troubleshooting Orphaned Users" Topic in Books Online is
Incomplete
> http://www.support.microsoft.com/?id=274188
> How to Resolve Permission Issues When a Database Is Moved Between SQL
> Servers
> http://www.support.microsoft.com/?id=240872
> SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases
When
> Database Is Moved
> http://www.support.microsoft.com/?id=298897
>
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
>
> --
> Keith
>
> <tommydogs@.sickoflosers.com> wrote in message
> news:1107283271.072157.290890@.c13g2000cwb.googlegroups.com...
> > I am building a new SQL server and would like to copy ALL DBs (user
and
> > system) to it. The server will eventually have the same name, but
the
> > DB files will be in different locations (paths). Are there any
links I
> > should check out or MSFT KB articles? I tried searching but wasn't
> > able to get anything for my specific issues. (Also, upgrading
Windows
> > 2000 to Windows 2003, but still on SQL Server 2000 SP3.)
> >|||I've just recently had to move my database to other server. A mirror in fact.
The faster way to move and get them running was stopping sql services copy
the .ldf and .mdf files to the other server. Copy the folder \mssql\data to
the other server and start the services.
It worked.
But i think it wont work for you since you're gonna place db on different
paths.
Hope you dont have a bad time doing that :)
"tommydogs@.sickoflosers.com" wrote:
> Thanks for the help! One of the questions I have that doesn't seem to
> be answered is this: I detach all user DBs from my current SQL server,
> then copy over the master, model, msdb, & tempdb system DBs to the new
> server. Can I then copy and reattach user DB files?
>
> Keith Kratochvil wrote:
> > In addition to the link posted by Jen, here are some more articles
> that you
> > may find helpful:
> >
> >
> >
> >
> > INF: Disaster Recovery Articles for Microsoft SQL Server
> > http://www.support.microsoft.com/?id=307775
> >
> > INF: Moving SQL Server databases to a new location with Detach/Attach
> > http://www.support.microsoft.com/?id=224071
> >
> > HOW TO: Move Databases Between Computers That Are Running SQL Server
> > http://www.support.microsoft.com/?id=314546
> >
> > INF: Using the WITH MOVE Option with the RESTORE Statement
> > http://support.microsoft.com/?id=221465
> >
> > PRB: User Logon and/or Permission Errors After Restoring Dump
> > http://www.support.microsoft.com/?id=168001
> >
> > HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
> > http://www.support.microsoft.com/?id=246133
> >
> > PRB: "Troubleshooting Orphaned Users" Topic in Books Online is
> Incomplete
> > http://www.support.microsoft.com/?id=274188
> >
> > How to Resolve Permission Issues When a Database Is Moved Between SQL
> > Servers
> > http://www.support.microsoft.com/?id=240872
> >
> > SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases
> When
> > Database Is Moved
> > http://www.support.microsoft.com/?id=298897
> >
> >
> >
> > Utility to map users to the correct login
> > http://www.dbmaint.com/SyncSqlLogins.asp
> >
> >
> > --
> > Keith
> >
> >
> > <tommydogs@.sickoflosers.com> wrote in message
> > news:1107283271.072157.290890@.c13g2000cwb.googlegroups.com...
> > > I am building a new SQL server and would like to copy ALL DBs (user
> and
> > > system) to it. The server will eventually have the same name, but
> the
> > > DB files will be in different locations (paths). Are there any
> links I
> > > should check out or MSFT KB articles? I tried searching but wasn't
> > > able to get anything for my specific issues. (Also, upgrading
> Windows
> > > 2000 to Windows 2003, but still on SQL Server 2000 SP3.)
> > >
>