Database Mail SMTP Settings

Hi All,
The Sql server will send emails when I am connected to it on the LAN but not
when I am remote or connected via a VPN. I am using the fully qualified
hostname for the smtp server in the database mail configuration.
Here is the error message:
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
Message: Cannot send mails to mail server. (The operation has timed out.).
Thanks for your help.
JN
On Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
> Hi All,
> The Sql server will send emails when I am connected to it on the LAN but not
> when I am remote or connected via a VPN. I am using the fully qualified
> hostname for the smtp server in the database mail configuration.
> Here is the error message:
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
> Message: Cannot send mails to mail server. (The operation has timed out.).
> Thanks for your help.
> JN
Hi
Can you ping/telnet the mail server?
Has the server been set to exclude connections via VPNs?
John
|||It looks like the problem is caused by the firewall blocking port 25 on the
smtp server.
Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181581014.987361.279000@.q69g2000hsb.googlegr oups.com...
> On Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
> Hi
> Can you ping/telnet the mail server?
> Has the server been set to exclude connections via VPNs?
> John
>

Database Mail SMTP Settings

Hi All,
The Sql server will send emails when I am connected to it on the LAN but not
when I am remote or connected via a VPN. I am using the fully qualified
hostname for the smtp server in the database mail configuration.
Here is the error message:
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
Message: Cannot send mails to mail server. (The operation has timed out.).
Thanks for your help.
JNOn Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
> Hi All,
> The Sql server will send emails when I am connected to it on the LAN but not
> when I am remote or connected via a VPN. I am using the fully qualified
> hostname for the smtp server in the database mail configuration.
> Here is the error message:
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
> Message: Cannot send mails to mail server. (The operation has timed out.).
> Thanks for your help.
> JN
Hi
Can you ping/telnet the mail server?
Has the server been set to exclude connections via VPNs?
John|||It looks like the problem is caused by the firewall blocking port 25 on the
smtp server.
Thanks.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1181581014.987361.279000@.q69g2000hsb.googlegroups.com...
> On Jun 11, 4:11 pm, "JN" <j...@.ecconsulting.com> wrote:
>> Hi All,
>> The Sql server will send emails when I am connected to it on the LAN but
>> not
>> when I am remote or connected via a VPN. I am using the fully qualified
>> hostname for the smtp server in the database mail configuration.
>> Here is the error message:
>> The mail could not be sent to the recipients because of the mail server
>> failure. (Sending Mail using Account 3 (2007-06-08T16:36:07). Exception
>> Message: Cannot send mails to mail server. (The operation has timed
>> out.).
>> Thanks for your help.
>> JN
> Hi
> Can you ping/telnet the mail server?
> Has the server been set to exclude connections via VPNs?
> John
>

Database logical file name

Is it possible to change the logical name given to a database file?
The reason I want to do this is that we have several remote SQL Servers, and
some have the logical file names consistenly named the same, which is what
we want, but some do not. What's the best way to get all of the logical file
names the same, i.e. consistent on each and every remote SQL Server. N.B.
These database are in production but can be, and are taken offline for
updates (schema, SPs, reference data, etc.).
Thanks.
Michael MacGregor
Database ArchitectHi
On Jun 18, 3:44 pm, "Michael MacGregor" <nos...@.nospam.com> wrote:
> Is it possible to change the logical name given to a database file?
> The reason I want to do this is that we have several remote SQL Servers, a
nd
> some have the logical file names consistenly named the same, which is what
> we want, but some do not. What's the best way to get all of the logical fi
le
> names the same, i.e. consistent on each and every remote SQL Server. N.B.
> These database are in production but can be, and are taken offline for
> updates (schema, SPs, reference data, etc.).
> Thanks.
> Michael MacGregor
> Database Architect
You can with the ALTER DATABASE command e.g.
USE master
GO
CREATE DATABASE test1
GO
USE test1
GO
EXEC sp_helpfile
GO
ALTER DATABASE Test1
MODIFY FILE
(NAME = test1,
NEWNAME = 'DataFile')
GO
EXEC sp_helpfile
GO
John|||D'oh! Thanks for pointing that out to me. I think I need glasses. ;-)
MTM

Database logical file name

Is it possible to change the logical name given to a database file?
The reason I want to do this is that we have several remote SQL Servers, and
some have the logical file names consistenly named the same, which is what
we want, but some do not. What's the best way to get all of the logical file
names the same, i.e. consistent on each and every remote SQL Server. N.B.
These database are in production but can be, and are taken offline for
updates (schema, SPs, reference data, etc.).
Thanks.
Michael MacGregor
Database ArchitectHi
On Jun 18, 3:44 pm, "Michael MacGregor" <nos...@.nospam.com> wrote:
> Is it possible to change the logical name given to a database file?
> The reason I want to do this is that we have several remote SQL Servers, and
> some have the logical file names consistenly named the same, which is what
> we want, but some do not. What's the best way to get all of the logical file
> names the same, i.e. consistent on each and every remote SQL Server. N.B.
> These database are in production but can be, and are taken offline for
> updates (schema, SPs, reference data, etc.).
> Thanks.
> Michael MacGregor
> Database Architect
You can with the ALTER DATABASE command e.g.
USE master
GO
CREATE DATABASE test1
GO
USE test1
GO
EXEC sp_helpfile
GO
ALTER DATABASE Test1
MODIFY FILE
(NAME = test1,
NEWNAME = 'DataFile')
GO
EXEC sp_helpfile
GO
John|||D'oh! Thanks for pointing that out to me. I think I need glasses. ;-)
MTM

Database log size

hi

my database on remote server i cannot access directly.

i can access it only with query analyzer.

my log file size is 9mb but nothing in database. only few tables there so how i can reduce log file size with query.

thanks

Hi,

I used to do this using the sa privileges.

Google it for (Truncating SQL Log)

Let me know if you need further help.

Regards

|||

Change the recovery model to simple. Set autoshrink to true, back up the database and it should reduce in size.

|||

I don't want you to waste your time, here is the query,

BACKUP LOG databasename WITH TRUNCATE_ONLY
DBCC SHRINKFILE ('databaselog_log', 100) WITH NO_INFOMSGS

It will shrink the log to 100 MB

|||

thanks dear

my problem solved with following

BACKUP LOG databasename WITH TRUNCATE_ONLY
DBCC SHRINKFILE ('databaselog_log', 2) WITH NO_INFOMSGS

DBCC SHRINKFILE(mydatabase)