January 25, 2011 at 1:00 am
Hi All,
I want to test log shipping on my test machine.
can you please assist me with the following questions.
1) is it posible for me to have one instance on SQL server 2008 and other one on SQL server 2005 ?
2) considering both instances on sql server 2008...
Is it possible for me to have other datbases too ??
I mean if i am going for 1 db for log shiping, do i use other databases
for normal operation ?? is there any problem to use other databases...
thanks
January 25, 2011 at 1:15 am
fawwad (1/25/2011)
1) is it posible for me to have one instance on SQL server 2008 and other one on SQL server 2005 ?
2) considering both instances on sql server 2008...
Is it possible for me to have other datbases too ??
I mean if i am going for 1 db for log shiping, do i use other databases
for normal operation ?? is there any problem to use other databases...
1. All of our developers here have both 2005 and 2008 installed, as well as several of our test servers. It isn't a problem.
2. I'm not sure I understand this question correctly. The database that you are log shipping from is fully useable, and it does not affect any other databases on that server. If I recall corrrectly the database that you are log shipping to will be in Recovery mode.
BrainDonor.
January 25, 2011 at 1:22 am
It should be in Recovery mode.
Satnam
January 25, 2011 at 1:26 am
The log shipping destination will be RESTORING (or STANDBY), not RECOVERING.
The primary can be SQL 2005 and the secondary SQL 2008, but not the other way around. They should be the same version
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2011 at 1:30 am
1) is it posible for me to have one instance on SQL server 2008 and other one on SQL server 2005 ?
yes it will work if primary on 2005 and secondary on 2008. Also make sure the database are getting restored with norecovery and not with standby(as it will not work)
2) considering both instances on sql server 2008...
Is it possible for me to have other datbases too ??
I mean if i am going for 1 db for log shiping, do i use other databases
for normal operation ?? is there any problem to use other databases...
yes you can configure as many user database as u can. But need to configure for every database individually.
Also if both instance have same platform then to use secondary database as read only, you have to restore the database with standby.
PS :- Please ignore if I answered late or you already found the answer.
----------
Ashish
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply