Moving SQL Databases.

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!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/defaul...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
bcba5592c" target="_blank">http://groups-beta.google.com/group...r />
bcba5592c
502b09
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 database
s
> 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 awa
re
> of.
> Thank You in advance for your assistance!
>|||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/scr...sp?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/defaul...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...rch&&d#6bcba559
2c502b09
> 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:
>