log shipping

Question

Post reply

log shipping

PearlJammer1

SSCrazy Eights

Points: 8485
More actions
September 22, 2017 at 4:26 am

#328684

Hi
We are moving our databases to a new server. The old server, which is still live has sql 2012 STANDARD edition. We are setting up log shipping to our new SQL2102 ENTERPRISE edition so we can minimise downtime by having to t only restore the last transaction log when we decide to switch over.
Anyways, I am getting an error when i try and do the initial log shipping setup : "A file activation error occurred. The physical file name D:DATA\databanseName_dat.mdf" may be incorrect. Diagnose and correct additional errors and retry operation"
The SQL SERVICE has full permissions on the data folder, as does the SQL Agent (not sure that is actually needed but i added it anyway)
Is this because we are log shipping from standard to Enterprise ? Both editions are 2012

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

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

Ant-Green SSC Guru Points: 113520 More actions · Answer 1

What other errors, do you have or what else is logged in the error log at the same time?

Do you have filestream enabled on the database?

adilahmed1989 Right there with Babe Points: 739 More actions · Answer 2

PearlJammer1 - Friday, September 22, 2017 4:26 AM
Hi
We are moving our databases to a new server. The old server, which is still live has sql 2012 STANDARD edition. We are setting up log shipping to our new SQL2102 ENTERPRISE edition so we can minimise downtime by having to t only restore the last transaction log when we decide to switch over.
Anyways, I am getting an error when i try and do the initial log shipping setup : "A file activation error occurred. The physical file name D:DATA\databanseName_dat.mdf" may be incorrect. Diagnose and correct additional errors and retry operation"
The SQL SERVICE has full permissions on the data folder, as does the SQL Agent (not sure that is actually needed but i added it anyway)
Is this because we are log shipping from standard to Enterprise ? Both editions are 2012

Yes; Successful log shipment process is possible when both the versions are same (i.e. Standard to Standard)

PearlJammer1 SSCrazy Eights Points: 8485 More actions · Answer 3

anthony.green - Friday, September 22, 2017 5:09 AM
What other errors, do you have or what else is logged in the error log at the same time?
Do you have filestream enabled on the database?

Hi, Thanks for your reply.
There are no other errors in the error log except the one I quoted. There is one error referencing the.mdf file and another error of the same nature referencing the .ldf file.
FileStream is not enabled.

PearlJammer1 SSCrazy Eights Points: 8485 More actions · Answer 4

adilahmed1989 - Friday, September 22, 2017 5:16 AM
PearlJammer1 - Friday, September 22, 2017 4:26 AM
Hi
We are moving our databases to a new server. The old server, which is still live has sql 2012 STANDARD edition. We are setting up log shipping to our new SQL2102 ENTERPRISE edition so we can minimise downtime by having to t only restore the last transaction log when we decide to switch over.
Anyways, I am getting an error when i try and do the initial log shipping setup : "A file activation error occurred. The physical file name D:DATA\databanseName_dat.mdf" may be incorrect. Diagnose and correct additional errors and retry operation"
The SQL SERVICE has full permissions on the data folder, as does the SQL Agent (not sure that is actually needed but i added it anyway)
Is this because we are log shipping from standard to Enterprise ? Both editions are 2012
Yes; Successful log shipment process is possible when both the versions are same (i.e. Standard to Standard)

Hi
I know log shipping works from the same version/edition i.e. sql2012 standard to sql2012 standard. My question is will it work from sql2012 standard to sql2012 Enterprise ?

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

PearlJammer1 - Friday, September 22, 2017 5:43 AM
My question is will it work from sql2012 standard to sql2012 Enterprise ?

Yes

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

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

Your error message got mangled with a smilie. Can you either paste the whole thing again, or post a screenshot? Preferably both.

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

PearlJammer1 SSCrazy Eights Points: 8485 More actions · Answer 7

GilaMonster - Friday, September 22, 2017 6:00 AM
Your error message got mangled with a smilie. Can you either paste the whole thing again, or post a screenshot? Preferably both.

Hi Gail
Here is the error again - pretty much the same as i posted minus the smiley..

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

D:Logs is not a valid path. It should be D:\Logs. Check your setup and paths.

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

PearlJammer1 SSCrazy Eights Points: 8485 More actions · Answer 9

GilaMonster - Friday, September 22, 2017 6:56 AM
D:Logs is not a valid path. It should be D:\Logs. Check your setup and paths.

OMG!!!
School boy error. This has fixed it Gail. Thank you. I'm afraid I got so wrapped up in permissions to the SQLSVC and SQL AGENT and versions I have totally failed to check that!!

It is now working like a charm - thank you!!

log shipping

Cookies on SQLServerCentral