|
Home > Archive > MS SQL Server > October 2006 > Running Reports During TLog Restoration
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Running Reports During TLog Restoration
|
|
| LaEsmeralda 2006-10-31, 12:15 am |
| We have a standby system where Crystal Reports are running against. Every
time it restores TLog we have to put the database into single user mode or
the running reports will block it from restoring Tlogs. And because of that
those reports fail.
Is there anyway to make both of them run successfully at the same time?
Gracias.
LaEsmeralda
| |
| Tom Moreau 2006-10-31, 12:15 am |
| In SQL Server 2005, you could use DB mirroring. Create a snapshot on the
mirror and run your reports off of it.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"LaEsmeralda" < LaEsmeralda@discussi
ons.microsoft.com> wrote in message
news:F3F472CD-3057-4787-A7A1- 54AB47F69289@microso
ft.com...
We have a standby system where Crystal Reports are running against. Every
time it restores TLog we have to put the database into single user mode or
the running reports will block it from restoring Tlogs. And because of that
those reports fail.
Is there anyway to make both of them run successfully at the same time?
Gracias.
LaEsmeralda
| |
| Hilary Cotter 2006-10-31, 12:15 am |
| You could also use replication for this.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LaEsmeralda" < LaEsmeralda@discussi
ons.microsoft.com> wrote in message
news:F3F472CD-3057-4787-A7A1- 54AB47F69289@microso
ft.com...
> We have a standby system where Crystal Reports are running against. Every
> time it restores TLog we have to put the database into single user mode or
> the running reports will block it from restoring Tlogs. And because of
> that
> those reports fail.
> Is there anyway to make both of them run successfully at the same time?
> Gracias.
> LaEsmeralda
| |
| Paul Ibison 2006-10-31, 12:15 am |
| Just to add to the other comments, I'd consider looking at transactional
replication with snapshot committed isolation level
(READ_COMMITTED_SNAP
SHOT). This gives a max concurrency solution that
supports FTI and can be backed up for resilience.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|
|
|
|
|