We're running SQL 2005 Enterprise Edition. We restore a backup of a 100gb db every day in the early morning hours.

The scheduled job starts at 3:45am each day; the value I see in RESTORE_DATE is 3:45:04am (+-3 seconds).

This db does NOT get restored in 4 seconds; it takes about an hour.