naren.ece2012 (8/11/2016)

---

Thank you for the reply. It is showing many scripts , but it is showing errors. Since i am new to powershell, i can't resolve it.

If you have any...

Hey Evan -

I think we covered most of the known fixes on this - you tried the manually populating the table, tried the MS way of deleting the contents of...

The user needs access to at least one mail profile and needs to be a member of DatabaseMailUserRole in msdb.

Sue

If you google: sql server health check script with powershell

That will give you quite a few examples of different Posh scripts to get you started.

Sue

No worries. The problem in troubleshooting this with no errors is that it's a nested process - the executable on the server, those are called by the assemblies, those are...

Steve has some great advice on that. Differentials are often used to manage the size issues and can provide quicker restores than restoring a lot of logs. I've used them...

I wouldn't as the time you save with one last log backup and restore you would spend making sure you have reset the database recovery model back to full after...

Probably but you would need to last log backup to ensure this.

You can restore the full backup onto the new server anytime after it completes. Restore with no recovery....

Don't just check for the specific user name but check also for rows where the user_name(sid) is null as that can be part of the problem.

Sue

Don't just check for the specific user name but also check using

WHERE USER_NAME(sid) IS NULL

I've seen several people hit this same issue and the user is null on the internal...

No one can really say at this point without knowing if data loss is allowed and what the recovery model is for the database.

In general though, you want to...

Okay so now, on the failing instance, does the following file exist:

SQLDTSSS.DLL

Looks like it should be in C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\binn

If it does, I would still check the permissions on...

The error indicates the user has granted permissions to catalog objects. Have you checked for those permissions?

select * ...

Yup...there is a lot that could be going on. Debugging a package generally requires a log as unknown errors or issues are hard to find. So you'd want package logging...

I think part of the problem with these kind of designs is that you can have cases where the logical model is fairly simple on paper but then it gets...