Database snapshot

External Since: Jan 22, 2008 Posts: 16

I have one production server which is very critical and one of our client is
having problem in one of the module, is there any way I can use the snapshot
of the same database but point to different server not the same server just
to save our performance.

Thanks

External Since: Jan 29, 2004 Posts: 1471

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.RemoveThis@hotmail.co> wrote in message
news:84902761-0219-4001-B2D8-B16387A3C20C@microsoft.com...
>I have one production server which is very critical and one of our client is having problem in one
>of the module, is there any way I can use the snapshot of the same database but point to different
>server not the same server just to save our performance.
>
> Thanks