Posted by MPD on 04/18/07 17:19

Hi

How can I create a job in sql agent to create a new snapshot every hour?

I have, for eg a T-SQL that does it manually.

create database Snapshotter_snap_20070418_1821 on
( name = Snapshotter, filename =
'c:\temp\Snapshotter_snap_20070418_1821.ss')
as snapshot of Snapshotter

Now, what I do NOT want, is to only have one copy, but rather to do this
every hour or two through out the day - and keep the old copies for some
time. (In that case, a DROP database, and a CREATE database <generic name>
is easy).

Any help appreciated,
M

• Next in forum: Re: Tranaction log error- can someone tell me if this error was my fault
• Prev in forum: Re: DB Replication or Table Replication via triggers?
• Thread view: Snapshot of databases = Hourly job

[Reply to this message]