Playground copy of database

I am quite new to sql server...
I have a live database that I would like to keep a 'playground' copy of
(perhaps one day behind). This would allow testing to be done in the
playground before moving to the live data. I would like each day to have the
live data 'replicated' to another database on the same server. It seems that
I can not use replicate, any other ideas/suggestions would be appreciated.
M| I am quite new to sql server...
|
| I have a live database that I would like to keep a 'playground' copy of
| (perhaps one day behind). This would allow testing to be done in the
| playground before moving to the live data. I would like each day to have
the
| live data 'replicated' to another database on the same server. It seems
that
| I can not use replicate, any other ideas/suggestions would be appreciated.
|
| M
--
Hi Maureen,
One approach is to create a job which backups your live database daily and
then restores and overwrites your "playground" copy. You can disable the
job if you don't want your "playground" database not to be overwritten for
that day. You can also force the job to run on demand when you wish to
restore a new copy of the database even before the job is scheduled to run.
Hope this helps,
--
Eric Cárdenas
SQL Server supportsql