Migrate Data Bases Different Server

Hi!!!
I have 2 servers running sql server enterprise 2000, however I will
shutdown one of them and will use only the newest.
I have to migrate 2 databases.. I was wondering which is the best way to do
so..
I thought that I can make a full backup and then restore the backup on the
new server but I dont know if this is possible...
or is there another way to do so? is it dangerous? easy?
Thanxs and
Greetings =)
http://support.microsoft.com/?kbid=224071
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"Jess Gutirrez" <ardillapaw@.msn.com> wrote in message
news:%23$3Ar7coFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Hi!!!
> I have 2 servers running sql server enterprise 2000, however I will
> shutdown one of them and will use only the newest.
> I have to migrate 2 databases.. I was wondering which is the best way to
do
> so..
> I thought that I can make a full backup and then restore the backup on the
> new server but I dont know if this is possible...
> or is there another way to do so? is it dangerous? easy?
> Thanxs and
> Greetings =)
>
>
|||Backup & Restore or attach & detach are usually the easiest but you might
want to have a look at these:
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://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/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Jess Gutirrez" <ardillapaw@.msn.com> wrote in message
news:%23$3Ar7coFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Hi!!!
> I have 2 servers running sql server enterprise 2000, however I will
> shutdown one of them and will use only the newest.
> I have to migrate 2 databases.. I was wondering which is the best way to
> do so..
> I thought that I can make a full backup and then restore the backup on the
> new server but I dont know if this is possible...
> or is there another way to do so? is it dangerous? easy?
> Thanxs and
> Greetings =)
>
>
|||HI!!!
Thanxs a lot that really really helped =)
"Jess Gutirrez" <ardillapaw@.msn.com> wrote in message
news:%23$3Ar7coFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Hi!!!
> I have 2 servers running sql server enterprise 2000, however I will
> shutdown one of them and will use only the newest.
> I have to migrate 2 databases.. I was wondering which is the best way to
> do so..
> I thought that I can make a full backup and then restore the backup on the
> new server but I dont know if this is possible...
> or is there another way to do so? is it dangerous? easy?
> Thanxs and
> Greetings =)
>
>
|||Or use DTS
Or use DataStudio from our company, check our website right here.
http://www.agileinfollc.com
"Jess Gutirrez" <ardillapaw@.msn.com> wrote in message
news:OO8Rj1zoFHA.576@.TK2MSFTNGP15.phx.gbl...
> HI!!!
> Thanxs a lot that really really helped =)
>
> "Jess Gutirrez" <ardillapaw@.msn.com> wrote in message
> news:%23$3Ar7coFHA.3936@.TK2MSFTNGP10.phx.gbl...
>