I have a two node X64bit Windows 2003 SP2 enterprise edition cluster
running SQL 2005 Standard Edition 64bit.
What I am seeing is event ID's 1123, 1124 in the event logs on each
Cluster Node, and we are getting complaints of disconnects from the
database.
We are seeing it happen around 5
node X64bit Windows 2003 SP2 enterprise edition cluster running
SQL 2005 Standard Edition 64bit.
What I am seeing is event ID’s 1123, 1124 in the event logs on each Cluster
Node, and we are getting complaints of disconnects from the database.
We are seeing it happen around 5:50-6:00pm each
...@lifespan.org wrote:
I have a two node X64bit Windows 2003 SP2 enterprise edition cluster running
SQL 2005 Standard Edition 64bit.
What I am seeing is event ID’s 1123, 1124 in the event logs on each Cluster
Node, and we are getting complaints of disconnects from the database.
We
-Original Message-
From: William Robbins [mailto:dangerw...@gmail.com]
Sent: Friday, February 18, 2011 10:33 AM
To: NT System Admin Issues
Subject: Re: Sounding board on issue we are seeing with a Windows 2003 Cluster
with SQL 2005
Also that's a very specific timeframe...even if it's
[mailto:dangerw...@gmail.com]
Sent: Friday, February 18, 2011 10:33 AM
To: NT System Admin Issues
Subject: Re: Sounding board on issue we are seeing with a Windows 2003
Cluster with SQL 2005
Also that's a very specific timeframe...even if it's not backups on
the cluster, could
.
From: Ziots, Edward [mailto:ezi...@lifespan.org]
Sent: Friday, February 18, 2011 5:49 AM
To: NT System Admin Issues
Subject: Sounding board on issue we are seeing with a Windows 2003 Cluster with
SQL 2005
I have a two node X64bit Windows 2003 SP2 enterprise edition cluster running
SQL 2005
on issue we are seeing with a Windows 2003
Cluster with SQL 2005
I have a two node X64bit Windows 2003 SP2 enterprise edition cluster
running SQL 2005 Standard Edition 64bit.
What I am seeing is event ID’s 1123, 1124 in the event logs on each Cluster
Node, and we are getting complaints
, February 18, 2011 12:39 PM
To: NT System Admin Issues
Subject: Re: Sounding board on issue we are seeing with a Windows 2003
Cluster with SQL 2005
SQL Backup, Anti-Virus dat update or Scan initiation?
On Fri, Feb 18, 2011 at 9:29 AM, Miller Bonnie L.
mille...@mukilteo.wednet.edu wrote:
Any
with SQL 2005
I agree I would think if it were a physical NIC problem you could see
the dropped packets...
So your private NIC's are direct connected? Are you running a trace on
both machines watching the private NIC's?
The specific timeframe of the disconnect also doesn't lend itself to a
NIC
, February 18, 2011 11:46 AM
*To:* NT System Admin Issues
*Subject:* Re: Sounding board on issue we are seeing with a Windows 2003
Cluster with SQL 2005
I agree I would *think* if it were a physical NIC problem you could see
the dropped packets...
So your private NIC's are direct connected
, Edward ezi...@lifespan.org wrote:
I have a two node X64bit Windows 2003 SP2 enterprise edition cluster
running SQL 2005 Standard Edition 64bit.
What I am seeing is event ID’s 1123, 1124 in the event logs on each Cluster
Node, and we are getting complaints of disconnects from the database
edition cluster
running SQL 2005 Standard Edition 64bit.
What I am seeing is event ID’s 1123, 1124 in the event logs on each
Cluster Node, and we are getting complaints of disconnects from the
database.
We are seeing it happen around 5:50-6:00pm each night. ( shows in the
cluster log
the next day...
On Fri, Feb 18, 2011 at 8:48 AM, Ziots, Edward ezi...@lifespan.orgwrote:
I have a two node X64bit Windows 2003 SP2 enterprise edition cluster
running SQL 2005 Standard Edition 64bit.
What I am seeing is event ID’s 1123, 1124 in the event logs on each
Cluster Node, and we
action on the results the next day...
On Fri, Feb 18, 2011 at 8:48 AM, Ziots, Edward ezi...@lifespan.orgwrote:
I have a two node X64bit Windows 2003 SP2 enterprise edition cluster
running SQL 2005 Standard Edition 64bit.
What I am seeing is event ID’s 1123, 1124 in the event logs on each
Windows 2003 SP2 enterprise edition cluster
running SQL 2005 Standard Edition 64bit.
What I am seeing is event ID’s 1123, 1124 in the event logs on each
Cluster Node, and we are getting complaints of disconnects from the
database.
We are seeing it happen around 5:50-6:00pm each night
, and then take action on the results the next day...
On Fri, Feb 18, 2011 at 8:48 AM, Ziots, Edward ezi...@lifespan.orgwrote:
I have a two node X64bit Windows 2003 SP2 enterprise edition cluster
running SQL 2005 Standard Edition 64bit.
What I am seeing is event ID’s 1123, 1124 in the event logs
with a Windows 2003
Cluster with SQL 2005
Pure speculation, but the time frame to me screams:
User runs a manual query that in their experience takes a long time to
process (they don't know why) so they set it to start as they leave for
the day, and then take action on the results the next day
[mailto:dangerw...@gmail.com]
Sent: Friday, February 18, 2011 2:52 PM
To: NT System Admin Issues
Subject: Re: Sounding board on issue we are seeing with a Windows 2003
Cluster with SQL 2005
Crap...would not affect both nodes at the same time.
- WJR
On Fri, Feb 18, 2011 at 13:50, William Robbins
SQL 2005 database. It's
been running for a bit over two years now.
It has not been completely neglected as I have been doing manual backups
of the phone database M-F. I am just now learning of other pieces,
specifically transaction logs.
I just now not only learned about them but ran a backup
ever played one on television. To aggravate
things here, we are an IBM DB2 shop. So, I am not getting as much local
help with this as I'd like (especially since the DBA's are taking extended
weekends)...
Our phone system has its records kept in an MS SQL 2005 database. It's
been running
: Thursday, December 23, 2010 10:26 AM
To: NT System Admin Issues
Subject: Messy MS SQL-2005 database
Greetings!
I am not a DBA, nor have I ever played one on television. To aggravate
things here, we are an IBM DB2 shop. So, I am not getting as much local
help with this as I'd like (especially
not a DBA, nor have I ever played one on television. To aggravate
things here, we are an IBM DB2 shop. So, I am not getting as much local
help with this as I'd like (especially since the DBA's are taking
extended weekends)...
Our phone system has its records kept in an MS SQL 2005 database. It's
been
local help with this as I'd like (especially since the DBA's
are taking extended weekends)...
Our phone system has its records kept in an MS SQL 2005 database.
It's been running for a bit over two years now.
It has not been completely neglected as I have been doing manual
backups
And then set your transaction log back up to full.
From: Don Ely [mailto:don@gmail.com]
Sent: Thursday, December 23, 2010 7:30 AM
To: NT System Admin Issues
Subject: Re: Messy MS SQL-2005 database
Well, you can either go into SQL Mgmt Studio, right mouse click the DB, go
to tasks
Issues
Subject: RE: Setting SPN's on Clustered SQL (2005)
Yeah and the 64bit SQL box didn't work, go figures... back to the hell next
week.
Z
Edward E. Ziots
CISSP, Network +, Security +
Network Engineer
Lifespan Organization
Email:ezi...@lifespan.org
Cell:401-639-3505
-Original Message
Has anyone had to manually add a SPN to a multi-node cluster SQL 2005
box before?
I used the spn_query.vbs script from Microsoft to look at each of the
nodes of the cluster and the Cluster Name and the SQL Server name (
Still default instance)
Used the best practices that doesn't have the SQL
Message-
From: Ziots, Edward [mailto:ezi...@lifespan.org]
Sent: Friday, October 08, 2010 1:34 PM
To: NT System Admin Issues
Subject: Setting SPN's on Clustered SQL (2005)
Has anyone had to manually add a SPN to a multi-node cluster SQL 2005
box before?
I used the spn_query.vbs script from
, Bill [mailto:bem...@pittcountync.gov]
Sent: Friday, October 08, 2010 1:53 PM
To: NT System Admin Issues
Subject: RE: Setting SPN's on Clustered SQL (2005)
I have had this problem before. I don't remember a lot firsthand, but I
do have my notes about it. Copied/pasted below.
When multiple
No problem, Edward, although I honestly am not sure how I managed to
reply offline. D'oh!
-Original Message-
From: Ziots, Edward [mailto:ezi...@lifespan.org]
Sent: Friday, October 08, 2010 2:25 PM
To: NT System Admin Issues
Subject: RE: Setting SPN's on Clustered SQL (2005)
Bill
To: NT System Admin Issues
Subject: RE: Setting SPN's on Clustered SQL (2005)
No problem, Edward, although I honestly am not sure how I managed to
reply offline. D'oh!
-Original Message-
From: Ziots, Edward [mailto:ezi...@lifespan.org]
Sent: Friday, October 08, 2010 2:25 PM
To: NT System
: Friday, October 08, 2010 2:25 PM
To: NT System Admin Issues
Subject: RE: Setting SPN's on Clustered SQL (2005)
Bill thanks for the offline comments, we are going to try and move it
off a SQL cluster for this time, if that doesn't help stuff then well go
the SPN route, which I believe its going
Anyone have this set up and working?
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~
Yes. It rocks REALLY hard.
Regards,
Michael B. Smith
Consultant and Exchange MVP
http://TheEssentialExchange.com
From: David W. McSpadden [mailto:dav...@imcu.com]
Sent: Wednesday, February 17, 2010 11:52 AM
To: NT System Admin Issues
Cc: NT System Admin Issues
Subject: SQL 2005 Mirroring
The SA account?
You should be in a domain using windows auth, ne?
Regards,
Michael B. Smith
Consultant and Exchange MVP
http://TheEssentialExchange.com
From: David W. McSpadden [mailto:dav...@imcu.com]
Sent: Wednesday, February 17, 2010 1:15 PM
To: NT System Admin Issues
Subject: Re: SQL 2005
Just using general names for the forum.
domain\appsa account = sa account to me.
Sorry for being vague.
From: Michael B. Smith
Sent: Wednesday, February 17, 2010 2:09 PM
To: NT System Admin Issues
Subject: RE: SQL 2005 Mirroring
The SA account?
You should be in a domain using windows
, February 17, 2010 2:33 PM
To: NT System Admin Issues
Subject: Re: SQL 2005 Mirroring
Just using general names for the forum.
domain\appsa account = sa account to me.
Sorry for being vague.
From: Michael B. Smithmailto:mich...@smithcons.com
Sent: Wednesday, February 17, 2010 2:09 PM
To: NT System
Does having SQL running from local system instead of sa account sound obvious
to you?
From: Michael B. Smith
Sent: Wednesday, February 17, 2010 2:38 PM
To: NT System Admin Issues
Subject: RE: SQL 2005 Mirroring
There are metric buttloads of potential issues with a 1418 error.
I'd start
System Admin Issues
Subject: Re: SQL 2005 Mirroring
Does having SQL running from local system instead of sa account sound obvious
to you?
From: Michael B. Smithmailto:mich...@smithcons.com
Sent: Wednesday, February 17, 2010 2:38 PM
To: NT System Admin Issuesmailto:ntsysadmin@lyris.sunbelt
Sweet. The doc's I've been looking at keep talking about certs but none of
them said what you just said.
Thank you.
From: Michael B. Smith
Sent: Wednesday, February 17, 2010 4:28 PM
To: NT System Admin Issues
Subject: RE: SQL 2005 Mirroring
You have to run mirroring from an account
account.
Cheers
Ken
From: David W. McSpadden [mailto:dav...@imcu.com]
Sent: Thursday, 18 February 2010 8:44 AM
To: NT System Admin Issues
Subject: Re: SQL 2005 Mirroring
Sweet. The doc's I've been looking at keep talking about certs but none of
them said what you just said.
Thank you.
From
Hi,
I think that I already know how to do this, but I want to run it past you
guys.
I have a Windows 2008 server thats runs SQL2005SP2 standard. I have been
asked to create a new SQL instance on the server for Backup exec 12.5 to
live on.
Am I right in saying that I simply re-run the
That is correct.
But you can always test in a little VPC 2007 VM or something if you want to be
sure.
Cheers
Ken
From: Gavin Wilby [mailto:gavin.wi...@gmail.com]
Sent: Tuesday, 24 March 2009 8:00 PM
To: NT System Admin Issues
Subject: Creating a new SQL 2005 instance.
Hi,
I think that I
Pretty much that is correct but I think you will also need any missing
updates as well as SP 2. I never did see any for my setup so I just stopped
at the SP.
Jon
On Tue, Mar 24, 2009 at 5:00 AM, Gavin Wilby gavin.wi...@gmail.com wrote:
Hi,
I think that I already know how to do this, but I
Cheers guys,
I think Ill VM it 1st just to be super sure, and get used to the procedure.
Good to know I was on track though ;)
Gavin.
On Tue, Mar 24, 2009 at 9:02 AM, Jon Harris jk.har...@gmail.com wrote:
Pretty much that is correct but I think you will also need any missing
updates as well
-639-3505
From: Benjamin Zachary - Lists [mailto:li...@levelfive.us]
Sent: Friday, February 27, 2009 8:44 PM
To: NT System Admin Issues
Subject: RE: SQL 2005 to 2008 Upgrade
I had to do not an upgrade but move a bunch of databases, I just
detached, copied over
Any caveats regarding an in place upgrade from SQL 2005 to SQL 2008?
Roger Wright
Network Administrator
Evatone, Inc.
727.572.7076 x388
_
I had amnesia once - or twice. - S.W.
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ http
System Admin Issues
Subject: SQL 2005 to 2008 Upgrade
Any caveats regarding an in place upgrade from SQL 2005 to SQL 2008?
Roger Wright
Network Administrator
Evatone, Inc.
727.572.7076 x388
ET E-mail Signature Logo
_
I had amnesia once - or twice. - S.W
Assumes no named instances.
Unfortunately there seems to be no general answer for those.
On Mon, Jan 12, 2009 at 12:22 PM, Tigran K tigr...@gmail.com wrote:
try this
use master
select * from sys.sysdatabases
--Tigran
On Mon, Jan 12, 2009 at 4:51 AM, Doige, Clayton
:08 PM
To: NT System Admin Issues
Subject: Re: SQL 2005
Assumes no named instances.
Unfortunately there seems to be no general answer for those.
On Mon, Jan 12, 2009 at 12:22 PM, Tigran K tigr...@gmail.com wrote:
try this
use master
select * from sys.sysdatabases
--Tigran
On Mon
I'll be at TEC'2009! http://www.tec2009.com/vegas/index.php
*From:* G.Waleed Kavalec [mailto:kava...@gmail.com]
*Sent:* Tuesday, January 13, 2009 12:08 PM
*To:* NT System Admin Issues
*Subject:* Re: SQL 2005
Assumes no named instances.
Unfortunately there seems to be no general
You can also try running the following on master database
select * from sys.sysaltfiles
this will list both transaction log and database file locations.
--Tigran
On Mon, Jan 12, 2009 at 4:51 AM, Doige, Clayton
clayton.do...@cme-net.comwrote:
Hi all, I don't do much with SQL so apologies if
Hi all, I don't do much with SQL so apologies if this is a daft
question.
Is there a nice easy way to generate a list of all databases on a server
which includes the file paths for the log and data files?
Thanks for any assistance
Clayton Doige
IT Project Manager
CME Development
try this
use master
select * from sys.sysdatabases
--Tigran
On Mon, Jan 12, 2009 at 4:51 AM, Doige, Clayton
clayton.do...@cme-net.comwrote:
Hi all, I don't do much with SQL so apologies if this is a daft question.
Is there a nice easy way to generate a list of all databases on a server
We installed ours and pointed to a DB on SQL 2005 STD SP2 here, didn't
use express.
Z
Edward E. Ziots
Network Engineer
Lifespan Organization
Email: [EMAIL PROTECTED]
Phone: 401-639-3505
MCSE, MCP+I, ME, CCA, Security +, Network +
From: Joseph L
Anyone know how to set this up if express is already installed? The app doesn't
give you the option to instantiate a new db?
Thanks!
jlc
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~
Hi all,
I am building a 2005 SQL database server that will be supporting 30 users. The
front-end for this database will be on a separate box.
Does anyone have any hardware recommendations. i.e. number drives, ram, etc?
I prefer HP hardware but, I welcome any input.
Thanks,
/Chad
Think
and Quad Core Processors with 8-16GB of RAM and Windows 2003/2008
Enterprise along with SQL 2000 Std/Enterprise would be a good starting
point, but you can probably get away with less with your setup with
Win2003 STD and SQL 2005 STD.
HTH
Z
Edward E. Ziots
Network Engineer
Lifespan Organization
starting
point, but you can probably get away with less with your setup with
Win2003 STD and SQL 2005 STD.
HTH
Z
Edward E. Ziots
Network Engineer
Lifespan Organization
Email: [EMAIL PROTECTED]
Phone: 401-639-3505
MCSE, MCP+I, ME, CCA, Security +, Network +
-Original Message-
From: Chad
Enterprise along with SQL 2000 Std/Enterprise would be a good starting
point, but you can probably get away with less with your setup with
Win2003 STD and SQL 2005 STD.
HTH
Z
Edward E. Ziots
Network Engineer
Lifespan Organization
Email: [EMAIL PROTECTED]
Phone: 401-639-3505
MCSE, MCP+I, ME, CCA, Security
I am new to SQL 2005 Integration Services and have a few questions which
I am having problems finding a solution to.
Does anyone know of a good SQL 2005 Forum which they would be willing
to recommend?
Thanks in advance,
-Steven Nelligan
Steven M. Nelligan
~ Finally
You might try here:
http://www.sqlservercentral.com/
From: Nelligan, Steve M (Facilities Services) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2008 11:57 AM
To: NT System Admin Issues
Subject: OT Looking for an SQL 2005 listserve
I am new to SQL 2005 Integration
-Original Message-
From: Spencer Read [mailto:[EMAIL PROTECTED]
Subject: RE: - SQL 2005 Trigger variable problem
I never thought of that, but I changed it and it still doesn't work -
exactly the same result
Have you used SQL Server Profiler to see what is going on?
Webster
Hoping for some advice as the SQL list seems to be full of junk at the moment
I'm trying to build a trigger in SQL 2005 SP2 - code is at the bottom
The trouble is that in a query window with an order number fed in manually (set
@order_no = '086534' for example) the code works fine
-Original Message-
From: Spencer Read [mailto:[EMAIL PROTECTED]
Subject: OT:- SQL 2005 Trigger variable problem
I'm trying to build a trigger in SQL 2005 SP2 - code is at the bottom
The trouble is that in a query window with an order number fed in
manually (set @order_no
I never thought of that, but I changed it and it still doesn't work - exactly
the same result
...Spence
-Original Message-
From: Webster [mailto:[EMAIL PROTECTED]
Sent: 12 September 2008 21:52
To: NT System Admin Issues
Subject: RE: - SQL 2005 Trigger variable problem
If you don't know if the SQL DB is doing anything important, I highly
suggest you stop the service first and see what breaks. Don't just
remove it.
You can also open SQL Studio Manager and look at what DB/instances are
running on the server to help determine what its doing.
SQL 2005
Is this an R2 server? Did you reciently upgrade to WSUS 3.0 SP1?
-Original Message-
From: Anthony [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 16, 2008 10:44 AM
To: NT System Admin Issues
Subject: SQL 2005 AdventureWorks
I'm trying to cleanup an SBS Premium 2003 SP1 Server.
I
Again another one that is driving me nuts.
I am trying to use the following command with a .ini file which is a
copy of the template.ini include with SQL 2005 Standard CD we have to
build a silent install.
The bat file
Start /wait setup.exe /qb /settings D:\ServerInstall.ini
The .ini file
: Wednesday, April 09, 2008 12:18 PM
To: NT System Admin Issues
Subject: For anyone that has done a silent install of SQL 2005
Importance: High
Again another one that is driving me nuts.
I am trying to use the following command with a .ini file which is a
copy of the template.ini include with SQL 2005
What should the ADDLOCAL line be then.
The requirement is Options Section which I have.
And from the template.ini file this is what I want the end-state to look
like.
SQL 2005 Standard edition installed in D:\Program Files\Microsoft SQL
Server. I Want the database engine, data files, SQL XML
SQMREPORTING=0
Regards,
Michael B. Smith
MCSE/Exchange MVP
http://TheEssentialExchange.com
-Original Message-
From: Ziots, Edward [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 09, 2008 12:51 PM
To: NT System Admin Issues
Subject: RE: For anyone that has done a silent install of SQL 2005
What should the ADDLOCAL line be then.
I'm not positive, but I think he was commenting on the ADDLOCAL=ADDLOCAL=
in your string.
- Andy O.
~ Upgrade to Next Generation Antispam/Antivirus with Ninja!~
~ http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm ~
Lifespan Organization
MCSE,MCSA,MCP,Security+,Network+,CCA
Phone: 401-639-3505
-Original Message-
From: Ziots, Edward [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 09, 2008 1:19 PM
To: NT System Admin Issues
Subject: RE: For anyone that has done a silent install of SQL 2005
Going
Just got a new dell server with 2003 on it. Also have just gotten
access to the server 2008 media and licenses.
This is going to be a MS SQL 2005 host for Altiris.
Anyone have and advice? Should I stick with 03 or re-load the server
with 08?
Any horror or success stories?
TIA.
Glen
From: Glen Johnson [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2008 10:19 AM
To: NT System Admin Issues
Subject: SQL 2005 on server 2008
Just got a new dell server with 2003 on it. Also have just gotten access to
the server 2008 media and licenses.
This is going to be a MS SQL 2005 host
Does anyone use 3rd party defrag utilities with there SQL 2000/SQL 2005
instances.
Also when you are setting up your disks, for clustering are you using
write-alignment with your SAN at 64K and also parititioning at 64K?
Z
Edward E. Ziots
Network Engineer
Lifespan Organization
Subject: Question on Defragging and SQL 2005
Does anyone use 3rd party defrag utilities with there SQL 2000/SQL 2005
instances.
Also when you are setting up your disks, for clustering are you using
write-alignment with your SAN at 64K and also parititioning at 64K?
Z
Edward E
:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 1:56 PM
To: NT System Admin Issues
Subject: RE: Question on Defragging and SQL 2005
If your log volumes and data volumes are separate, then defrag provides
no benefit.
Win 2008 automatically partitions at 1,024 K. On earlier OSes, I'm going
at 128K
I like SQLIOSIM. It can tell you a LOT.
Regards,
Michael B. Smith
MCSE/Exchange MVP
http://TheEssentialExchange.com
From: Ziots, Edward [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 2:09 PM
To: NT System Admin Issues
Subject: RE: Question on Defragging and SQL 2005
I
Lifespan Organization
MCSE,MCSA,MCP,Security+,Network+,CCA
Phone: 401-639-3505
-Original Message-
From: Michael B. Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 2:24 PM
To: NT System Admin Issues
Subject: RE: Question on Defragging and SQL 2005
I like SQLIOSIM. It can
This has been an ongoing issue for us, and I wondered if you folks had
run into similar issues.
Often, when we install SQL Server 2005 standard edition, the Management
Studio doesn't get installed, even though it was selected to be
installed.
There's a bit of discussion of this on-line;
81 matches
Mail list logo