Taking the snapshots of a database
Posted on 2006-11-15
I have a database called 'projectserver'
I took the backup of this database and restored to a new database 'projectsnap' on the same server.
Now i want to use this 'projectsnap' database as a reporting database for the actual database
To accomplish this i want to take snapshots of the 'projectserver' and load the data at that particular instance into 'projectsnap'
The main objective of this operation is that i can go back to any particular time and see how the data looked like at that instance of time in 'projectsnap'
I searched the net but didnt find proper information as how to do this...please help