we are planning a reporting enviornment , here is the scenario
We have a database pn primary site that sends logshipping updates to secondary (DR site) . (MS SQL 2005)
The instance on DR site should be cloned (on the same sql server installation) . for example
If database name is "production database" , ideally we need a clone it everynight on the same machine
but with a different name (e.g. ReportingDB).