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
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

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 !!! :)
Go to Top of Page
   

- Advertisement -