Difference between Attach / Detach and Backup / Restore

I am new to SQL Server and we are using SQL Server 2005.
We recently upgrade a finance system by consultant. He detaches the
database from the old server (Running SQL Server 2000), copy the mdf file
across and attached in the new SQL Server 2005.
I would like to know is there any benefit for detaching / attaching than
make a backup and restore on the SQL Server 2005 ?
Someone has mentioned that we have to recreate SQL Server Login though the
Database Login exists on the database copied across. Is there any tools /
reference that makes it easy ?
ThanksPeter
It is just faster.
Search on interenet for 'sp_help_revlogin' for SQL Server 2005
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:OZmOrl6wHHA.600@.TK2MSFTNGP05.phx.gbl...
>I am new to SQL Server and we are using SQL Server 2005.
> We recently upgrade a finance system by consultant. He detaches the
> database from the old server (Running SQL Server 2000), copy the mdf file
> across and attached in the new SQL Server 2005.
> I would like to know is there any benefit for detaching / attaching than
> make a backup and restore on the SQL Server 2005 ?
> Someone has mentioned that we have to recreate SQL Server Login though the
> Database Login exists on the database copied across. Is there any tools /
> reference that makes it easy ?
> Thanks
>|||I have explained the step to move the logins as well here:
http://sqlguy.it-craft.dk
As well as links to the stored procedures for both 2000 and 2005
Regards
Rasmus Glibstrup
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:OZmOrl6wHHA.600@.TK2MSFTNGP05.phx.gbl...
>I am new to SQL Server and we are using SQL Server 2005.
> We recently upgrade a finance system by consultant. He detaches the
> database from the old server (Running SQL Server 2000), copy the mdf file
> across and attached in the new SQL Server 2005.
> I would like to know is there any benefit for detaching / attaching than
> make a backup and restore on the SQL Server 2005 ?
> Someone has mentioned that we have to recreate SQL Server Login though the
> Database Login exists on the database copied across. Is there any tools /
> reference that makes it easy ?
> Thanks
>