Larry:

I always use the backup to file option as part of my maintenance plan. In the morning, they move the entire server to tape.

When it comes time to restore, will it recreate all the database objects and move the data back too? Or do I need to script all the database objects first, then restore?

Thanx,
Charlie