December 16, 2013 at 7:04 am
Hi guys,
This is my first post. So hi all, Is it possible to snapshot a SQL 2008 without the Enterprise version such as a 3rd party product? The issue we have a commercial system that they always said you can write your own reports using Crystal Reports in order to get your data out and so we did the problem is whenever a view runs it locks the involved tables for the duration of the report which in turns stops everyone working thus costing 100x of working hours every months and when we challenged the software house they recommended using SQL Enterprise (very expensive) and run the reports on the read only database.
Any thoughts would be appreciate it.
Thanks
Wessam
December 16, 2013 at 10:00 am
If its acceptable for your reports to contain "dirty reads" changing the transaction isolation level for the connection is an option. This will prevent locking of the data, I must admit I havn't tried this as I havn't used crystal for many years but this may be what you need.
MCITP SQL 2005, MCSA SQL 2012
December 16, 2013 at 10:57 am
Or you can set up mirroring or log shipping or replication... None are easy, but all can be done in such a way to get a read only copy of the database for reporting. They're just a lot of work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 16, 2013 at 11:06 am
Thanks for your reply
Did I forget to mention I only have standard edition.
Cheers
Wessam
December 16, 2013 at 11:19 am
wessambaroudi (12/16/2013)
Thanks for your replyDid I forget to mention I only have standard edition.
Cheers
Wessam
Log Shipping is totally supported in Standard Edition. Should be able to query against your Standby database for your reports(except when a log backup is being restored) as Grant suggested even if you are running on standard edition at both ends.
December 16, 2013 at 11:58 am
Replication is also supported in Standard. Mirroring is also supported by Standard (although a slightly reduced version). You can see the versions here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply