SQL Server Performance

Log Shipping on production Server

Discussion in 'SQL Server 2005 Log Shipping' started by Akthar, Jun 5, 2007.

  1. Akthar New Member

    Does Setting up of a log shipping affect a running production server

  2. rklimes New Member

    Not in my experience. What problems were you thinking?
  3. Akthar New Member

    i mean does the sql server service restart when configuring log shipping

  4. MohammedU New Member

    No...<br />It will not effect the service at all <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
  5. Akthar New Member

    Great Thanks

  6. Akthar New Member

    i have setup a log shipping on a test server with 2 instances.
    The LogShipping is enabled with no errors. The first backup and restore is created. But nothing happens after that. No other backup are been done and no restore.

    When i right-click on the database on the primary instance - in properties and Transaction Log shipping the log shipping option is not enable? and advice

  7. Akthar New Member

    ok i got the answer. The log shipping was not working as one of the istances was SQL express

  8. Akthar New Member

    guys,<br /><br />i have setup log shipping yesterday on my production server and my backup server both running SQL 2005 Std. I have started my SQL agent service on both server with a domain account that have necessary permission on shared folders where i copied the backup logs.<br />I could not configured log shipping as i was getting access denied error. <br /><br />I had to use the same account to start the SQL Server Services on both sides. Which had an impact on my production enviromnent.[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br />[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br /><br />AKTHAR

Share This Page