user connectiviy when LS restore

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

user connectiviy when LS restore

Author

Topic

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-12-29 : 16:19:00

We hava a server that being a logshipped server. Today some users are saying that they are not able to access the database (loghshipping prod copy).The transaction log files are restored every 15 min (starting 12Am to 11:59Pm DAILY), restore takes less than 1min to complete.

My question is..
will user connections be terminated when restore is performed ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-29 : 16:33:10

In order for a restore to work, no users can be connected to the database. So you should set the option to terminate all users during each restore, otherwise the restore will fail.

Log shipping is not a good solution for a reporting environment due to this. You should consider using transactional replication instead.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-12-29 : 16:36:41

Thanks much

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources