database snapshot off of a restoring db

Say I establish log shipping between source A and dest B.
and Dest B is continuously restoring logs, can i perform a snapshot on Dest
B
I know if i do mirroring between the 2 servers than i can snapshot off of
the mirror but wanted to know how it works with log shipping destination
ThanksI have not tested myself but saw this on BOL
Limitations on Database Snapshots
"The source database must be online, unless the database is a mirror
database within a database mirroring session"
Ben Nevarez, MCDBA, OCP
Database Administrator
"Hassan" wrote:

> Say I establish log shipping between source A and dest B.
> and Dest B is continuously restoring logs, can i perform a snapshot on Des
t
> B
> I know if i do mirroring between the 2 servers than i can snapshot off of
> the mirror but wanted to know how it works with log shipping destination
> Thanks
>
>|||No. This is not allowed
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:eBwaNwiPGHA.2628@.TK2MSFTNGP15.phx.gbl...
> Say I establish log shipping between source A and dest B.
> and Dest B is continuously restoring logs, can i perform a snapshot on
> Dest B
> I know if i do mirroring between the 2 servers than i can snapshot off of
> the mirror but wanted to know how it works with log shipping destination
> Thanks
>

database snapshot off of a restoring db

Say I establish log shipping between source A and dest B.
and Dest B is continuously restoring logs, can i perform a snapshot on Dest
B
I know if i do mirroring between the 2 servers than i can snapshot off of
the mirror but wanted to know how it works with log shipping destination
Thanks
I have not tested myself but saw this on BOL
Limitations on Database Snapshots
"The source database must be online, unless the database is a mirror
database within a database mirroring session"
Ben Nevarez, MCDBA, OCP
Database Administrator
"Hassan" wrote:

> Say I establish log shipping between source A and dest B.
> and Dest B is continuously restoring logs, can i perform a snapshot on Dest
> B
> I know if i do mirroring between the 2 servers than i can snapshot off of
> the mirror but wanted to know how it works with log shipping destination
> Thanks
>
>
|||No. This is not allowed
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:eBwaNwiPGHA.2628@.TK2MSFTNGP15.phx.gbl...
> Say I establish log shipping between source A and dest B.
> and Dest B is continuously restoring logs, can i perform a snapshot on
> Dest B
> I know if i do mirroring between the 2 servers than i can snapshot off of
> the mirror but wanted to know how it works with log shipping destination
> Thanks
>

database snapshot off of a restoring db

Say I establish log shipping between source A and dest B.
and Dest B is continuously restoring logs, can i perform a snapshot on Dest
B
I know if i do mirroring between the 2 servers than i can snapshot off of
the mirror but wanted to know how it works with log shipping destination
ThanksI have not tested myself but saw this on BOL
Limitations on Database Snapshots
"The source database must be online, unless the database is a mirror
database within a database mirroring session"
Ben Nevarez, MCDBA, OCP
Database Administrator
"Hassan" wrote:
> Say I establish log shipping between source A and dest B.
> and Dest B is continuously restoring logs, can i perform a snapshot on Dest
> B
> I know if i do mirroring between the 2 servers than i can snapshot off of
> the mirror but wanted to know how it works with log shipping destination
> Thanks
>
>|||No. This is not allowed
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:eBwaNwiPGHA.2628@.TK2MSFTNGP15.phx.gbl...
> Say I establish log shipping between source A and dest B.
> and Dest B is continuously restoring logs, can i perform a snapshot on
> Dest B
> I know if i do mirroring between the 2 servers than i can snapshot off of
> the mirror but wanted to know how it works with log shipping destination
> Thanks
>sql

Database server connection

I am trying to using sqlserver as back-end for an application(web) running
on the window 2X, one thing I am not sure is that once I establish the
connection between database server and application, should I keep this
connection open while application is running, or only open it when
there is a requet to qury records from database?

Thanks for your help."Leon" <penghao98@.hotmail.com> wrote in message
news:89a0a7de.0409221926.6c394129@.posting.google.c om...
>I am trying to using sqlserver as back-end for an application(web) running
> on the window 2X, one thing I am not sure is that once I establish the
> connection between database server and application, should I keep this
> connection open while application is running, or only open it when
> there is a requet to qury records from database?
> Thanks for your help.

I believe the usual approach is to leave the connection open, to avoid the
overhead associated with opening and closing the connection again and again.
This is one reason for using connection pooling, for example.

You might want to post in a forum for your client library (eg ADO, JDBC) or
development environment (eg ASP, PHP) to see if there are any specific
considerations for your application.

Simon|||penghao98@.hotmail.com (Leon) wrote in message news:<89a0a7de.0409221926.6c394129@.posting.google.com>...
> I am trying to using sqlserver as back-end for an application(web) running
> on the window 2X, one thing I am not sure is that once I establish the
> connection between database server and application, should I keep this
> connection open while application is running, or only open it when
> there is a requet to qury records from database?
> Thanks for your help.

Hi,
This is question basically regarding connection pooling.
Which technology you are using for database acess? like ADO,JDO, JDBc
etc..?
In all these you can create a pool of connections and maintain it. So
the best thing which I feel is ,during boot up of your application
create a pool of connections, store it and use the connection when
needed.
This is purely dependent on your application also.

Some technologies like ADO and JDBC now support disconnected rowsets
also like CachedRowset in Java where internally it will(means
driver/proider) handle reconnecting to the server when a request
comes.

But from performance point of view, better to create connections
during start up.

How many connections? etc depending on the usage of your application
Regards
Zunil
Cordys