restoring sql to another server

What are the step to restore sql database to another server
FYI: I have sql2000 server
I want to restore the database from sql-server to old-server
thanksAssuming you have a full backup of database on sql-server machine:
1) copy the backup file to old-server
2) run the restore database from EM or QA and change the location of files
accordingly
3) run sp_changedbowner if required
OR
if u just want to move copy of database to another machine:
1) detach the database on sql-server
2) copy the data and log files to old-server
3) attach the files to both sql-server and old-server
"frank" wrote:
> What are the step to restore sql database to another server
> FYI: I have sql2000 server
> I want to restore the database from sql-server to old-server
> thanks
>|||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/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"frank" <frank@.discussions.microsoft.com> wrote in message
news:8623F485-A988-48D6-86AD-056E41CC132D@.microsoft.com...
> What are the step to restore sql database to another server
> FYI: I have sql2000 server
> I want to restore the database from sql-server to old-server
> thanks
>