Copy DB,Packages etc to another computer ..

If I need to move my SQL server to another bigger
computer.
How can I copy the all the databases and all my
Transformation packages over properly ? I don't want to
recreate everything again.
Can I use the detach and copy the database command and
recopy to the new server ?
How about the Transformation packages ?
What else do I need to copy over ?
Any advice is greatly welcomeHi,
I will suggest you to do these steps;
1. Install SQL server in the new server with same folder structure as old
server
2. Apply the Service packs identical to old server
3. Stop SQL server and SQL Agent in old server and new server
4. Copy ALL MDF and LDF files from old server to new server ( In the same
folder) - Include system databases as well
5. Start the SQLserver in New server
6. If you need to change the SQl server name in new server then
sp_dropserver <oldservername>
go
sp_addserver <newserver>,local
7. Restart SQL server and SQl agent services
This will ensure that all the database in old system is up in new server,
DTS Packages, Jobs, Alerts , Logins, Users into the new server, etc...
(Same as old server).
Note:
But few of DBAs wont agree the above concept, Microsoft has got a good
article on moving the database, Have a look into that.
http://support.microsoft.com/defaul...kb;en-us;314546
Thanks
Hari
MCDBA
"jen" <anonymous@.discussions.microsoft.com> wrote in message
news:11b7801c410b4$64819c70$a301280a@.phx
.gbl...
> If I need to move my SQL server to another bigger
> computer.
> How can I copy the all the databases and all my
> Transformation packages over properly ? I don't want to
> recreate everything again.
>
> Can I use the detach and copy the database command and
> recopy to the new server ?
> How about the Transformation packages ?
> What else do I need to copy over ?
> Any advice is greatly welcome|||Hi Jen
Check out http://support.microsoft.com/defaul...en-us;Q314546#2
regarding different ways to move databases. The easiest methods (IMO) are
using sp_detach_db/sp_attach_db or backup/restore.
John

Copy database

What is the best way to copy an entire SQL Server 2K DB? I want to take an
existing DB on one computer, and move its entirety to another. It seems
that DTS will only import/export tables... I'd like to be able to get the
whole enchilata, schema, tables, etc.
Best way is either do backup and restore or attach it.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/colu...rdatabases.asp
Moving Users
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/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scri...tions/1598.asp Script
Roles and Permissions
Andrew J. Kelly SQL MVP
"William F. O'Neill" <wfoneill001@.bellsouth.net> wrote in message
news:enSR%23%236FGHA.1088@.tk2msftngp13.phx.gbl...
> What is the best way to copy an entire SQL Server 2K DB? I want to take
> an existing DB on one computer, and move its entirety to another. It
> seems that DTS will only import/export tables... I'd like to be able to
> get the whole enchilata, schema, tables, etc.
>