"TRN' failed to open. Operating system error = 32

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 2000 Forums

SQL Server Administration (2000)

"TRN' failed to open. Operating system error = 32

Author

Topic

JaybeeSQL
Posting Yak Master

112 Posts

Posted - 2013-06-11 : 06:42:19

This is an error we're getting on log shipping, btw.

Anyone solved this error, how did you do it?

Cheers,

JB

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-06-14 : 14:32:07

Did you try manually restoring that file to the secondary server? Please post the full error message.

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

Subscribe to my blog

JaybeeSQL
Posting Yak Master

112 Posts

Posted - 2013-06-19 : 03:59:54

quote:
Originally posted by tkizer

Did you try manually restoring that file to the secondary server? Please post the full error message.

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

Subscribe to my blog

Interesting thought but typically the file restores upon retry a few seconds afterwards. However, I believe this error is somehow some way responsible for secondary db's going suspect, which happens every few months or so.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-06-19 : 21:01:14

If the file restores via the job later, then this issue is likely that the device isn't available at the time of the error.

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

Subscribe to my blog

JaybeeSQL
Posting Yak Master

112 Posts

Posted - 2013-09-30 : 11:07:32

Hi Tara, just wanted to give you a much belated thanks for that help !!! :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources