One possibility is a situation as in the below link-

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117064

Please go through the last post in this link and check if that's what is happening.

-

Depending on whether you have changed the name of the server instance you will have to drop and add a new one.

Remarks section here should be helpful to you.

Thanks but I already got it fixed using UI.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117064

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117064

I want to change two settings for the Log Shipping Configuration --

1. Delete Files Older Than setting for the LS_Backup Job

2. Delete Copied FIles Older Than setting for the LS_Copied...

The two instances are on the same physical machine , that is my laptop. I am trying the Log Shipping across two named Instances installed on my machine. Can the...

---As an addition to the above post--- 🙂

After my first attempt to start the Copy Job on the secondary server the SQL Server Agent (on the secondary server) itself...

Exactly.

Can you please tell me the queries that I should use to verify that the Transaction Log of the recent changes has been applied to the Secondary Server.

That is...

I am trying to setup log shipping on primary server.

Actually the backup job was created on a second atempt and it started taking transaction log backups (.trn files) after I...

🙂

Thank You.

Thanks for fast replies. I'll run sp_who(2) before attempting deletion.

My doubt is -

Is taking the database offline and then deleting it an option at all? (rather than bringing it...

Hello Sir,

Yes, that works Precisely .

Thanks a lot 🙂

What to join these tables on? How to find the User-Login Mapping from these tables?

TIA

Hi,

How to check which service account has which which permissions on a folder. And how to grant permission in case we want to.

My Default instance is running under the LocalSystem...

My Understanding is that StandBy is useful only if a read-only access is required to the Database while Log Shipping process is on.

And NoRecovery does the restore in one shot...