I don't always do restores in Enterprise Manager, but I think what you need to do is check "Force restore over existing database" on the Options tab. 

So I'm clear...

David,

I believe the RESTORE option you need to use is WITH REPLACE.  This will delete the existing database and restore the backup with the same name as the existing database. ...

There's a nice table showing the differences in recovery models in BooksOnLine under "Selecting a Recovery Model". 

Greg

Do you mean you want someone to be able to open a package but not save or execute it?  If so, grant EXEC permission on sp_get_dtspackage, but deny permission on...

What works for me is to click the 'Populate from Source' button, then the 'Execute' button.

Greg

sp_reassign_dtspackageowner must have all three parameters.  you can find the ID by running sp_enum_dtspackages in msdb.

Greg

The wizard will transfer objects if you check the "Run Immediately" option.

Greg

Susan,

See Mohammed's post above.  If you don't need point-in-time recovery ability and you don't want to do log backups, change the database recovery model to "Simple" and forget about truncating...

you're right about the Bulk Insert task but I don't think he's using one since he has a SELECT query in it.  It appears that he's importing from a table.

Greg

Jason,

I don't have any experience with Veritas, so I don't feel qualified to recommend whether you should use it or not.  As I said in my previous post, keeping backups...

You could create views with the names you want to use that select from the tables.  Then, you could use the views in your queries.

Greg 

I assume you're talking about copying using DTS or truncate/insert, so tables aren't dropped and recreated.  If that's the case, the only way I know of finding when data was replaced...

Designate an exception file for the Transform Data task on the 'options' tab of the task properties.  Uncheck '7.0 format' and check 'Error text', 'Source error rows', and 'Dest error...

Jason,

Since your database is using Full recovery model and the tlog is 36GB, I'd say you either need to start doing log backups as well as full backups or you...

At first glance, I'd say that replication would be a good option.  You can replicate to multiple subscribers and if you use transactional replication, the databases would be more syncronized...