March 17, 2013 at 10:35 pm
Hi all
I have one doubt about log shipping
here we have two servers one is sql server 2000 and another one is sql server 2005.
here i want to configure the log shipping also i want to know whether is it possible
if possible i want to know the process for sql server 2000 log shipping
is this same like sql server 2005 or not?
Thanks in advance
March 18, 2013 at 8:01 am
the principal and process for log shipping was the same in SQL2000 but the set up gui was different. It was also only available in the enterprise edition.
If you have standard edition you would have to create your own process.
---------------------------------------------------------------------
March 18, 2013 at 9:02 am
ok i want the process method in gui
March 18, 2013 at 9:03 am
i am planning to configure primary in 2000 and secondary in 2005
how can i do this
March 18, 2013 at 9:14 am
gantavasu (3/18/2013)
ok i want the process method in gui
http://msdn.microsoft.com/en-us/library/aa496029(v=sql.80).aspx
---------------------------------------------------------------------
March 18, 2013 at 9:18 am
gantavasu (3/18/2013)
i am planning to configure primary in 2000 and secondary in 2005how can i do this
same process but what are you aiming to acheive here? If the secondary is intended to be your failover you know you won't be able to fail back as the database will be upgraded if you ever bring it on-line. You then will not be able to go back to SQL2000 as backups from 2005 to 2000 do not work.
Until you want to recover the 2005 database all logshipping restores will have to be restored in norecovery mode.
---------------------------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply