Best way to recreate snapshots in sql server 2008 -


i want update database snapshot every hour, keeping name unchanged. way found how - drop/create pattern. there 3 minutes downtime between drop , create events. there way update snapshot faster?

my previous answer turned out junk because can't re-name database snapshots. can do, however, create shell database job contain synonyms objects in database snapshot. it'd work this:

  1. create new database snapshot
  2. create synonyms objects in new snapshot, dropping old synonyms necessary
  3. once synonyms have been repointed, drop old snapshot.

Comments