Thanks For your response.

I got the error when i am trying to restore the database, so i enabled it on secondary server and restore went fine.

Now i have am facing...

Sorry it is my mistake, not SSIS but it has DTS Packages.

I will take the System Database backup as well.

This Serevr has linked servers / Database maintenace plan /DTS packages,...

They just migrate this server from another data centre and now the serevr collation is diferent then database which causing some issue on coding side.

I will be doing below step...

Thanks RSScripter Works great..:)

Hi,

After that Exec Sp, i have only 10 Rows in system table. if now i am trying to even create SQL Job which is running SSIS Package it will let...

Yes i did after update on but still showing me only 10 rows.. 🙁

Does any one know what is this View name for SQL Server 2005??

Looks like something wrong with your backup jobs. did you ever try to restore those backup files??

I will suggest you to create new maintence plan for back, also if you...

I agreed with that other code is according to my machine.

We are not installing SQL On default path, we have created here D:\MSSQL for installtion.

I tried with delete thsoe entry...

I tried everything in all this you mention but didn't work any of this for me.

I didn't try below solution because i am still looking, what this fix actual does.

[font="Arial...

when i checked in all other server i found that Row in system database.

so i did insert that row manually but whenever i restart my SQL Agent it revert back...

Yes, Logical datafiles name will not change when you doing backup\restore for database.

Also it will not hurt anything if you have same logical name for more than one DB in...

I have same issue.

Where did you forced the restore option or which changes you made on primary server??

Thanks in advance.. 🙂

Yes, I did check the event log and error log, both has same error logged which i already mention.

I try to look for log files but not able to find. so i am thiking to remove the Logshipping and set-up again or is there any other way to...