Log Shipped but Won't Update

Posted by MooCow on Stack Overflow See other posts from Stack Overflow or by MooCow
Published on 2010-06-07T11:08:52Z Indexed on 2010/06/07 11:12 UTC
Read the original article Hit count: 211

Filed under:

sql-server-2005

|

log-shipping

I'm currently taking the MS SQL 2K5 Admin course at a local college and ran into a problem with the Log Shipping part.

My setup is the following:

Windows 7 x64 SQL 2005 SP3 2 SQL server instances on the same machine

Log Shipping settings:

Performed full then log back up of Primary
Manually restore on Secondary in STANDBY MODE
Insert a new record into the table
Set up Log Shipping on Primary using SQL Authenication login to connect to the Secondary
Set up timers and copy destination on Secondary
Monitoring instance not being used

I set up a shared folder for WORKGROUP so both instances on the machine can read & write to it. I can see transaction logs generated and copied as defined by the Transaction Shipping wizard. However, the specified table on the Secondary instance is not updating.

© Stack Overflow or respective owner

Related posts about sql-server-2005

[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

as seen on SQL Authority - Search for 'SQL Authority'
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many… >>> More
SQL Server 2005 - Syncing development/production databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server. My main concern is deploying schema + data updates to developer machines from the "master" development… >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More

Related posts about log-shipping

Log shipping and shrinking transaction logs

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
I just solved a problem that had me worried for a bit. I'm log shipping from three primary servers to a single secondary server, and the transaction log disk on the secondary server was getting very full. I established that several primary databases had unused space that resulted from big, one-off… >>> More
SQL log shipping for reporting

as seen on Server Fault - Search for 'Server Fault'
I would like to create a read-only copy of my SQL Server 2008 database on a secondary server for reporting and analysis. I've been testing log shipping, configured to run every 5 minutes or so. Alas, there appears to be a stumbling block, for exclusive access is required on the target database during… >>> More
SQL Server 2008 Logshipping not Restoring

as seen on Server Fault - Search for 'Server Fault'
I am getting the following errors during the restore part of the Logshipping process on my secondary server: 2010-04-01 10:00:01.85 Error: The file 'F:\UK_20100327090001.trn' is too recent to apply to the secondary database 'UK_Backup'.(Microsoft.SqlServer.Management.LogShipping) … >>> More
hundreds of databases sql server log shipping

as seen on Stack Overflow - Search for 'Stack Overflow'
SQL Server 2005 Standard 64x, with 300+ tiny databases currently (5MB each), user base adds databases as needed. Want to implement log shipping for warm standby, but not via the wizard, since that looks like it adds 3 jobs (1 on primary, 2 on secondary) for each log-shipped database. Do I try to… >>> More
log shipping of biztalk database on SQL server 2008 standard edition

as seen on Server Fault - Search for 'Server Fault'
Hi, I want to do log shipping for biztalk databases on SQL server 2008 standard edition (server A) to another SQL server 2008 standard edition (server B). I was told that for biztalk, logshipping is not like standard logshipping. I was able to find 2 links: http://msdn.microsoft.com/en-us/library/cc296836%28v=BTS… >>> More