Hi,

Thanks for the reply.

I have checked the above steps as you mentioned.

I am able to send message through SMTP commands but not through SQL mail. So I think no problems...

Hi,

From the server I have given the telnet command and found the below message.

220 ***************

Please let me know is it correct?

Hi,

Thanks for the reply.

Would you please let me know how and what needs to be checked in the SMTP setting?

Hi,

I have enabled database mail in SAC tool and SMTP server is put as you described. Using the same SMTP server, I am able to send mail from other server....

Hi,

Thanks for the suggestion.

Actually I got the solution. This was due some of the files missing in .net 3.5. After installing .net and rebooting, the problem got solved.

Hi,

I faced similar kind of problem.

It was because of Some files were missing from .NET 3.5. After installing .net and rebooting, the problem got resolved.

Thank you.

Hi all,

Thanks to all of you...

While taking differential backup, do we need to append it every time or we can overwrite everytime?

Hi,

I am taking full backup everyday 23:00 and overwriting it with the existing one. Transaction log every one hour and appending it every hour to get to get all the...

Hi,

What does differential backup capture? I mean does it take the changes from last full backup/last differential backup. So for taking differential backup is it necessary to append each time...

Hi again,

For full backup is it necessary to take backup of all the system database along with the user database?

Thanks...

Is the same things happen for the differential backup? Like from the last full backup/ differential backup?

Can you please tell me the standard plan(taking full,differential, transaction log) for taking backup...

Thanks for the reply....

So how does the tranction log back up keep record? Is it the transactions from the last backup?

This is testing purpose in testing region. But actually it wiil be one full back up per day, differential back every 4 hour and transaction log every 1 hour. Actual...

Thanks for the information....

In one instance we can have many user database which can be used by different application. Then why do we need different instances.