June 8, 2011 at 2:51 am
Can we access Secondary Server in Logshiiping or Can we mirror server in mirroring .?
if yes explain
June 8, 2011 at 2:58 am
Change is Required (6/8/2011)
Can we access Secondary Server in Logshiipingif yes explain
Yes, in Standby mode
... Can we mirror server in mirroring .?
Mirroring works in database level. Not in server level.
Did not understand your question. Please refrase it.
June 8, 2011 at 3:37 pm
Change is Required (6/8/2011)
Can we access Secondary Server in Logshiiping?
To expound on what Suresh said, yes, you can, however when logs are applied no users can be connected to the database. You can configure SQL Server to automatically disconnect all users when logs are applied by the restore job, or you can configure SQL Server to defer any restores until all users disconnect naturally.
Here is a good article on the topic:
http://msdn.microsoft.com/en-us/library/ms189572(v=SQL.90).aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 8, 2011 at 10:17 pm
Change is Required (6/8/2011)
Can we access Secondary Server in Logshiiping or Can we mirror server in mirroring .?if yes explain
As has been mentione the answer to the first question is yes, but most of them are incomplete.
Log shipping is also done on a database level, so it is technically possible to be log shipping in both directions (to and from) a single server to other servers, for different databases. Any log shipping source is obviously available, and any log shipping destination is available as long as its in STANDBY mode.
If you use the STANDBY option you can only apply the logs when all users are disconnectted, either forcably or naturally. Relying on the users is a bad idea as users tend to leave connections open, putting your DR process at risk. If you force the users off every 15 minutes so you can restore the logs they tend to get a bit upset. It's also not a good option to use your DR server like this.
Note that as long as you are only using your DR server as a log shipping server, or for DR failover testing or for a real disaster you don't need to pay for the SQL Licence 🙂 If you use it for reporting (in STANDBY) on a regular bases, or for DR for more than 90 days, you need to buy a licence.
Given the above you may as well spend a little money standing up another server, get the SQL licence and create a propper reporting environment using something like replication.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
June 9, 2011 at 7:25 am
Leo.Miller (6/8/2011)
Change is Required (6/8/2011)
Can we access Secondary Server in Logshiiping or Can we mirror server in mirroring .?if yes explain
As has been mentione the answer to the first question is yes, but most of them are incomplete.
Log shipping is also done on a database level, so it is technically possible to be log shipping in both directions (to and from) a single server to other servers, for different databases. Any log shipping source is obviously available, and any log shipping destination is available as long as its in STANDBY mode.
If you use the STANDBY option you can only apply the logs when all users are disconnectted, either forcably or naturally. Relying on the users is a bad idea as users tend to leave connections open, putting your DR process at risk. If you force the users off every 15 minutes so you can restore the logs they tend to get a bit upset. It's also not a good option to use your DR server like this.
Note that as long as you are only using your DR server as a log shipping server, or for DR failover testing or for a real disaster you don't need to pay for the SQL Licence 🙂 If you use it for reporting (in STANDBY) on a regular bases, or for DR for more than 90 days, you need to buy a licence.
Given the above you may as well spend a little money standing up another server, get the SQL licence and create a propper reporting environment using something like replication.
Cheers
Leo
Gee Leo, except for me leaving out some of my own opinions I don't see how your post was any more complete than any of the others.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply