How do you configure the logs in SQL Server? Currently, all I see is my
backup processes. I'm trying to investigate a deadlock and I need much
more detail in the logging. I know I've done it before, but I can't
seem to find it now.
Rick
Check out DBCC TRACEON in the BOL
"Rick Harrison" <rick@.knowware.com> wrote in message
news:40867FEE.3050505@.knowware.com...
> How do you configure the logs in SQL Server? Currently, all I see is my
> backup processes. I'm trying to investigate a deadlock and I need much
> more detail in the logging. I know I've done it before, but I can't
> seem to find it now.
>
|||Hi,
To add on to previous post,
you can also you SQL profiler-- In the event class use the event Deadlock.
Otherwise like Uri pointed out use
DBCC TRACEON(1204)
This will send the deadlock information to SQL server error log.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e1CYZq6JEHA.2576@.TK2MSFTNGP12.phx.gbl...
> Rick
> Check out DBCC TRACEON in the BOL
> "Rick Harrison" <rick@.knowware.com> wrote in message
> news:40867FEE.3050505@.knowware.com...
>
|||Thank you both very much. That is helpful. Isn't there also another
user interface for turning on trace flags? I was sure I had seen
something in Enterprise Manager that allowed one to select and deselect
specific types of logs.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi,
Yes, You can do that in Enterprise manager as well.
How to do that:-
1. IN Enterprise Manager
2. Right above the server and select properties
3. Select the General Tab options
4. Click the "startup parameters"
5. Type the trace flag (eg: -T3608)
6. Click Add and press OK.
Thanks
Hari
MCDBA
"Rick Harrison" <rick@.knowware.com> wrote in message
news:eDHQhi7JEHA.2376@.tk2msftngp13.phx.gbl...
> Thank you both very much. That is helpful. Isn't there also another
> user interface for turning on trace flags? I was sure I had seen
> something in Enterprise Manager that allowed one to select and deselect
> specific types of logs.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hari,
Yeah, that was probably what I was thinking of. I guess it's
easier to just enter the commands. Too bad they didn't implement a
checkbox or listbox interface for this.
Rick.
|||Now I see the value of this method!
We just had another deadlock occur today. I went to check the logs
and there was nothing there even though I had "set this flag" a couple
of days before with "DBCC TRACEON (1204)". Obviously, this only sets
the flag for that one session (duuhhh). I thought I was setting a
permanent, global flag.
If I turn on the deadlock tracing as one of the startup parameters
(-T1204), the flag will be on for all sessions, which is what I need.
In other words, setting the flag in Enterprise Manager is the way to
do it if you want the flag to be on all the time for all sessions. Of
course I'll have to restart SQL server for this to take effect. There
does not appear to be any way to set the flag globally in SQL server
without restarting it.
Rick.
sql
Showing posts with label logs. Show all posts
Showing posts with label logs. Show all posts
Wednesday, March 21, 2012
How to configure the logs
How do you configure the logs in SQL Server? Currently, all I see is my
backup processes. I'm trying to investigate a deadlock and I need much
more detail in the logging. I know I've done it before, but I can't
seem to find it now.Rick
Check out DBCC TRACEON in the BOL
"Rick Harrison" <rick@.knowware.com> wrote in message
news:40867FEE.3050505@.knowware.com...
> How do you configure the logs in SQL Server? Currently, all I see is my
> backup processes. I'm trying to investigate a deadlock and I need much
> more detail in the logging. I know I've done it before, but I can't
> seem to find it now.
>|||Hi,
To add on to previous post,
you can also you SQL profiler-- In the event class use the event Deadlock.
Otherwise like Uri pointed out use
DBCC TRACEON(1204)
This will send the deadlock information to SQL server error log.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e1CYZq6JEHA.2576@.TK2MSFTNGP12.phx.gbl...
> Rick
> Check out DBCC TRACEON in the BOL
> "Rick Harrison" <rick@.knowware.com> wrote in message
> news:40867FEE.3050505@.knowware.com...
>|||Thank you both very much. That is helpful. Isn't there also another
user interface for turning on trace flags? I was sure I had seen
something in Enterprise Manager that allowed one to select and deselect
specific types of logs.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Hi,
Yes, You can do that in Enterprise manager as well.
How to do that:-
1. IN Enterprise Manager
2. Right above the server and select properties
3. Select the General Tab options
4. Click the "startup parameters"
5. Type the trace flag (eg: -T3608)
6. Click Add and press OK.
Thanks
Hari
MCDBA
"Rick Harrison" <rick@.knowware.com> wrote in message
news:eDHQhi7JEHA.2376@.tk2msftngp13.phx.gbl...
> Thank you both very much. That is helpful. Isn't there also another
> user interface for turning on trace flags? I was sure I had seen
> something in Enterprise Manager that allowed one to select and deselect
> specific types of logs.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Hari,
Yeah, that was probably what I was thinking of. I guess it's
easier to just enter the commands. Too bad they didn't implement a
checkbox or listbox interface for this.
Rick.|||Now I see the value of this method!
We just had another deadlock occur today. I went to check the logs
and there was nothing there even though I had "set this flag" a couple
of days before with "DBCC TRACEON (1204)". Obviously, this only sets
the flag for that one session (duuhhh). I thought I was setting a
permanent, global flag.
If I turn on the deadlock tracing as one of the startup parameters
(-T1204), the flag will be on for all sessions, which is what I need.
In other words, setting the flag in Enterprise Manager is the way to
do it if you want the flag to be on all the time for all sessions. Of
course I'll have to restart SQL server for this to take effect. There
does not appear to be any way to set the flag globally in SQL server
without restarting it.
Rick.
backup processes. I'm trying to investigate a deadlock and I need much
more detail in the logging. I know I've done it before, but I can't
seem to find it now.Rick
Check out DBCC TRACEON in the BOL
"Rick Harrison" <rick@.knowware.com> wrote in message
news:40867FEE.3050505@.knowware.com...
> How do you configure the logs in SQL Server? Currently, all I see is my
> backup processes. I'm trying to investigate a deadlock and I need much
> more detail in the logging. I know I've done it before, but I can't
> seem to find it now.
>|||Hi,
To add on to previous post,
you can also you SQL profiler-- In the event class use the event Deadlock.
Otherwise like Uri pointed out use
DBCC TRACEON(1204)
This will send the deadlock information to SQL server error log.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e1CYZq6JEHA.2576@.TK2MSFTNGP12.phx.gbl...
> Rick
> Check out DBCC TRACEON in the BOL
> "Rick Harrison" <rick@.knowware.com> wrote in message
> news:40867FEE.3050505@.knowware.com...
>|||Thank you both very much. That is helpful. Isn't there also another
user interface for turning on trace flags? I was sure I had seen
something in Enterprise Manager that allowed one to select and deselect
specific types of logs.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Hi,
Yes, You can do that in Enterprise manager as well.
How to do that:-
1. IN Enterprise Manager
2. Right above the server and select properties
3. Select the General Tab options
4. Click the "startup parameters"
5. Type the trace flag (eg: -T3608)
6. Click Add and press OK.
Thanks
Hari
MCDBA
"Rick Harrison" <rick@.knowware.com> wrote in message
news:eDHQhi7JEHA.2376@.tk2msftngp13.phx.gbl...
> Thank you both very much. That is helpful. Isn't there also another
> user interface for turning on trace flags? I was sure I had seen
> something in Enterprise Manager that allowed one to select and deselect
> specific types of logs.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Hari,
Yeah, that was probably what I was thinking of. I guess it's
easier to just enter the commands. Too bad they didn't implement a
checkbox or listbox interface for this.
Rick.|||Now I see the value of this method!
We just had another deadlock occur today. I went to check the logs
and there was nothing there even though I had "set this flag" a couple
of days before with "DBCC TRACEON (1204)". Obviously, this only sets
the flag for that one session (duuhhh). I thought I was setting a
permanent, global flag.
If I turn on the deadlock tracing as one of the startup parameters
(-T1204), the flag will be on for all sessions, which is what I need.
In other words, setting the flag in Enterprise Manager is the way to
do it if you want the flag to be on all the time for all sessions. Of
course I'll have to restart SQL server for this to take effect. There
does not appear to be any way to set the flag globally in SQL server
without restarting it.
Rick.
How to configure the logs
How do you configure the logs in SQL Server? Currently, all I see is my
backup processes. I'm trying to investigate a deadlock and I need much
more detail in the logging. I know I've done it before, but I can't
seem to find it now.Rick
Check out DBCC TRACEON in the BOL
"Rick Harrison" <rick@.knowware.com> wrote in message
news:40867FEE.3050505@.knowware.com...
> How do you configure the logs in SQL Server? Currently, all I see is my
> backup processes. I'm trying to investigate a deadlock and I need much
> more detail in the logging. I know I've done it before, but I can't
> seem to find it now.
>|||Hi,
To add on to previous post,
you can also you SQL profiler-- In the event class use the event Deadlock.
Otherwise like Uri pointed out use
DBCC TRACEON(1204)
This will send the deadlock information to SQL server error log.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e1CYZq6JEHA.2576@.TK2MSFTNGP12.phx.gbl...
> Rick
> Check out DBCC TRACEON in the BOL
> "Rick Harrison" <rick@.knowware.com> wrote in message
> news:40867FEE.3050505@.knowware.com...
> > How do you configure the logs in SQL Server? Currently, all I see is my
> > backup processes. I'm trying to investigate a deadlock and I need much
> > more detail in the logging. I know I've done it before, but I can't
> > seem to find it now.
> >
>
backup processes. I'm trying to investigate a deadlock and I need much
more detail in the logging. I know I've done it before, but I can't
seem to find it now.Rick
Check out DBCC TRACEON in the BOL
"Rick Harrison" <rick@.knowware.com> wrote in message
news:40867FEE.3050505@.knowware.com...
> How do you configure the logs in SQL Server? Currently, all I see is my
> backup processes. I'm trying to investigate a deadlock and I need much
> more detail in the logging. I know I've done it before, but I can't
> seem to find it now.
>|||Hi,
To add on to previous post,
you can also you SQL profiler-- In the event class use the event Deadlock.
Otherwise like Uri pointed out use
DBCC TRACEON(1204)
This will send the deadlock information to SQL server error log.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e1CYZq6JEHA.2576@.TK2MSFTNGP12.phx.gbl...
> Rick
> Check out DBCC TRACEON in the BOL
> "Rick Harrison" <rick@.knowware.com> wrote in message
> news:40867FEE.3050505@.knowware.com...
> > How do you configure the logs in SQL Server? Currently, all I see is my
> > backup processes. I'm trying to investigate a deadlock and I need much
> > more detail in the logging. I know I've done it before, but I can't
> > seem to find it now.
> >
>
Monday, March 19, 2012
How to configure MSDE to listen on TCP/IP
Hi:
I'm not able to connect to MSDE remotely. From the SQL Server logs, it
is listening on Shared Memory only. How do I configure it to listen on
TCP/IP ?
The MSDE is running on WinXP Pro SP2, and there is a instance of
SQL2005 Express installed side by side, the SQL2005 Express is
configure to listen on port 1618. The firewall already turned off.
Another problem is related to SQL2005 Express... I'm not able to
connect to the SQL2005 Express remotely when the firewall turned ON,
even port 1618 is already add into exception list.
Any idea ?
Thanks
JCVoon
Problem solved. I enable the Named Pipes protocol using SVRNETCN.exe
and restart the MSDE.
Why must enabled the Named Pipes when I only need TCP/IP protocol ?
JCVoon
On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
> Hi:
> I'm not able to connect to MSDE remotely. From the SQL Server logs, it
> is listening on Shared Memory only. How do I configure it to listen on
> TCP/IP ?
> The MSDE is running on WinXP Pro SP2, and there is a instance of
> SQL2005 Express installed side by side, the SQL2005 Express is
> configure to listen on port 1618. The firewall already turned off.
> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
> Any idea ?
> Thanks
> JCVoon
|||network communications are typically more interactive for named pipes whereas.
data transmissions are more streamlined and have less overhead in TCP/IP
You can have more in SQL BOL
"jcvoon" wrote:
> Problem solved. I enable the Named Pipes protocol using SVRNETCN.exe
> and restart the MSDE.
> Why must enabled the Named Pipes when I only need TCP/IP protocol ?
> JCVoon
>
> On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
>
|||> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
You have to add the C:\Program Files\Microsoft SQL
Server\90\Shared\sqlbrowser.exe into the exceptions list.
I'm not able to connect to MSDE remotely. From the SQL Server logs, it
is listening on Shared Memory only. How do I configure it to listen on
TCP/IP ?
The MSDE is running on WinXP Pro SP2, and there is a instance of
SQL2005 Express installed side by side, the SQL2005 Express is
configure to listen on port 1618. The firewall already turned off.
Another problem is related to SQL2005 Express... I'm not able to
connect to the SQL2005 Express remotely when the firewall turned ON,
even port 1618 is already add into exception list.
Any idea ?
Thanks
JCVoon
Problem solved. I enable the Named Pipes protocol using SVRNETCN.exe
and restart the MSDE.
Why must enabled the Named Pipes when I only need TCP/IP protocol ?
JCVoon
On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
> Hi:
> I'm not able to connect to MSDE remotely. From the SQL Server logs, it
> is listening on Shared Memory only. How do I configure it to listen on
> TCP/IP ?
> The MSDE is running on WinXP Pro SP2, and there is a instance of
> SQL2005 Express installed side by side, the SQL2005 Express is
> configure to listen on port 1618. The firewall already turned off.
> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
> Any idea ?
> Thanks
> JCVoon
|||network communications are typically more interactive for named pipes whereas.
data transmissions are more streamlined and have less overhead in TCP/IP
You can have more in SQL BOL
"jcvoon" wrote:
> Problem solved. I enable the Named Pipes protocol using SVRNETCN.exe
> and restart the MSDE.
> Why must enabled the Named Pipes when I only need TCP/IP protocol ?
> JCVoon
>
> On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
>
|||> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
You have to add the C:\Program Files\Microsoft SQL
Server\90\Shared\sqlbrowser.exe into the exceptions list.
Monday, March 12, 2012
How to configure MSDE to listen on TCP/IP
Hi:
I'm not able to connect to MSDE remotely. From the SQL Server logs, it
is listening on Shared Memory only. How do I configure it to listen on
TCP/IP ?
The MSDE is running on WinXP Pro SP2, and there is a instance of
SQL2005 Express installed side by side, the SQL2005 Express is
configure to listen on port 1618. The firewall already turned off.
Another problem is related to SQL2005 Express... I'm not able to
connect to the SQL2005 Express remotely when the firewall turned ON,
even port 1618 is already add into exception list.
Any idea ?
Thanks
JCVoonProblem solved. I enable the Named Pipes protocol using SVRNETCN.exe
and restart the MSDE.
Why must enabled the Named Pipes when I only need TCP/IP protocol '
JCVoon
On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
> Hi:
> I'm not able to connect to MSDE remotely. From the SQL Server logs, it
> is listening on Shared Memory only. How do I configure it to listen on
> TCP/IP ?
> The MSDE is running on WinXP Pro SP2, and there is a instance of
> SQL2005 Express installed side by side, the SQL2005 Express is
> configure to listen on port 1618. The firewall already turned off.
> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
> Any idea ?
> Thanks
> JCVoon|||network communications are typically more interactive for named pipes wherea
s.
data transmissions are more streamlined and have less overhead in TCP/IP
You can have more in SQL BOL
"jcvoon" wrote:
> Problem solved. I enable the Named Pipes protocol using SVRNETCN.exe
> and restart the MSDE.
> Why must enabled the Named Pipes when I only need TCP/IP protocol '
> JCVoon
>
> On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
>|||> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
You have to add the C:\Program Files\Microsoft SQL
Server\90\Shared\sqlbrowser.exe into the exceptions list.
I'm not able to connect to MSDE remotely. From the SQL Server logs, it
is listening on Shared Memory only. How do I configure it to listen on
TCP/IP ?
The MSDE is running on WinXP Pro SP2, and there is a instance of
SQL2005 Express installed side by side, the SQL2005 Express is
configure to listen on port 1618. The firewall already turned off.
Another problem is related to SQL2005 Express... I'm not able to
connect to the SQL2005 Express remotely when the firewall turned ON,
even port 1618 is already add into exception list.
Any idea ?
Thanks
JCVoonProblem solved. I enable the Named Pipes protocol using SVRNETCN.exe
and restart the MSDE.
Why must enabled the Named Pipes when I only need TCP/IP protocol '
JCVoon
On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
> Hi:
> I'm not able to connect to MSDE remotely. From the SQL Server logs, it
> is listening on Shared Memory only. How do I configure it to listen on
> TCP/IP ?
> The MSDE is running on WinXP Pro SP2, and there is a instance of
> SQL2005 Express installed side by side, the SQL2005 Express is
> configure to listen on port 1618. The firewall already turned off.
> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
> Any idea ?
> Thanks
> JCVoon|||network communications are typically more interactive for named pipes wherea
s.
data transmissions are more streamlined and have less overhead in TCP/IP
You can have more in SQL BOL
"jcvoon" wrote:
> Problem solved. I enable the Named Pipes protocol using SVRNETCN.exe
> and restart the MSDE.
> Why must enabled the Named Pipes when I only need TCP/IP protocol '
> JCVoon
>
> On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
>|||> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
You have to add the C:\Program Files\Microsoft SQL
Server\90\Shared\sqlbrowser.exe into the exceptions list.
How to configure MSDE to listen on TCP/IP
Hi:
I'm not able to connect to MSDE remotely. From the SQL Server logs, it
is listening on Shared Memory only. How do I configure it to listen on
TCP/IP ?
The MSDE is running on WinXP Pro SP2, and there is a instance of
SQL2005 Express installed side by side, the SQL2005 Express is
configure to listen on port 1618. The firewall already turned off.
Another problem is related to SQL2005 Express... I'm not able to
connect to the SQL2005 Express remotely when the firewall turned ON,
even port 1618 is already add into exception list.
Any idea ?
Thanks
JCVoonProblem solved. I enable the Named Pipes protocol using SVRNETCN.exe
and restart the MSDE.
Why must enabled the Named Pipes when I only need TCP/IP protocol '
JCVoon
On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
> Hi:
> I'm not able to connect to MSDE remotely. From the SQL Server logs, it
> is listening on Shared Memory only. How do I configure it to listen on
> TCP/IP ?
> The MSDE is running on WinXP Pro SP2, and there is a instance of
> SQL2005 Express installed side by side, the SQL2005 Express is
> configure to listen on port 1618. The firewall already turned off.
> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
> Any idea ?
> Thanks
> JCVoon|||network communications are typically more interactive for named pipes whereas.
data transmissions are more streamlined and have less overhead in TCP/IP
You can have more in SQL BOL
"jcvoon" wrote:
> Problem solved. I enable the Named Pipes protocol using SVRNETCN.exe
> and restart the MSDE.
> Why must enabled the Named Pipes when I only need TCP/IP protocol '
> JCVoon
>
> On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
> > Hi:
> >
> > I'm not able to connect to MSDE remotely. From the SQL Server logs, it
> > is listening on Shared Memory only. How do I configure it to listen on
> > TCP/IP ?
> >
> > The MSDE is running on WinXP Pro SP2, and there is a instance of
> > SQL2005 Express installed side by side, the SQL2005 Express is
> > configure to listen on port 1618. The firewall already turned off.
> >
> > Another problem is related to SQL2005 Express... I'm not able to
> > connect to the SQL2005 Express remotely when the firewall turned ON,
> > even port 1618 is already add into exception list.
> >
> > Any idea ?
> >
> > Thanks
> > JCVoon
>|||> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
You have to add the C:\Program Files\Microsoft SQL
Server\90\Shared\sqlbrowser.exe into the exceptions list.
I'm not able to connect to MSDE remotely. From the SQL Server logs, it
is listening on Shared Memory only. How do I configure it to listen on
TCP/IP ?
The MSDE is running on WinXP Pro SP2, and there is a instance of
SQL2005 Express installed side by side, the SQL2005 Express is
configure to listen on port 1618. The firewall already turned off.
Another problem is related to SQL2005 Express... I'm not able to
connect to the SQL2005 Express remotely when the firewall turned ON,
even port 1618 is already add into exception list.
Any idea ?
Thanks
JCVoonProblem solved. I enable the Named Pipes protocol using SVRNETCN.exe
and restart the MSDE.
Why must enabled the Named Pipes when I only need TCP/IP protocol '
JCVoon
On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
> Hi:
> I'm not able to connect to MSDE remotely. From the SQL Server logs, it
> is listening on Shared Memory only. How do I configure it to listen on
> TCP/IP ?
> The MSDE is running on WinXP Pro SP2, and there is a instance of
> SQL2005 Express installed side by side, the SQL2005 Express is
> configure to listen on port 1618. The firewall already turned off.
> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
> Any idea ?
> Thanks
> JCVoon|||network communications are typically more interactive for named pipes whereas.
data transmissions are more streamlined and have less overhead in TCP/IP
You can have more in SQL BOL
"jcvoon" wrote:
> Problem solved. I enable the Named Pipes protocol using SVRNETCN.exe
> and restart the MSDE.
> Why must enabled the Named Pipes when I only need TCP/IP protocol '
> JCVoon
>
> On Jan 25, 12:45 pm, "jcvoon" <jiangchnan.v...@.maximas.com> wrote:
> > Hi:
> >
> > I'm not able to connect to MSDE remotely. From the SQL Server logs, it
> > is listening on Shared Memory only. How do I configure it to listen on
> > TCP/IP ?
> >
> > The MSDE is running on WinXP Pro SP2, and there is a instance of
> > SQL2005 Express installed side by side, the SQL2005 Express is
> > configure to listen on port 1618. The firewall already turned off.
> >
> > Another problem is related to SQL2005 Express... I'm not able to
> > connect to the SQL2005 Express remotely when the firewall turned ON,
> > even port 1618 is already add into exception list.
> >
> > Any idea ?
> >
> > Thanks
> > JCVoon
>|||> Another problem is related to SQL2005 Express... I'm not able to
> connect to the SQL2005 Express remotely when the firewall turned ON,
> even port 1618 is already add into exception list.
You have to add the C:\Program Files\Microsoft SQL
Server\90\Shared\sqlbrowser.exe into the exceptions list.
Sunday, February 19, 2012
How to clean up transaction logs
Hello,
Now, I use SQL Server 2000 and Analysis Manager. I have
some problem about transaction logs that have been
expanded day by day for the database of SQL and Ananlysis
Manager. Currently, size of transaction log files are
bigger than data files.
Please advise me how to clear or clean up transaction
logs.
Thank you for your help in advance.
KitRefer to following urls
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Transaction Log
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com|||In my opinion:
BACKUP LOG database_name [WITH TRUNCATE_ONLY]
DBCC SHRINKDATABASE database_name
Hope it helps
Zbig
Uzytkownik "Kit" <anonymous@.discussions.microsoft.com> napisal w wiadomosci
news:2ff501c4bfee$5f5cdea0$a301280a@.phx.gbl...
> Hello,
> Now, I use SQL Server 2000 and Analysis Manager. I have
> some problem about transaction logs that have been
> expanded day by day for the database of SQL and Ananlysis
> Manager. Currently, size of transaction log files are
> bigger than data files.
> Please advise me how to clear or clean up transaction
> logs.
> Thank you for your help in advance.
> Kit
>
Now, I use SQL Server 2000 and Analysis Manager. I have
some problem about transaction logs that have been
expanded day by day for the database of SQL and Ananlysis
Manager. Currently, size of transaction log files are
bigger than data files.
Please advise me how to clear or clean up transaction
logs.
Thank you for your help in advance.
KitRefer to following urls
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Transaction Log
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com|||In my opinion:
BACKUP LOG database_name [WITH TRUNCATE_ONLY]
DBCC SHRINKDATABASE database_name
Hope it helps
Zbig
Uzytkownik "Kit" <anonymous@.discussions.microsoft.com> napisal w wiadomosci
news:2ff501c4bfee$5f5cdea0$a301280a@.phx.gbl...
> Hello,
> Now, I use SQL Server 2000 and Analysis Manager. I have
> some problem about transaction logs that have been
> expanded day by day for the database of SQL and Ananlysis
> Manager. Currently, size of transaction log files are
> bigger than data files.
> Please advise me how to clear or clean up transaction
> logs.
> Thank you for your help in advance.
> Kit
>
How to clean up transaction logs
Hello,
Now, I use SQL Server 2000 and Analysis Manager. I have
some problem about transaction logs that have been
expanded day by day for the database of SQL and Ananlysis
Manager. Currently, size of transaction log files are
bigger than data files.
Please advise me how to clear or clean up transaction
logs.
Thank you for your help in advance.
Kit
Refer to following urls
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Transaction Log
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com
|||In my opinion:
BACKUP LOG database_name [WITH TRUNCATE_ONLY]
DBCC SHRINKDATABASE database_name
Hope it helps
Zbig
Uzytkownik "Kit" <anonymous@.discussions.microsoft.com> napisal w wiadomosci
news:2ff501c4bfee$5f5cdea0$a301280a@.phx.gbl...
> Hello,
> Now, I use SQL Server 2000 and Analysis Manager. I have
> some problem about transaction logs that have been
> expanded day by day for the database of SQL and Ananlysis
> Manager. Currently, size of transaction log files are
> bigger than data files.
> Please advise me how to clear or clean up transaction
> logs.
> Thank you for your help in advance.
> Kit
>
Now, I use SQL Server 2000 and Analysis Manager. I have
some problem about transaction logs that have been
expanded day by day for the database of SQL and Ananlysis
Manager. Currently, size of transaction log files are
bigger than data files.
Please advise me how to clear or clean up transaction
logs.
Thank you for your help in advance.
Kit
Refer to following urls
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Transaction Log
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com
|||In my opinion:
BACKUP LOG database_name [WITH TRUNCATE_ONLY]
DBCC SHRINKDATABASE database_name
Hope it helps
Zbig
Uzytkownik "Kit" <anonymous@.discussions.microsoft.com> napisal w wiadomosci
news:2ff501c4bfee$5f5cdea0$a301280a@.phx.gbl...
> Hello,
> Now, I use SQL Server 2000 and Analysis Manager. I have
> some problem about transaction logs that have been
> expanded day by day for the database of SQL and Ananlysis
> Manager. Currently, size of transaction log files are
> bigger than data files.
> Please advise me how to clear or clean up transaction
> logs.
> Thank you for your help in advance.
> Kit
>
Subscribe to:
Posts (Atom)