LOG SHIPPING - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

LOG SHIPPING

Author

Topic

Jai Krishna
Constraint Violating Yak Guru

333 Posts

Posted - 2010-04-29 : 09:11:41

Hi

When Performing LOG SHIPPING,as soon as when the backups are created on primary server getting the below error.Sometimes logshipping working successfully,sometimes the backup jobs are failing with the below error

Message
Unhandled Exception: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)

Jai Krishna

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-04-29 : 09:13:53

Is it possible you're trying to copy the file to the destination before the backup is finished?

------------------------------------------------------------------------------------
Any and all code contained within this post comes with a 100% money back guarantee.

Jai Krishna
Constraint Violating Yak Guru

333 Posts

Posted - 2010-04-29 : 09:18:24

No

First Backups will be created on primary server and after that those backups will be copied to secondary server

Jai Krishna

DBA in the making
Aged Yak Warrior

638 Posts

Posted - 2010-04-29 : 09:35:09

quote:
Originally posted by Jai Krishna

No

First Backups will be created on primary server and after that those backups will be copied to secondary server

Yes, that's the way it's supposed to happen. By my question it, are you sure the backup is completing before the copy, and the copy is completing before the restore.

------------------------------------------------------------------------------------
Any and all code contained within this post comes with a 100% money back guarantee.

Jai Krishna
Constraint Violating Yak Guru

333 Posts

Posted - 2010-04-29 : 09:46:00

yes

backup is completing before copy and copy is completing before restore

There is certain level of intervals between the jobs

Jai Krishna

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-04-29 : 09:55:08

Have you set all the correct permissions to the share on the Primary and Secondary servers?

Your Agent will need permissions on both..

Jai Krishna
Constraint Violating Yak Guru

333 Posts

Posted - 2010-04-29 : 09:58:22

Yes Everything is set fine

LOG SHIPPING is executing successfully sometimes.Backups,copying,restoring all working fine sometimes.But at some times when the backup jobs are running i am getting the above mentioned error on primary server.

Jai Krishna

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-29 : 12:31:46

You don't need intervals between the jobs actually as the maintenance plan is smart enough to only copy files that have completed backing up.

To me the error looks like a bug. What version are you running? SELECT @@VERSION

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Jai Krishna
Constraint Violating Yak Guru

333 Posts

Posted - 2010-04-30 : 04:15:30

My SQL Server Version is SQL SERVER 2008

i have moved the databases of SQL 2005 to SQL 2008 and implemented log shipping on SQL 2008

Jai Krishna

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-04-30 : 08:15:25

Is it in SQL 2008 compatibility mode or still in SQL 2005?

Jai Krishna
Constraint Violating Yak Guru

333 Posts

Posted - 2010-04-30 : 08:37:51

Hi

OS VERSION : Microsoft XP SP3
SQL SERVER VERSION : SQL SERVER 2008(Primary,Secondary)
Compatability level : SQL SERVER 2005(90)

Previously we used SQL SERVER 2005.Recently i moved all the databases from sql server 2005 to sql server 2008(primary server)
and i have set up another server SQL SERVER 2008(Secondary server).The errors i am getting on primary server only when the backups are taken.

Jai Krishna

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources