Problem upgrading from Standard to Enterprise

I'm hoping someone can explain why the following is happening and how
I can resolve the issue. My company uses SQL Standard for it's prod
server. We decided to setup another server to utilize log shipping.
The server that was installed with Enterprise from scratch worked
perfect. The server that we upgraded from standard appears to work
fine as a server and I can now see the server as a destination server
for log shipping. (hence it does recognize it as Enterprise edition)
The problem is that the upgraded server does not contain any of the
log shipping tables or stored procedures required for log shipping.
Why is this? What is my solution to resolve this? The database is
our production server and is very large so I don't even want to think
about scratching the drive, reinstalling sql, and restoring the
database. Any clues?
Thanks,
willDid you run the log shipping wizard against it? The tables are not there by
default.
--
Andrew J. Kelly SQL MVP
"Will Wirtz" <WillCWirtz@.Yahoo.com> wrote in message
news:223f5e88.0407202028.448f131e@.posting.google.com...
> I'm hoping someone can explain why the following is happening and how
> I can resolve the issue. My company uses SQL Standard for it's prod
> server. We decided to setup another server to utilize log shipping.
> The server that was installed with Enterprise from scratch worked
> perfect. The server that we upgraded from standard appears to work
> fine as a server and I can now see the server as a destination server
> for log shipping. (hence it does recognize it as Enterprise edition)
> The problem is that the upgraded server does not contain any of the
> log shipping tables or stored procedures required for log shipping.
> Why is this? What is my solution to resolve this? The database is
> our production server and is very large so I don't even want to think
> about scratching the drive, reinstalling sql, and restoring the
> database. Any clues?
> Thanks,
> will