.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

Logshipping prob

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
In logshipping two tables are missing one of my team member is saying those are truncated is it possible
In logshipping primary server Database 'a'
table 'xxx' is truncated

in case it is truncated how can restore it from secondary server please guide me..



View Complete Post

More Related Resource Links

Logshipping prob

Hi Team,

In logshipping two tables are missing one of my team member is saying those are truncated is it possible
In logshipping primary server Database 'a'
table 'xxx' is truncated

in case it is truncated how can restore it, from secondary server please guide me..



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

restore log issue while doing the logshipping

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

Memory Prob

HI I have a server with 8 Gb Ram I installed Sql server 2008 R2 on 64 bit platform Enterprise edition,in that for Sql server I allocated 6 GB of Ram I enable the AWE oprtion as well but in processing time it taking above 6 Gb ram like 7.gb or more after query completing its not release the memory how can I resolve this issue.

SQL 2005 Logshipping to secondary server not completing

Hi All, I have performed a log shipping in the primary server to secondary server. The log shipping task tell all the steps have executed successfully. But in my secondary server I can see that the database is still DB_NAME(Restoring...). It is not getting completed atall. Is there any thing that I need to do here. Thanks in Advance, Chaks.

Difference T-log and logshipping

Hi Team,   any body explaine   What are the difference between Transaction Replication - Logshipping.?   Tx  subu

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

html anchor bookmark prob


Hiiiii Coders,

I m using html anchor tag as bookmarks means whenever i click on a link it, it navigates to a particular section. It is working fine but when i click on it, the corresponding section's header is not showing at top of my page or window.

I want that whenever i click on link, it should display the corresponding section' heading on top of window or page.

How can i achieve this?

my html code is-

<li><a href="#1">abc</a></li>
<li><a href="#2">def</a></li>
<li><a href="#3">pqr</a></li>

my corresponding section' header code-

<a name="1"><div style="background-color: #EAEAEA; text-align: left; padding: 3px 0px 3px 3px; ">
<h1 class="mysubheadings" style="margin: 3px 0px 3px 3px;">abc</h1>

<a name="2"><div style="background-color: #EAEAEA; text-align: left; padding: 3px 0px 3px 3px; clear: both; ">
<h1 class="mysubheadings" style="margin: 3px 0px 3px 3px;">def</h1>

<a name="3"><div style="background-color: #EAEAEA;">

Network Path not found -Logshipping Error


Gurus, I am trying to set up logshipping in 2005 and copy job on secondary server is failing with the above mentioned error,i have checked from the command line and i am able to copy files, i tried this on secondary server:runas /user:syncaccount cmd and then i am able to copy files using x copy but somehow copy job is failing, i have given the required permission on shared folder to the sql server service account.

Please help



SQL 2008 SP1 - Log shipping solution with Logshipping monitor on SQL Server Express Edition SP1 (bad


Hello All !

I'm installing a log shipping solution with SQL Server 2008 Standard SP1 (on x64 US). I use a monitor logshipping with SQL Server Express Edition x64 SP1 US. When I try to connect it, I have this message when i tried to use w.x.y.z\SQLEXPRESS  as a monitor server:

'w.x.y.z\SQLEXPRESS' is not a valid monitor server instance.  A monitor server instance must be SQL Server Standard Edition, SQL Server Workgroup Edition, or SQL Server Enterprise Edition.'

In SQL 2005, it is possible to do that with SQL Express. And with 2008 R2, is it possible too or it is the same problem ?

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

SQL2005 LogShipping or Cluster for my usage


Hello Everyone,

I have a situation where I have a siteA and a siteB with a SQLServer 2005 Standard Edition on both site. I want that siteA has the primary database and site B the secondary database but when the VPN between both sites is DOWN I would like that siteA will become secondary serving only the siteA and siteB become primary serving the siteB and every others sites.

I have tried Replication scenarios and log shipping. In final I would use log shipping but I have a problem when siteA become secondary I can serve siteA with database on siteA but when the VPN becomes UP I can't keep changes done on databse A.

What's the best approach in this kind of situation?

PS : My databse is used for Dynamics AX

Index Rebuilding in Logshipping

Dear All,

I have configured logshipping with stand by option for reporting purpose. Please find the configuration details as below as

Primary Server: SQL 2005 sp3 EE 64 bit

log backup frequency: every 15 min

Secondary Server: SQL 2005 sp3 EE 64 bit

restore frequency: every 2 hours

Mode: stand by mode(secondary server's db is in read only mode for reporting purpose)

here my questions  are

1. when i do index rebuilding operations on a table in the primary server, will the indexes on the table  in the secondary server also be rebuilt? i hope index rebuilding is fully logged operation. or do i have to configure the separate maintenance plan on the secondary server to rebuild the indexes?

if the database is in bulk logged mode what will happen?

2. how do i find when the index was rebuilt last?

Please help me on this.

Thanks in advance.


For LogShipping

Require some assistance from users, regarding log shipping. Being aware of normal setup & working I am looking for some guidance in log shipping internals or indepth working of log shipping. Tried hard but out of luck to find it on the INet or its undocumented.
   Regarding log shipping I'm aware of some facts like opening ports
     135 - required by SQL Agent to copy backup files to shared folders on the standby server.
     137/138/139 or 445 required to use UNC shares.
Some errors or bugs like (3154 / 170) faced when keeping all log backups in the saME directory (sql 8). This is all that I know about log shipping out of books. May you share some more...

TEMP DATA base prob



Hi team,


any body please clear the my doughts..

How can we restore Temp db and

what is the system database default recovery model

i hope default recovery model is full recovery right could you please correct me.







Logshipping possible between SQL 2000 and SQL server 2008 R2 ?

Logshipping possible between SQL 2000 and SQL server 2008 R2 ? We want to keep SQL Server 2000 in sync with 2008 R2. What are the other options available ?

one database logshipping, replication


Hi Team,

Is it possible to create Replication and logshipping only 'xxx' one database...


in Sql server 2005 or 2008


in replication use to database level security..

in logshipping server level but is it possible to create two disaster only one database.




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