dbTalk Databases Forums  

Database snapshot

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clients Database snapshot

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Database snapshot in the microsoft.public.sqlserver.clients forum.



Reply
Page 1 of 2 1 2 >
 
Thread Tools Display Modes
  #1  
Old   
Smith
 
Posts: n/a

Default Database snapshot - 02-07-2008 , 12:07 PM





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


Reply With Quote
  #2  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Database snapshot - 02-07-2008 , 01:34 PM





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

Quote:
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


Reply With Quote
  #3  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Database snapshot - 02-07-2008 , 01:34 PM


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

Quote:
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


Reply With Quote
  #4  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Database snapshot - 02-07-2008 , 01:34 PM


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

Quote:
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


Reply With Quote
  #5  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Database snapshot - 02-07-2008 , 01:34 PM


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

Quote:
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


Reply With Quote
  #6  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Database snapshot - 02-07-2008 , 01:34 PM


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

Quote:
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


Reply With Quote
  #7  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Database snapshot - 02-07-2008 , 01:34 PM


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

Quote:
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


Reply With Quote
  #8  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Database snapshot - 02-07-2008 , 01:34 PM


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

Quote:
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


Reply With Quote
  #9  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Database snapshot - 02-07-2008 , 01:34 PM


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

Quote:
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


Reply With Quote
  #10  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: Database snapshot - 02-07-2008 , 01:34 PM


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

Quote:
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


Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top