SQL Server Performance

Backup/Restore vs Attach/Detach

Discussion in 'SQL Server 2005 General DBA Questions' started by pcsql, Jul 14, 2006.

  1. pcsql New Member

    I'm trying to see the differences between Backup/Restore and Attach/Detach. I backup and detach a database from SQL Server 2000 SP3 and then attach and restore it to SQL Server 2005 SP1.

    The differences I noticed are:

    1. The restored database has a much larger initial size (database size is same) for data and log.
    2. The attached database has a last backup date
    3. If the backup is restored over a database, the restored database is showing owned by the database owner of the database restored over but syslogins and sysusers do not match.

    I don't understand why #1 happens.

    Are there any other differences between Backup/Restore and Attach/Detach?


  2. dineshasanka Moderator

    Backup /resore is much safer than attach/detach
    There are some instances attach/detch does not work. if there are more than one log files it will not work


Share This Page