October 8, 2009 at 6:30 am
Good morning,
We have our production enviroment on a SQL Server 2005 Standard and we need a copy made for the Web with the least amount of traffic transfered over the VPN. I tried to create a Log Shipping from the 2008 Managment Tool and I am able to get a Positive out come from the job but when i check the database it tells me "Restoring" beside the database name and doens't go away.
Any ideas how to make it work?
Thanks,
Karl
October 8, 2009 at 7:16 am
As far as I understand, you can use log shipping between a 2005 and 2008 database. However, the WITH STANDBY option is not available in this situation as the database needs to be upgraded before it's readable, which only happens on recovery. You can only log ship with NORECOVERY which is why you see restoring as the database status.
In your situation, if you need to read from the 2008 database you'll need to use some form of replication if you need to keep the bandwidth down, or upgrade the 2005 server to 2008.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply