December 15, 2011 at 10:29 pm
Hello,
I am new to log shipping. i have 2 sql instances in my computer and tried log shipping but the restore job fails every time with following message. i restored the DB in no recovery state and restore LS using Standby mode with disconnected user"
am i missing anything. kindly help
"12/16/2011 10:20:00,LSRestore_SUVITHA_AdventureWorks,Error,1,SUVITHA\INST1,LSRestore_SUVITHA_AdventureWorks,Log shipping restore log job step.,,Executed as user: SUVITHA\SYSTEM. The step failed.,00:00:03,0,0,,,,0
12/16/2011 10:20:00,LSRestore_SUVITHA_AdventureWorks,Unknown,1,SUVITHA\INST1,LSRestore_SUVITHA_AdventureWorks,Log shipping restore log job step.,,2011-12-16 10:20:03.59*** Error: The restore operation cannot proceed because the secondary database 'AdventureWorks' is not in NORECOVERY/STANDBY mode.(Microsoft.SqlServer.Management.LogShipping) ***<nl/>2011-12-16 10:20:03.62Deleting old log backup files. Primary Database: 'AdventureWorks'<nl/>2011-12-16 10:20:03.62The restore operation completed with errors. Secondary ID: '3fb8605f-6027-496a-822c-ddbf932a57a5'<nl/>2011-12-16 10:20:03.62----- END OF TRANSACTION LOG RESTORE -----<nl/><nl/>Exit Status: 1 (Error),00:00:03,0,0,,,,0"
Regards
Durai Nagarajan
December 15, 2011 at 11:24 pm
Are you sure the secondary db is in norecovery mode? the error information indicates that it is not in norecovery mode. Can you take a screenshot of the database in object explorer and attach it..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 15, 2011 at 11:25 pm
The errors are pretty clear. The restored database is not in recoverymode/standby mode.
Can you confirm the following
1) Your primary db (Source db) is in the full recovery mode.
2) Your restored database on the target in the recoverymode/standby mode.
Babu
December 15, 2011 at 11:37 pm
baabhu (12/15/2011)
The errors are pretty clear. The restored database is not in recoverymode/standby mode.Can you confirm the following
1) Your primary db (Source db) is in the full recovery mode.
How will log backups be possible if the primary db is not in full/bulk-logged recovery mode?
His restore jobs are failing, not the log backup jobs..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 16, 2011 at 2:40 am
My Bad. Yes the transaction log backup is happening. Thanks Bru.
Sorry about that.
December 16, 2011 at 3:45 am
Bru,
object explorer? is it there on SQL 2005, if it is, how will i find it.
or are you talking about Database properties -> options or other.
Regards
Durai Nagarajan
December 16, 2011 at 5:19 am
durai nagarajan (12/16/2011)
Bru,object explorer? is it there on SQL 2005, if it is, how will i find it.
Object explorer is the pane in left hand side of the SQL Server Management Studio, where you see the list of databases. take a screenshot of that showing the databases on your secondary server.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 18, 2011 at 7:52 pm
Bru,
thanks and screenshot attached.
Regards
Durai Nagarajan
December 18, 2011 at 8:04 pm
Looking at the attachment your database adventureworks on the secondary server is not under no recovery mode. Let us know how did you get the adventurework database on the secondary server. Please share the t-sql if you have any or the steps you followed.
December 18, 2011 at 8:20 pm
durai nagarajan (12/18/2011)
Bru,thanks and screenshot attached.
Hi,
As I guessed the secondary database is not in norecovery mode. There must have been a recovery done by mistake in your previous steps. I would suggest you restart the entire process of setting up the secondary database..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 18, 2011 at 9:10 pm
Bru,
Can i know how you have identified it.
i'll certainly do the process again.
Regards
Durai Nagarajan
December 18, 2011 at 9:37 pm
Bru,
It is working and i have found out how the database is in NoRecovery mode.
Thanks for your help.
Regards
Durai Nagarajan
December 19, 2011 at 9:46 am
durai nagarajan (12/18/2011)
Bru,It is working and i have found out how the database is in NoRecovery mode.
Thanks for your help.
You are welcome...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 19, 2011 at 10:09 am
Hello,
Is there any other way (other than logfile name in restore job) to confirm the restoration.
Regards
Durai Nagarajan
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply