January 18, 2011 at 5:17 am
can w e setup LS more than 1 db at a time .
January 18, 2011 at 6:13 am
ramyours2003 (1/18/2011)
can we setup LS more than 1 db at a time.
Yes you can.
You'll have to implement it for each database.
http://msdn.microsoft.com/en-us/library/ms190640.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 18, 2011 at 6:35 am
Appreciated for ur responses .
January 18, 2011 at 6:50 am
ramyours2003 (1/18/2011)
Appreciated for ur responses .
No problem, I'm glad to help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 18, 2011 at 7:06 am
They can be done simultanouesly one after another but not all at a single time.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
January 18, 2011 at 7:17 am
SKYBVI (1/18/2011)
They can be done simultanouesly one after another but not all at a single time.
Do you have any evidence that supports this statement?
Log shipping is basically taking a transaction log on the primary database, sending it to another server and finally restoring the log on that server. This process can run for each database independently from the other. Or am I overlooking something?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 18, 2011 at 7:34 am
I know what you are saying but for example I have 8 databases and I want to LS all at a time
is it possible?
I think we have to configure 1 after another...
I know that all 8 databases can be log shipped at a time but I am talking about configuring part..
The configuring part has to be simultanoeus...Once they are configured, Yes, they will be running at a time.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
January 18, 2011 at 7:53 am
SKYBVI (1/18/2011)
I know what you are saying but for example I have 8 databases and I want to LS all at a timeis it possible?
I think we have to configure 1 after another...
I know that all 8 databases can be log shipped at a time but I am talking about configuring part..
The configuring part has to be simultanoeus...Once they are configured, Yes, they will be running at a time.
Allright, I guess I misunderstood you.
I also think you'd have to configure each database seperately.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 18, 2011 at 8:06 am
Ya..there was a misunderstanding because:_
The original poster wrote "can we setup LS more than 1 db at a time"
setup is the configuring part, whcih we cant do more than 1 db at a time.
But offcourse, after setting up, we surely run all databases in LS at a time .
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply