please suggest me which provider i should take.

please guide me...

is it good to move in BI tool area.

Hi,

Can u explain this one also :-

When a data page changes in the source database, SQL Server writes the original image of the page into the database snapshot, which...

expect answer from someone.

:crying:

thanks a lot...:-)

ohhh..... that's great example.....Now i can't forget this example in my life. This is very clear.

Thanks a lot...:-)

Expect reply with someone. This is important for my future...

Actually i have one server with three instances....can possible to implement all the thing with my given scenarios (primary database, mirror database, witness).

Thanks for your advise.........now it's working.:-)

expect solution with someone...

Hi,

Can also possible to set up the mirroring with single instance in a same server.

Regards,

Sachin.

thanks to all for more clarification.

Jack Corbett (2/21/2012)

---

Sure you can setup log-shipping between databases on the same SQL Server instance, but as has been mentioned, the secondary database needs a different name. ...

Here still not clear.....

As per your views ... i can use secondary database with different name...