It is perhaps a bit stupid question, but I must admit I have very limited experience with MSSQL and yet has to accomplish this:
- Take a snapshot of the database and create and exact duplicate on another server?
- Take a snapshot of(the same) database and create a duplicate on the same server under a different DB name...
Origin DB server: SQL Server 2000
DB server on another machine: SQL Server 2005