Saturday, February 25, 2012

RESTORE 64-bit database via 32-bit GUI...

Hello all,
I'm trying to use the 32-bit GUI, on a remote server, to restore a database
on one of our 64-bit servers. The GUI returns a prompt that the restore was
successful but the GUI indicates that the database is in a Loading mode. I
tried to issue a recovery command but it fails saying that some of the files
were partially restored.
I figured that there is a problem using the 32-bit client utility so I used
OSQL, via SQL Server Agent, on the 64-bit to ensure that I was using a
compatible 64-bit utility. By doing so, I was able to restore the database
successfully.
So my question is, is not being able to restore a 64-bit database via a
32-bit GUI, on a remote server, a known issue?
Thanks...Hi
On the 32 bit client, have you installed a minimum of sp3a?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"BATMAN" <BATMAN@.discussions.microsoft.com> wrote in message
news:8C8842C1-37B4-4AFB-BCB4-A63FD58DC323@.microsoft.com...
> Hello all,
> I'm trying to use the 32-bit GUI, on a remote server, to restore a
> database
> on one of our 64-bit servers. The GUI returns a prompt that the restore
> was
> successful but the GUI indicates that the database is in a Loading mode.
> I
> tried to issue a recovery command but it fails saying that some of the
> files
> were partially restored.
> I figured that there is a problem using the 32-bit client utility so I
> used
> OSQL, via SQL Server Agent, on the 64-bit to ensure that I was using a
> compatible 64-bit utility. By doing so, I was able to restore the
> database
> successfully.
> So my question is, is not being able to restore a 64-bit database via a
> 32-bit GUI, on a remote server, a known issue?
> Thanks...
>|||Yeah, it's 8.00.760 (SP3)...
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> On the 32 bit client, have you installed a minimum of sp3a?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "BATMAN" <BATMAN@.discussions.microsoft.com> wrote in message
> news:8C8842C1-37B4-4AFB-BCB4-A63FD58DC323@.microsoft.com...
> > Hello all,
> >
> > I'm trying to use the 32-bit GUI, on a remote server, to restore a
> > database
> > on one of our 64-bit servers. The GUI returns a prompt that the restore
> > was
> > successful but the GUI indicates that the database is in a Loading mode.
> > I
> > tried to issue a recovery command but it fails saying that some of the
> > files
> > were partially restored.
> >
> > I figured that there is a problem using the 32-bit client utility so I
> > used
> > OSQL, via SQL Server Agent, on the 64-bit to ensure that I was using a
> > compatible 64-bit utility. By doing so, I was able to restore the
> > database
> > successfully.
> >
> > So my question is, is not being able to restore a 64-bit database via a
> > 32-bit GUI, on a remote server, a known issue?
> >
> > Thanks...
> >
>
>

No comments:

Post a Comment