Do you mean the "database Snapshot" functionality introduced in 2005:

CREATE DATABASE x
(...)
AS SNAPSHOT OF y

If so, no. The snapshot has to exist on the same instance as the course database. Unless the source
database is mirrored, where you can create a snapshot of the mirror database.

You can of course backup the course database and restore it to another instance, which can be more
or less practical depending on the size of the database.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Smith" <naissani (AT) hotmail (DOT) co> wrote