Question about log shipping from SQL 2005 to SQL 2008

Question

Post reply

Question about log shipping from SQL 2005 to SQL 2008

bsdtux

Mr or Mrs. 500

Points: 522
More actions
January 19, 2012 at 10:26 am

#251573

I have setup log shipping to go from our SQL Server 2005 server to our SQL Server 2008 R2 server. However when I view the secondary server It says wfe(Restoring). Is this normal? I am thinking it is because I set it up with no recovery. I am sure this is a basic question but I just want to be sure as this is the first time that I have setup log shipping.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

george sibbald SSC Guru Points: 104210 More actions · Answer 1

thats as expected

---------------------------------------------------------------------

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

That is normal.

Also, will you be upgrading the primary database?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Just note that your log shipping is one way. If you ever have to fail over and make the 2008 server the primary, you won't be able to take log backups (or database backups) and restore to 2005.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

bsdtux Mr or Mrs. 500 Points: 522 More actions · Answer 4

Yeah I kind of figured that. Unfortunately I only have licesening for SQL Server 2008. All my SQL 2005 Licenses are used.

As for upgrading the database: is that why I can't put it into standby mode? I think the error I get is that it needs to be upgraded.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Yeah - standby mode will not work when logshipping from 2005 to 2008.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

bsdtux Mr or Mrs. 500 Points: 522 More actions · Answer 6

Good to know thanks guys for the insightfull information. Looks like I do have some planning to do. Since I am still working on only one database server so far, Would you suggest that I just undo the log shipping and get another copy of SQL Server 2005 and use that for all my SQL 2005 and 2000 Servers?

I am also seeing reports that I don't have to have a license for a secondary server if it is secondary standby. How true is that statement?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

bsdtux (1/19/2012)
Good to know thanks guys for the insightfull information. Looks like I do have some planning to do. Since I am still working on only one database server so far, Would you suggest that I just undo the log shipping and get another copy of SQL Server 2005 and use that for all my SQL 2005 and 2000 Servers?

Well, what's the purpose of the log shipping? What's its intended use

I am also seeing reports that I don't have to have a license for a secondary server if it is secondary standby. How true is that statement?

True, providing nothing is using that SQL Server, no other database, no reporting off of the secondary, no usage (other than DBA monitoring) at all.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

bsdtux Mr or Mrs. 500 Points: 522 More actions · Answer 8

The purpose of using Log Shipping is for DRS. I have recently took over the DBA position at my company and found that all SQL Servers have no redundancy.

All the secondary server Databases will only be warm standby's they won't be used for reporting.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

In that case I would very strongly advise against using mis-matched versions. In a disaster you could fail over and find your apps don't work on the newer version, and once you've failed over you can never fail back to the 2005 server (without manually syncing data)

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

bsdtux Mr or Mrs. 500 Points: 522 More actions · Answer 10

Thanks Gail. I have taken your advice. I am setting up two virtual servers one for my SQL 2005 Servers and the Other will be for my SQL 2008 Servers.

I will probably be using Database mirroring for my SQL 2008 Servers.

Again thanks for all the information and leading me down the correct path everyonoe.