Logshipping between standrad and enterprise SQL 2008

Hello and Thanks for looking into this .

We have a production enviornment which uses SQL 2008 64-bit Enterprise .
We are considering a DR site which has SQL 2008 64-bit standrad since enterprise edition is VERY expensive.

Would that be possible to have log shipping configured between the two ? any better Ideas(solutions) for DR site ?

LVL 10
akhalighiAsked:
Who is Participating?
 
HumpdyConnect With a Mentor Commented:
Hi,

Won't be a problem, but keep in mind that you won't be able to log ship if you're using functionality that's only available in Enterprise Edition. E.g If you're using SQL Partitioning, you won't be able to log ship to Standard Edition.

There are alternatives like mirroring and replication, but for a DR site, I'd recommend Log Shipping.
Try not to have to big of a gap between your shipping. The more frequent you have it, the less bandwidth that will be  taken up in the actual shipping.

Hope that helps
0
 
HumpdyCommented:
BTW, you should contact Microsoft.
There are some cases where you may not need the actual full license if all you're using SQL for is as a DR site. Just make sure your Live Site is properly licensed.
0
 
akhalighiAuthor Commented:
thanks ... just figured out that hosted database is 2005 enterprise , our version is 2008 standard ... would that be okay ?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
HumpdyCommented:
you can log ship from 2005 to 2008.
but you have to use WITH NORECOVERY instead of STANDBY
0
 
akhalighiAuthor Commented:
hmm .. what is teh difference ? still can use it as hot standby , right ?
0
 
HumpdyCommented:
if your primary server fails,
then way to get your log shipping database recovered is
RESTORE DATABASE dbname
WITH RECOVERY
0
 
HumpdyCommented:
by the way, in standby mode the database is read-only.
as this is a standby/recovery machine, I assume norecovery is ok for you as you won't be reporting from it.
0
 
akhalighiAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.