Hi All,

I am using SQL Server 7 with SP4. I have a requirement where I need to copy
production database into another server (backup server) and run some
Decision Support processes on the backup server. I was thinking if I can
create snapshots, in the backup server database, that can be refreshed
periodically. Oracle provides Snapshots. Do we have it in SQL Server also??

An early response will be highly appreciated

Thanks and Regards,
Pranav
MS Sql Server LazyDBA home page