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

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

restore log issue while doing the logshipping

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
We have a database for logshipping, recently we have the following issue which is the restore log job failed in the standby mode database. We uncommonly encounter such issues, and search the answer on the internet with no answers. Can anyone help ? Following is the issue with the details: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3142: [Microsoft][ODBC SQL Server Driver][SQL Server]File 'oadb_Log' cannot be restored over the existing 'F:\MSSQL\LOG\oadb_log.ldf'. Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.happyMan

View Complete Post

More Related Resource Links

logshipping issue

We had implemented the logshipping in our server, now we found the curious thing: the logshipping job was all successful, the logshipping monitor also showed successful. But checking the restore log in the logshipping monitor, still found the following issue: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\oadb_tlog_201009010000.TRN'. Device error or device off-line. See the SQL Server error log for more details. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally. We have no idea whether the logshipping was successful or not. But if not, why the restore job was successful and also shows the error?happyMan

Lookup field issue after restore

After restoring a site collection in MOSS 2007, lookup fields cannot link up with the parent list. May I know if this problem fixed in MOSS 2010? Besides, the list item GUID in MOSS 2007 are changed after restoring. Does this case still appear in MOSS 2010? Thanks!

Logshipping Restore Secondary database

Hi Team,   i have monitoring log shipping jobs in the prod environment right users are using secondary server my client is suggested to restore the secondary server is it possible to restore secondary server if yes how can we do could you please explain me   Txsubu

Sharepoint Designer restore issue or perhaps BPOS permissions issue


Trying to use Sharepoint Designer 2007 SP2 to backup and restore site to BPOS. Backup works fine, restore uploads all .cmp files and then comes with an error "Operator does not have web administrator access to import location".

Any ideas ?

issue after SQL Server 2005 piecemeal restore


I have a table that I partitioned into 6 partitions with each partition residing on its own filegroup. The table is partitioned based on a identity column that is a clustered index as maximum queries run on this column. Though we are supposed to maintain last 12 months worth data online; our application always hits the latest data. And I also wanted to implement sliding window approach hence I aligned index with data.

Our growth rate of table will be 50GB per month. And on an average we will be archiving 50 million records every month.


·          I made sure that first partition of table reside on first file group and second partition of table reside on second file group and so on. I implemented this because I know my application only hits latest data so in case of any disaster if I had to restore from a full backup then just restoring primary followed by the latest file group (which has latest data) should get my application up and running. And I tried this piecewise restore on a test DB.

My test DB has a table called Table1. Table 1 has 1mi

Logshipping - Restore fails - missing .tuf file

I have had successful log shipping enabled on SQL 2005, SP3 on server A and B.  I had to remove secondary db to load localized reports, and when I try to re-enable or even reconfigure Log Shipping from scratch, the .tuf file is not being created in the backup and copy folders with the log files, therefore the trn files are skipped and cannot be applied.  I have completed similar steps on alternate SQL 2005 boxes  with SP3 Hot Fix 4 producing similar results.

Help with confusing MS SQL backup and Restore issue

I have a MS SQL database that is used in an old proprietary program.  Currently the datafile is running on a server that has SQL server 2008 on it.  When I open SQL 2008 management studio, I can see the database, but none of the tables show up.  Instead I get an error message about running dbcc check data.  However, when I attach to this instance from another server running SQL 2005, I can view the tables and run querys on it.  The program currently works fine, but I need to make sure I can do proper backup and restores.  If I try to run a back up in 2008 managment studio I get an error, if I run the backup from the other server with management studio 2005 I get a successful backup.  However, when I copy the backed up file from the production server to the one where I have 2005 installed, I can't restore the database.  Can anyone guide me in how to solve the problem? 

SQL Server Backup and Restore (video)

Restore your full backup, then run a few queries before you keep restoring transaction logs. Brent shows how to use the Standby option for restores.

In this five minute video, Brent demonstrates how to do it by creating a database, populating data, and then showing what disaster recovery is like by doing RESTORE WITH STANDBY.

IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"


MVC2 issue - Stuck. Trying to create a cms with nested partials


I am currently trying to display multiple items on a single page. I am not sure as to how to tackle this. What I have is a database table that has all the page data in. I have this run as a PagesController and this works fine. However what I would like to do is, if say the Products page is selected via the menu, I want to pull back not only the Products page html but also get all the products, and even be able to pull them through via category. I was trying to use a partial view, but I can't get it to work. The same would be for other pages, having partial views to display the other content, ie if Gallery is selected, the page html for Gallery shows and it then can push to a partial view that pulls all the gallery images from the gallery db table and so on. 

Maybe I am tackling this the wrong way. I have the pages stored in the db to allow for a CMS system I have setup. Maybe I need to use models for all the other items(Products, Gallery, Videos and such) and use the partial for the page html?

Any help would be greatly appreciated as I am confused.

xpath issue


Hi i am using xpath to loop through each node,

the xml is below i can get the value of "link" but i cant get the thumbnail value, have you got any ideas how i can do this, my code is below.



     <link>test 1</link>
     <media:thumbnail url="http://test.com/image.jpg" height="75" width="75" />



     <link>test 2</link>
     <media:thumbnail url="http://test.com/image.jpg" height="75" width="75" />


public void FindLinks(XPathNavigator p_xPathNav, DataTable dt)
            //run the XPath query
            XPathNodeIterator xPathIt = p_xPathNav.Select("//item");

            //use the

User validation Issue in xlsx file



I am validating user from Login.xlsx file. It was working fine by validating email and password from that file. For testing i got new file same contents of file but added some more user names.

So after that when i validating the user i am getting the following error "Data type mismatch in criteria expression".

But when i replaced the new to old one it is working fine. The contens of both files are the same. So why this kind of error happened.


Multiple Paramatized Threading issue


I need the funcitonality to have two methods run concurrently of each other and the parent thread (aka the method that makes these two calls) to halt until BOTH are done. After the threads are done, I need to perform logic on the returns of the method, so it is essential for both of them to be complete before the parent thread continues. I have searched the internet and tried varous attacks, and I always come up with the same result, this being the parent thread continues operation after the first thread finishes, leaving the second thread running.  Can someone show me a quick example of how I can do this. I have tried checking states of the threads, halting the threads, but I always end up with the same thing. Any help would be great. Thanks.

Data Truncation issue with Enterprise Library Logging WriteLog stored Proc


Hi ,

I'm using Enterprise Library Logging  feature for logging. The issue i am facing is when the Logging message is too large(more than 65534 chars) ,complete data  is not logged in the Formatted Mesage column which is  of data Type nText .

I am able insert complete data if i try inserting from Sql insert Query from sql management studio. Do i need to add any attributes to data base listener or do i need to change the sp.

 Is there any way to increase the WriteLog stored proc param size in EnterpriseLibrary.Logging config file ? . Please let me know.


Thanks In Advance.

Word Automation Issue in Windows Server 2008 Hosting



The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.

With Regards,


If Statement Issue



This is very strange to me. I have spent 2hrs looking into this inside out , but dont seem to get it

I have an if statement that inserts data into the database. But i check to make sure the name is not entered twice. Now when the name is already in the db, then it should insert else put out a message saying its already in the db

My code works fine except that  when its not in the db, its inserts but still puts out the message that says "Name is already in use" Not sure if am not seeing something. But thought i did bring it to the forum. Here is my code...Pretty simple

Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click

        Dim objConnection As SqlConnection
        Dim objCommand As SqlCommand
        Dim strSQLQuery1 As String


        ' If there's nothing to Add for then don't search
        ' o/w build our SQL Query and execute it.
        If String.IsNullOrEmpty(txtAdd.Text) Or Leadbank.SelectedValue = "000" Then


Toolbox: Issue and Defect Tracking, Automate IT Tasks, and More


In this issue, issue and defect tracking, automating IT tasks, and more.

Scott Mitchell

MSDN Magazine December 2006

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