Browse by Tags

  • Log Shipping Doubt

    Dear All. I have my environment with SQL 2005 Databases and those Databases are configured with LogShipping Configuration.here i want to clarify one doubt related to detaching the Databases. my database has been configured the LS Process and i want to detach my database for some purpose. If Once i detach...
  • Loghipiing

    how to redirect the clients to the application after failover to secondary server in logshipping sqlserver 2005 i got this question in some interview "how to connect to the application after failover to secondary server in logshipping" thanks in advance
    Posted to Getting Started (Forum) by glnprvn on 09-30-2009
  • Re: mirroring and logshipping

    Hi, Sure, you can use your Mirrored database for the reporting purpose, to achieve this you should create a snapshot on mirrored database point all your reporting to it read article http://technet.microsoft.com/en-us/library/ms175511.aspx AFAIK, without breaking the LS we can not move it. Regards
    Posted to Getting Started (Forum) by ghemant on 07-27-2009
  • Re: Error: 14421

    Welcome to the Forums!! Did you go through this KB http://support.microsoft.com/kb/329133 If you go the the SQL Server logs on the secondary server it will tell you when the last log was restored for that particular databae, or right click on the job and say view history. By any chance do you or any...
    Posted to SQL Server 2005 Log Shipping (Forum) by ghemant on 07-10-2009
  • how to create Login to Log Shipping Server Databases

    Hi all, Here I am facing one issue in Log Shipping server: I have configured the Log Shipping in my production server and those databases are in Read-only/Standby mode for the purpose of Reporting Services. After configuring the Log shipping the login are not updated from Production server to Log shipping...
  • Error: 14421

    Hi, Yes. I'm getting this error. I've read a lot of posts on this error. 1. The date and time on both servers are exactly the same although the time on one server is on a 12 hour clock while the secondary server is on the 24 hour clock. 2. The log shipping Restore job that is running on the secondary...
    Posted to SQL Server 2005 Log Shipping (Forum) by rstelma on 06-22-2009
  • Re: Log Shipping - Copy job not working

    [quote user="saigeeta"]The copy and restore jobs on the secondary servers do not seem to be working. The copy job is reporting as successful and the duration recorded for the copying is either 0 or 1 seconds in the job history.[/quote] Check the error log for the exact error message, also check...
    Posted to SQL Server Log Shipping (Forum) by ghemant on 05-28-2009
  • Backups and Log shipping

    Does a full/differential backup made using the backup dialog box in SSMS disrupt log shiiping of that database??? if Yes how can we take a backup of that system without disrupting log shipping
    Posted to Getting Started (Forum) by Shanika on 05-10-2009
  • Error message 14420 and error message 14421 that occur when you use log shipping in SQL Server

    If you are using SQL Server Log Shipping then above error message number will be familiar. One of the following error messages may be logged in the SQL Server error log: Error message 14420 Error: 14420, Severity: 16, State: 1 The log shipping destination %s.%s is out of sync by %s minutes. Error message...
  • Log Shipping does not create tables on Standby Database

    Good Day, We implemented Log shipping between 2 of our SQL Server 2005 servers . Afew day later tables were created on the Live database .The restore jobs were successful. We checked the Errorlogs of SQL Server and the report files of Log Shipping . They confirmed that the Logshiping was cmaking...
Page 1 of 5 (49 items) 1 2 3 4 5 Next >
 



© 2010 Jude O'Kelly All Rights Reserved.