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
I guess I don't understand what your #1 means. You seem to be saying that (1) the database is much larger if you restore it vs. an attach but (2) that the database size is the same for both. That seems contradictory...
As for other differences, the primary differences for most people relate to speed. If I'm just moving the log file from the F:\ drive to the E:\ drive, a backup/restore operation for a large database would take much, much longer than an detach/attach. I don't mean to be too simplistic as it sounds, from your testing, that you're very comfortable with SQL Server. Outside of that, there's not going to be a difference between RECOVERY, the orphaned users (#3 above), or anything else that I'm aware of. There's probably some niggling things here and there that are minor differences but nothing major that I know of.
/****************************************************
Check out our Sql Server 2005 and 2000 tutorials
****************************************************/
No comments:
Post a Comment