April 21, 2009 at 11:54 am
Hi everyone,
We are using Log Shipping to copy a database from Prod to reporting server.
When the restore step happens on the secondary server all the users are disconnected. then i used the option to delay the restore process but the users are running continously and the restore job is failing.
Is there a way we can use the online restore option of SQL Server 2005 in log shipping ?
I changed the restore job from 15 minutes to 8 hrs now but i want to run the restore job as often as possible to get the latest data on to secondary server.
Thanks.
April 21, 2009 at 12:19 pm
am not very familiar, but There will some check box while configuring i assume, "Terminate User connections" . one of my colleague was telling it, you may check properties and uncheck it if checked.
Thanks,
Sudhie.
April 21, 2009 at 12:34 pm
Not sure what you mean by "online restore" - users have to be out of the database for a log backup to be applied. There is an option "Disconnect users in the database when restoring backups" - if you check this then users will be kicked before the log is applied, otherwise the restore will fail.
April 21, 2009 at 1:22 pm
From "Implementing Log Shipping" at http://technet.microsoft.com/en-us/library/cc917705.aspx
Because log shipping relies on the SQL Server restore process, user connections to the standby database must terminate each time the transaction log is restored. As a result, if you also want to use a standby database for reporting or maintenance tasks, you must restore the transaction logs less frequently.
SQL = Scarcely Qualifies as a Language
April 21, 2009 at 3:38 pm
reddi_arjun (4/21/2009)
Hi everyone,We are using Log Shipping to copy a database from Prod to reporting server.
When the restore step happens on the secondary server all the users are disconnected. then i used the option to delay the restore process but the users are running continously and the restore job is failing.
Is there a way we can use the online restore option of SQL Server 2005 in log shipping ?
I changed the restore job from 15 minutes to 8 hrs now but i want to run the restore job as often as possible to get the latest data on to secondary server.
Thanks.
I suppose your secondary is on Standby mode. Who setup the logshipping of your server? While restoring a database the database should be in a singple user mode. There while setting up Logshipping you have an option to either kick off the Users while restoring or Restore while no users are online. So, if you are not sure you need to reconfigure your logshipping and its always a better idea to Document what you have done and signed by your management.
Thanks,
April 21, 2009 at 3:57 pm
Any chance you are using enterprise edition? If so you can use mirroring with snapshots rather than logshipping, which is not ideally suited to your purposes
see http://msdn.microsoft.com/en-us/library/ms175511.aspx
---------------------------------------------------------------------
April 21, 2009 at 4:20 pm
reddi_arjun (4/21/2009)
Is there a way we can use the online restore option of SQL Server 2005 in log shipping ?
Theres not really any option like that Log shipping is a pure DR technology same with DB mirroring. As advised above you can use DB mirroring but with updated Snapshots. What are your requirements? how does your users want the data to be?
Did you think of Replication? Any interest to you to publish the interested tables?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply