.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SQL 2005 LSBackup_SID transaction logs hung...

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
Hello folks, I've searched google dry.. I feel as if I am the only one with this issue (hope not)!!.. for some reason my transaction logs stopped generating files via the job LSBackup_sid, i had my log shipping very nicely setup my secondary DB was in (restoring mode) LScopy and LS restore were running quite nicely but not the LSbackup_sid job on the primary simply stopped creating transaction logs to any shared folder I point it to. I have tried to redo all the shipping log process, I have tried pointing it to a different path, i even restored my secondary DR database and brought it up with SAP to see if I can get my trn files back on the primary.. there simply is no error on the LSBackup job it just says running forever: see below   Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted 09/07/2010 00:22:01,LSBackup_PAB,Unknown,,,LSBackup_PAB,,,In progress,00:00:18.4770000,,,,,, 09/07/2010 00:21:43,LSBackup_PAB,Unknown,1,DBGRPNEW,LSBackup_PAB,Log shipping backup log job step.,,2010-09-07 00:21:48.30 Backing up transaction log. Primary Database: 'PAB'<c/> Log Backup File: '\\sapprd2\bckp_drc\PAB_20100906212148.trn',00:00:05,0,0,,,,0 09/07/2010 00:21:43,LSBackup_PAB,Unknown,1,DBGRPNEW,LSBackup_PAB,Log shipping backup log job step.,

View Complete Post

More Related Resource Links

Transaction logs will not shrink


We have two databases on our SQL Server 2000 installation that has huge transaction logs. One of them is at 32 GB and the other is around 48 GB. When I go into the Enterprise Manager and select shrink, and then select file and the log file, it shows the actual size is much less like around 2-3 GB. After selecting to shrink the file to this size (2-3GB) and waiting, when finished, I see no change in file size. I've gone back into shrink and the file size still remains the same, like it is not shrinking it properly. We also used Backup Exec and backed up the logs with trunicate. What can we do to shrink these log files?

The transaction has aborted for Custom workflow using VS 2005


I have a custom workflow created with Visual Studio 2005 Extension for Windows Workflow Foundation and Visual Studio 2005 extensions for .NET Framework 3.0 (WCF & WPF), November 2006 CTP. We have SharePoint Enterprise 2007 SP2. We have 2 web front end, one Search server and one SQL server 2005. The problem I have with the workflow is that I get this following error randomly for workflows that have been running and in progress and are waiting for an approval. This is the error.

