Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ay2k_99
Starting Member
22 Posts |
 Posted - 2009-03-06 : 07:00:03
|
| Hello All,I am having the following senario with log shipping :1. We have 2 server like Srv-A and Srv-B.2. Backup jobs take every 30 min and restore job doing every 35min.3. I want to make the Srv-B for Permanent reporting perpose.4. how can i implement those steps.5. i can do it for 25 min for reporting perpose but how to make it Permanent reporting purpose.Thx, |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-03-06 : 07:03:29
|
| you should consider replication for this purpose... log shipping provides only high availability w/o scalability...For instance transaction log replication would suit you.Thanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
|
|
|
LOG SHIPPING . . . . . . .