In our environment we have sql server 2012 . we need the database in sql server 2012 to be used for reporting services. we hvae already being using it for reporting but we face lot's of blockings in it. Which is the best way to reports fetching. we dont need to replicate to secondary for reporting purpose as it depends on the application settings..
As of now i had taken a snapshot of the database everyday (job) for reporting purpose in live server itself. Disadvantages are there for snapshot as there is a over-head in I/O for the live database. If we consider to schedule a job for backup/restore then i am not sure whether restoration happens without any problem as there would be existing connections to the database as it couldn't be killed . so anyone suggest which type of high availability can be used.Also logshipping and mirorring cannot be done on the same instance.
Anyone could help me in solving this problem.