The attachment that you are looking for no longer exists.
It looks to me like the problem we are experiencing on the passive node is because the SQL server agent is being allowed to start even though the SQL service on the passive node has not finished applying the SP, maybe it is checking the.
MS have now posted a resolution on 22nd Sept.Databases A inner join ster_files B.database_id.database_id.MS say you can update the passive node but you need to remove the passive node as a possible owner for the SQL service while you upgrade (not a step we had performed.For SQL Server 2005, dBCC shrinkfile ( Database_log_file_name, notruncate).You can't delete your own topics.You can't edit other posts.You can't post html code.Where me NOT IN ( 'master 'model 'msdb 'tempdb' ).Tech194305 August 14th, 2013 m/docs/tech194305, support sQL 2005/2008 maintenance plan to shrink and limit the transaction logs of sem5 database.
BB db, 50GB transaction log first run: 39 GB log shipping backup, copy, restore after second run:.
Welsh Corgi SSC-Forever Group: General Forum Members Points: 40098 Visits: 4895 Bad News: Posted to wrong thread.
Set up: 64bit SQL2008 on Windows 2008 cluster Server replicating to same set.
Do you have open transactions?
Related Articles, subscribe to this Article, manage your Subscriptions.
Script here: Needs minor adjustments to get statistics from ats vin SSC-Addicted Group: General Forum Members Points: 403 Visits: 515 We upgraded book of ra deluxe 2 pc last week to SP3 and lo behold the same problem occurred.
If it shows up as replication, then you have an issue with replication not completing so those transactions cannot be marked as reusable.Powered by InstantForum 2016- Execution:.000.After this was done the transaction log was still the same size and would not shrink.You can't edit other events.Databases showed as active_transaction, so I ran dbcc opentran which showed this: Oldest active transaction: spid (server process ID 7s, uID (user ID) : -1, name : tran_sp_MScreate_peer_tables.Here is the script: drop table #CommandQueue, create table #CommandQueue ( ID INT identity ( 1, 1 ), SqlStatement varchar(1000) ).For better, quicker answers on T-SQL questions, click on the following.You can't post replies to polls.You can't delete your own events.Print Article, related Products.Databases for that database.Liam vin SSC-Addicted Group: General Forum Members Points: 403 Visits: 515 It is also worth noting that you will lose all indexes (and statistics) on the subscription database bar primary keys after reinitialising, I am just recreating from a back up now!I was wondering whether reinitializing the subscription might resolve this, I have tried running the snapshot agent to synchronise the dbs but this did not change anything.