My fault, I was adding some IDs which were already present 🙂

Thanks for all your help Gail.

Now again another issue that we are facing further is on data insertion.

As mentioned above that I have another database in which there is some data migrated. I tried to...

😉

Yes, I restored a single page. However, the problem that I am facing is to take the log backup and even restoring ;

The database is stuck in RESTORING mode.

Now...

Hi,

Thanks for your response. However, currently my db is in restoring state.

I found this link:

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/01/18/fixing-damaged-pages-using-page-restore-or-manual-inserts.aspx

and attempted a restore from my 10 days ago backup file.

Processed 0 pages...

Is there any specific reason you are using xp_smtp_sendmail? If you are using 2005 or 2008 server then you can use msdb.dbo.sp_send_dbmail. This procedure automatically logs your mails. It becomes...

Thanks for that. Ya, msdb sysmail tables are on the options, but my main target is to get identified first if mails on some db is down. I think I...