This is the most common issue, for some reason if the last t-log backup is not restored and another t-log backup has been taken and shipped to the standby server this will come up. Some times it happens that latency time is not set accordingly i.e. taking a t-log backup -> copying to standby ->...

I have OLTP central database sql standard 2005 that is currently working within LAN. It is required that new three remote branch sites will connect to the SQL server and do update/insert/delete and reporting. The four sites are connected with frame relay WAN. The main site is 512 kbps and has the database...

Hello. I am getting the followin error while trying to set up Log Shipping in SQL 2005 Standard Edition. Please note that I can set it up on the other two instances on this box. Log shipping is not installed on this instance. (Microsoft SQL Server, Error: 32018) Any help you can provide on this would...

I have created a log shipping between two server. 1.Production Server : Act As Primary Server 2.Backup Server: Act as Secondary Server. Primary Server having the maintaince plan . on primary Server all jobs are get successful but on Secondary Server one Job fails : populated the error like Executed as...

Thanks mohammed ,,,,I have one more question like related to SQL Mail Configuration in SQL Server 2000. I want to configure mail for jobs,when the job completed successfully i need to receive a notification through mail confirmation. I am trying to configuring the mail but its asking like MAPI account...

HI All, I need to perform log shipping from primary server to secondary server.But production environment the SQL serevr 2000 setup is Standard edition with sp4. This Standard edition allows you to perform log shipping through Database maintainance plan or not? I came to know that Enterprice Edition...

Hi, We have one of the databases on SQL Server 2005 Enterprise edition. Its around 500 GB and is configured for mirroring as well as log shipping.Mirroring is configured through SQL Server database properties where as log shipping is happening through a 3rd party tool by redgate called SQL Backup.There...

Yes, even in log shipping you changes to db sizing are not appiled automatically

Hi Praveen, Thanks for you´re answer :-) I thought about replication to but was hoping for this solution to work since this will be much less work to keep in sync if the structure of the orginal db keeps changing, I would get a warm stand by server as a bonus and also the new db could be used as a source...

Hi all, I would like to set up a copy of one of the production servers we have for reporting purposes (to take load of the production db) and was wondering if that would be possible with log shipping if I use transactional log shipping in combination with the online restore feature in the enterprise...