Main Exception: Source: System.Workflow.Runtime
Message: The transaction has aborted.
Stack: at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation) at System.Workflow.Runtime.WorkflowExecutor.ProtectedPersist(Boolean unlock)
Inner Exception: Source: System.Transactions
Message: The transaction has aborted.
Stack: at System.Transactions.TransactionStateAborted.CreateAbortingClone(InternalTransaction tx) at System.Transactions.DependentTransaction..ctor(IsolationLevel isoLevel, In

Delete Transaction Logs


HELP!  I have a question which I think should be pretty simple and I can't seem to find a simple answer...

I am developing an app that uses SQL Server as the back end.  It appears I was not managing the DB well because the transaction log has grown so large it has consumed my whole hard disk. The log as of now is about 50GB for an app where the database is less than 0.3GB.  The app is under development and the logs are of no value to me right now.  I just want to DELETE them and start them over at 0GB.  Is this possible?  I have read all kinds of posts about backing up the logs in order to shrink them.  I can't back them up, I tried... I am out of space.  I just want to delete them.  I think I see where I can do this under DB Management.  What happens if I create a new log file and then delete the old one.  I don't care about recover as the DB is constantly being deleted from and all tables being recreated.


- Charles


Transaction Logs growing tremendously


We have an ASP.Net2.0 application with SQL server 2005 as Database. We use a database ASPState in SQL server to store ASP.Net Session State. Recently, the transaction log of this database started increasing by 4Gb for every 15 minutes that it reached 20+GB and it got the server down.

We investigated from Application side and the transaction in the tables which didn't end up in the root cause.

Is there any smarter way of analysing this issue to find the Root Cause?

Any suggestions for avoiding such crash in feature would be gratefully accepted.

Other Details: It's a SQL Server 2005 Enterprise x64 edition deployed on a windows server 2003 box.



Transaction logs dont get truncated after backup


Hi all,

I've used TFS Power Tools to setup a db backup plan for a TFS 2010 instance using SQL Server 2008. The result is a sheduled full backup at 02:00 each night and a transaction log backup every 2 hours. The backups work but there is a problem with the transaction logs not being truncated after backup. When this was brought to my attention typically all the transaction logs were 10-30 times larger than the data files... I searched the www and found these two useful commands:

SELECT name, recovery_model_desc, log_reuse_wait, log_reuse_wait_desc FROM sys.databases
dbcc sqlperf(logspace);

For all relevant databases log_reuse_wait = 2 and log_reuse_wait_desc = LOG_BACKUP. The dbcc command told me that log files were about 95% in use.

Searched som more on thee www and ended up with this manual procedure to "fix" the problem:

  1. Right click db and select Tasks -> Backup...
  2. Change Backyp type to Trasanction Log and press Ok.
  3. Repeat steps 1 & 2. (Had to do it twice and

Move transaction logs with Power Shell?


I'm new to Power Shell, but would like to see how powerful it is.  I need to move some transaction logs from one volume to another with more space.  Is it possible with Power Shell?


SQL server 2005 transaction replication requirements


Hi All,

Please any one how have information if that the SQL server 2005 transaction replication require windows server Enterprise Edition, is that right on not ?



How to Encrypt and Decrypt a Password using SQLSERVER 2005?(Video)

Encypt and Decrypt a Password using SQLSERVER 2005(Video)

SQL Server Database Transaction

A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

SQL Server 2005 Try and Catch Exception Handling

I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:

sql server 2000 vs 2005


i would like to ask what the difference between sql server 2000 and 2005 

How to save Unicode in SQL Server 2005

I am using google transliteration to display the text in Hindi/Tamil

I tried to store the text appear as Hindi from textarea in an nvarchar
field of database (SQL Server 2005) , the text saved as "???????".

After retireving text from the same it display the text as "???????".

Can anyone help me how to store and retrieve the actual data from SQL
Server 2005?

I am using ASP.net,VB.Net and SQL Server 2005

build repository from SQL 2005? for a Linq, Jquery autocomplete



  I have the a question am going about his correctly I have a database for categories, it has many fields and about 4000 records,  but with a Jquery autocomplete needing speed and the fact that I only need to return a key and category name. I did the following:  (oh just to note, MVC2, Ajax project)


    public class categorySearch
        public Guid Category_GUID { get; set; }
        public string Category_Name { get; set; }


and now for the repository

    public class categoryRepository
        internal List<categorySearch> FindCategory(string searchText, int maxResults)
            List<categorySearch> category = new List<categorySearch>();
            dbWebEntities storedb = new dbWebEntities(); 

            var getcat = storedb.Categories.ToList();

            foreach (var item in getcat)
                category.Add(new categorySearch { Category_GUID = item.Cat_GUID, Category_Name = item.Category_Name});

            var result = from c in category
                         where c.Category_Name.Contains(searchText)
                         orderby c.Category_Name

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

sql server 2005 enterprise edition is required


sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks


Multiple web methods in one transaction


Hi everyone

Sorry I am kinda new in web services, so it may sound a bit newbish question.

We have a web service that comunicates with the database and exposes web methods that enables the application to access the database. Each method does only one operation (Insert, Update or Delete). What I need to do is create a transaction that will be consisted of multiple calls to the database, meaning multiple calls of more then one web methods. Can I do that? (I read that if the web method does not throw exception - or ContextUtil.SetAbort() is not called - the transaction will be commited automatically when the web method finishes executing, which I don't want to happen because I want to call another web method in the same transaction, and then manually commit the transaction)

Thank you in advance.

Reporting Services SQL 2005 .Net 4 compatibility?


I've been working on my first asp.net application and for the most part it's been pretty smooth.  Right now I'm having trouble getting reporting services working under SQL Server 2005.  I developed the site with Visual Studio 2010 and didn't think about any of the .Net 4.0 compatibility issues that have arisen.  I'm having no problems with the site communicating with SQL Server 2005 for the regular database stuff.  The only problem I'm having is with setting up Reporting Services.  I have the .Net 4.0 framework installed on the server, however Reporting Services is still using 2.x.  I'm not sure if this is a problem with SSRS or with IIS.  When i go to localhost/Reports it's reading my web.config for my application and throwing an error: "Parser Error Message: Unrecognized attribute 'targetFramework'."  This is referring to a line in my web.config where targetFramework is set to 4.0.

Software that I'm using:

  • Visual Studio 2010
  • SQL Server 2005 Standard
  • IIS 7.0
  • .Net 4.0

Any suggestions?  

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend