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 |
|
mgole
Starting Member
9 Posts |
 Posted - 2005-03-12 : 09:54:59
|
| HiThe copy and restore jobs are successful when i run a burst of about 6000 transactions every 5 min.But when i run the reports simultaneously in the query analyser along with these transactions,then the restore job fails.I have chosen the standby mode and terminate users option while configuring log shipping.Does the terminate users option mean that i cannot open query analyser to run reports.If so, then how do i run my reports?Do i need to change something?ThanksMadhukar |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-12 : 11:14:28
|
| Yes. A database is not available while it or its log is being restored, and it cannot be restored while it's in use by someone. Sorta like holding your breath and taking a drink, you can't do both at the same time.Log shipping is not entirely ideal for a live reporting server, especially one that requires high availability. You need to trade off this availability against the frequency that the data needs to be refreshed. Replication may be more suitable, but that has its own considerations and problems too. |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-12 : 13:18:17
|
| Can ventriloquists restore databases while other people are using it?Be One with the OptimizerTG |
|
|
|
|
|
|
log shipping restore problems