SQL Server Performance Forum – Threads Archive
Backup/Restore vs Attach/DetachI’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? Thanks, Peter
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 —————————————-