Metadata Services: servers

Showing posts with label servers. Show all posts

Friday, March 30, 2012

no job history

sql2k sp3a
One of my servers doesnt retain very much job history. I have no history for
several jobs that run once or more per day. Is there a limit to the amount
of records the SysJobHistory table can hold? Any other ideas?
TIA, ChrisRYes, you can define the limit. EM, right-click Agent, Properties. On one of the tabs, you can set
this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
> sql2k sp3a
> One of my servers doesnt retain very much job history. I have no history for several jobs that run
> once or more per day. Is there a limit to the amount of records the SysJobHistory table can hold?
> Any other ideas?
> TIA, ChrisR
>|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EjtESpdFHA.1288@.tk2msftngp13.phx.gbl...
> Yes, you can define the limit. EM, right-click Agent, Properties. On one
> of the tabs, you can set this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
>> sql2k sp3a
>> One of my servers doesnt retain very much job history. I have no history
>> for several jobs that run once or more per day. Is there a limit to the
>> amount of records the SysJobHistory table can hold? Any other ideas?
>> TIA, ChrisR
>sql

no job history

sql2k sp3a
One of my servers doesnt retain very much job history. I have no history for
several jobs that run once or more per day. Is there a limit to the amount
of records the SysJobHistory table can hold? Any other ideas?
TIA, ChrisRYes, you can define the limit. EM, right-click Agent, Properties. On one of
the tabs, you can set
this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...[vb
col=seagreen]
> sql2k sp3a
> One of my servers doesnt retain very much job history. I have no history f
or several jobs that run
> once or more per day. Is there a limit to the amount of records the SysJob
History table can hold?
> Any other ideas?
> TIA, ChrisR
>[/vbcol]|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EjtESpdFHA.1288@.tk2msftngp13.phx.gbl...
> Yes, you can define the limit. EM, right-click Agent, Properties. On one
> of the tabs, you can set this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
>

no job history

sql2k sp3a
One of my servers doesnt retain very much job history. I have no history for
several jobs that run once or more per day. Is there a limit to the amount
of records the SysJobHistory table can hold? Any other ideas?
TIA, ChrisR
Yes, you can define the limit. EM, right-click Agent, Properties. On one of the tabs, you can set
this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
> sql2k sp3a
> One of my servers doesnt retain very much job history. I have no history for several jobs that run
> once or more per day. Is there a limit to the amount of records the SysJobHistory table can hold?
> Any other ideas?
> TIA, ChrisR
>
|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EjtESpdFHA.1288@.tk2msftngp13.phx.gbl...
> Yes, you can define the limit. EM, right-click Agent, Properties. On one
> of the tabs, you can set this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
>

no items in SQL Server Group

In my enterprise mngr under Microsoft sql Servers
Sql Server Group

I see (No Items)

My network guy doesnt no much about this and i know nothing (all my experience is with db on my local hd.

Please let me know as much as possible.

ThanksYou must first a register a sever, right mouse button within sql server groups.

Wednesday, March 28, 2012

No errors. No replication, either...

I have one central publisher server and several remote merge pull boxes. On random remote servers, at random times, replication will fail. The data is inconsistent between the master publisher and the remote merge pull subscribers. (i.e., The subscribers have more recent data than the publisher.)

There are no error messages generated, and it's only for one article. The rest seem to update fine.

I am a complete noob when it comes to replication. How would I even start troubleshooting this? :S

Any assistance is appreciated. Thanks.

-D.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85908|||If it is a pull subscription, then does that not imply that the replication is one way? And then if the clients have more recent data it would indicate that data is being entered directly into the clients.|||Pootle_Flump,

Should I only be posting on one board?

Blindman,

The way I understand it is supposed to work is that data is entered on the remote subscribers, merged at the publisher, and then a snapshot pushes everything back down to the subscribers. The merges run throughout the day, and then snapshots are sent down at night, every couple of weeks.

I've checked the job logs on everything, and at the subscriber, I consistently see "No data needed to be merged." At the publisher, I do occasionally see an error like "The process could not bulk copy out of table 'contB83E8AA0AE6B4DBBBC147EAFA47D75F3'.", but the snapshot eventually succeeds, and the data matches more recently than that snapshot, with individual subscribers.

What to look at next? It's the "No data needed to be merged." that gets me...|||Pootle_Flump,

Should I only be posting on one board?Well - my preference is one at a time but I've got over that hang-up :) Some people consider it bad netiquette and will throw a wobbly about it. Some will avoid any cross-board posts.

The reason is simply that you can find yourself toiling away with a problem to find that others on another board have been privvy to info that would have helped you or,worse, you go down a blind alley that has already been covered elsewhere. Sorry to say as well that most users that cross post tend (IME) to have less invested in their threads and so are more likely to go AWOL too.

Anyway - I posted the link for our contributers to ensure that they can review what has gone on at SQLTeam before helping you out here. If it is resolved over there or there is a useful nugget of info then they can find out and not waste their time.
[/semi rant]

Ideally I would be grateful if you could keep the two threads in synch if any "break throughs" are made in either and also inform both if you manage to sort out your problem :) I think then everyone gets the best of both worlds.|||... and finally

I have not used merge replication so can't rather than won't help!|||Well - my preference is one at a time but I've got over that hang-up :) Some people consider it bad netiquette and will throw a wobbly about it. Some will avoid any cross-board posts.

...

Ideally I would be grateful if you could keep the two threads in synch if any "break throughs" are made in either and also inform both if you manage to sort out your problem :) I think then everyone gets the best of both worlds.

Gotcha. Makes total sense. I'll be more than happy to keep everyone on both boards in the loop.

Thanks.

-D.|||... and finally

I have not used merge replication so can't rather than won't help!

No sweat. Nobody is an expert on everything. ( I'm living proof of that! :D )

Thanks.

-D.|||I have one central publisher server and several remote merge pull boxes. On random remote servers, at random times, replication will fail. The data is inconsistent between the master publisher and the remote merge pull subscribers. (i.e., The subscribers have more recent data than the publisher.)

There are no error messages generated, and it's only for one article. The rest seem to update fine.

I am a complete noob when it comes to replication. How would I even start troubleshooting this? :S

Any assistance is appreciated. Thanks.

-D.

I'll give this a crack, only because we are in the process of rolling out merge replication to 60+ nodes (it's really ugly).

First:
- Which version of SQL Server (for publisher, distributor and subscriber(s))?
- What type of replication (snapshot, merge, or transactional)?
- What type of subscription (push or pull)?
- Are there horizontal filters on the articles?
- Are the publisher and the distributor on the same server?

I believe you are using Merge Replication (please correct me if I am wrong):

1. Look for conflicts (depending on version, right-click on the publication and select "View Conflicts")

- If there are conflicts, you will have to resolve each one individually

2. The way merge replication works (in a nutshell):

- There are three triggers on each article (table): insert, update, delete

- When DML changes data on the table, the appropriate trigger fires and places an entry into either msmerge_contents (insert, update) or msmerge_tombstone (delete). The data inserted into these tables includes the article nickname (an integer) and the rowguid of the updated row.

- When the merge agent next runs, it reads changes at the subscriber (ie, records in the appropriate msmerge_ table), then changes in the publisher. It tracks the history of changes using an integer value called generation.

If you are getting a message that no updates were made, then it means that no new entries were written (either at the publisher or the subscriber) into these msmerge_ tables.

OR POSSIBLY: if you are using horizontal filters on the articles, then it might mean that the merge agent has determined that the filter has excluded the particular subscriber from receiving updates.

I have tried merge replication (with dynamic horizontal filters) in both SQL 2000 and SQL 2005. I wholeheartedly recommend ditching SQL 2000 in favor of SQL 2005 (for both the publisher and the distributor). It's infinitely easier to set up publications and to manage replication (better reports, better conflict management, better alerts, just better).

You can also try this site for some of your questions:
http://www.replicationanswers.com/Default.asp

Be prepared for many long hours of reading to become comfortable with replication (esp Merge Replication). There are many quirks and features that may lead to less hair and less sleep.

Regards,

hmscott|||Greatly appreciated, hmscott.

- We are using both snapshot and merge replication. The snapshots appear to work fine. The merge is where the issue is.
- Both are pull subscriptions.
- There are no filters on any of the articles, either the snapshot or merge articles. They're different sets of articles.
- The publisher and distributor are indeed on the same server.

1. I'm not in the office, but I will look for conflicts when I get back in. I believe that conflict resolution was handled automatically in our configuration, if I recall correctly.

2. Let me see if I understand this correctly. When a change to a merge replicated table is made, a note is made in either the msmerge_contents table or the msmerge_tombstone table.

Since we're not using any filters on the articles, I'm wondering if the msmerge_contents or _tombstone tables are having issues, or maybe the triggers aren't working properly? Do either of those scenarios make sense?

Sadly, ditching 2k for 2k5 is not currently an option. Management prefers the "Even if it's broken, don't fix it! It may make it worse!" method of problem management.

I'll check the link out over the holiday. Thanks for the info.

And I'm bald already, so I should be good to go. :)

Thanks again for your help. I'll update again when I can find out more.

-D.|||I'll be in and out (mostly out) over the holiday.

I'm uncomfortable with the merge/snapshot thing. Maybe it's because I'm not understanding it correctly: is the same article involved in both merge and snapshot replication?

If so, I'm out of my league already; I didn't think that was possible.

But I'll look a bit further to see what I can find.

You might also consider having a look at sp_msmergedummyupdate (in SQL BOL). It might help "force" an update for replication.

Regards,

hmscott|||I'm uncomfortable with the merge/snapshot thing. Maybe it's because I'm not understanding it correctly: is the same article involved in both merge and snapshot repication?

If so, I'm out of my league already; I didn't think that was possible.

I don't think it is either. The article in question is only in the merge replication.

I'll definitely check out that sproc. Replication runs often enough during the day that it should be pretty easy to test.

Thanks again.

-D.|||Be prepared for many long hours of reading to become comfortable with replication (esp Merge Replication). There are many quirks and features that may lead to less hair and less sleep.

In this regard have you found a one-stop-shop for learning the minutiae of merge replication?
The best single resource I've found for transactional & snapshot replication has to be:
http://www.amazon.com/Guide-Server-Transactional-Snapshot-Replication/dp/0974973602/ref=sr_1_1/103-1393738-3011844|||In this regard have you found a one-stop-shop for learning the minutiae of merge replication?
The best single resource I've found for transactional & snapshot replication has to be:
http://www.amazon.com/Guide-Server-Transactional-Snapshot-Replication/dp/0974973602/ref=sr_1_1/103-1393738-3011844

You're right; I should have mentioned Mr. Cotter's book. As far as I am aware, Mr. Cotter is the expert on SQL replication.

Mostly, what I did was set up a Sandbox environment to test out various aspects of replication (mostly merge replication). I then repeated a number of tests and watched SQL Profiler (to see individual transactions) and the contents of various msmerge_ tables to see what transpired "under the hood". It was tedious but enlightening.

Regards,

hmscott|||From strange to stranger.

One of the developers on my team (my lead, actually) stated that the problem is fixed. In master..sysobjects, the replinfo column for that table object had been changed to 0 instead of 128, so the table was somehow not marked for replication. Nobody did this in EM or via script as far as we are aware, and the blame is currently being laid on a third party application. He marked that table for replication again, and it's working now.

Is that even possible? I thought ad-hoc updates to system tables weren't allowed. Unless the third-party app is running replication-altering sprocs, in which case, I'm scared.

I'm going to call this closed, for now. Thanks to everyone for their input. I learned a lot from this.

-D.|||From strange to stranger.

One of the developers on my team (my lead, actually) stated that the problem is fixed. In master..sysobjects, the replinfo column for that table object had been changed to 0 instead of 128, so the table was somehow not marked for replication. Nobody did this in EM or via script as far as we are aware, and the blame is currently being laid on a third party application. He marked that table for replication again, and it's working now.

Is that even possible? I thought ad-hoc updates to system tables weren't allowed. Unless the third-party app is running replication-altering sprocs, in which case, I'm scared.

I'm going to call this closed, for now. Thanks to everyone for their input. I learned a lot from this.

-D.

ad-hoc updates to system tables are allowed, but you have to run sp_configure 'allow updates' and set the value to 1. I don't generally recommend that you do this unless you know what values you are going to change and why.

You can try running profiler when the 3rd-party app is running to see what's going on under the hood. Warning: you may not like what you see.

Regards,

hmscott

Wednesday, March 21, 2012

No buffers

Occasionally on my SQL 2K SP3 Standard servers. The servers lock up with
the error.

LazyWriter: warning, no free buffers found.

After that I have to restart the SQLServer service to get things up and
running. How can I prevent this from happening?

Thanks,
RayHi

Without knowing the configuration values it is hard to say exactly what is
happening. a likely cause may be lack of memory and it may also mention this
in your SQL Server log.

You may want to search for the error message on Google. There are lots of
posts about pinning tables in 6.5 so your version number is also important
information.

John

"Ray" <someone@.nowhere.com> wrote in message
news:vT3Ad.4051$Y8.1567@.newssvr17.news.prodigy.com ...
> Occasionally on my SQL 2K SP3 Standard servers. The servers lock up with
> the error.
> LazyWriter: warning, no free buffers found.
> After that I have to restart the SQLServer service to get things up and
> running. How can I prevent this from happening?
> Thanks,
> Ray

Tuesday, March 20, 2012

no .trn files

I have two sql servers, one is replicating to the other using log shipping.
The backup directory got deleted.
Now replication says it is working, but I don't know how because the .trn
files are not being generated.
What do I have to do to get that started again?
Scott EmickScott,
Repliction is not the same as log shipping. If you are replicating, the
process can continue without transaction logs, but your publisher db will
increase in size if it is not in SIMPLE recovery model and you are not
taking transaction log backups.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Scott Emick" <semick@.ham.phoenix-sys.com> wrote in message
news:OolQXwu$DHA.1212@.TK2MSFTNGP12.phx.gbl...
> I have two sql servers, one is replicating to the other using log
shipping.
> The backup directory got deleted.
> Now replication says it is working, but I don't know how because the .trn
> files are not being generated.
> What do I have to do to get that started again?
> Scott Emick
>|||I did flip all the db's from FULL to simple, and back again, but I
still get no .trn files. I was trying to read about backups and maint
plans yesterday, but I haven't gotten anywhere yet. Yes, the
replication is still working, and I am glad of that, but I would like
to get things back to the way they were.
Scott
"Ron Talmage" <rtalmage@.prospice.com> wrote in message news:<#qyZTf1$DHA.1844@.TK2MSFTNGP11.
phx.gbl>...
> Scott,
> Repliction is not the same as log shipping. If you are replicating, the
> process can continue without transaction logs, but your publisher db will
> increase in size if it is not in SIMPLE recovery model and you are not
> taking transaction log backups.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Scott Emick" <semick@.ham.phoenix-sys.com> wrote in message
> news:OolQXwu$DHA.1212@.TK2MSFTNGP12.phx.gbl...
> shipping.|||Also, restarted sql server agent and the maint plans...Apparently one was
hung and I did not know it...
Scott
"Scott Emick" <semick@.msn.com> wrote in message
news:a2794831.0403020315.1c3ad442@.posting.google.com...
> I did flip all the db's from FULL to simple, and back again, but I
> still get no .trn files. I was trying to read about backups and maint
> plans yesterday, but I haven't gotten anywhere yet. Yes, the
> replication is still working, and I am glad of that, but I would like
> to get things back to the way they were.
> Scott
> "Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:<#qyZTf1$DHA.1844@.TK2MSFTNGP11.phx.gbl>...
will

no .trn files

I have two sql servers, one is replicating to the other using log shipping.
The backup directory got deleted.
Now replication says it is working, but I don't know how because the .trn
files are not being generated.
What do I have to do to get that started again?
Scott EmickScott,
Repliction is not the same as log shipping. If you are replicating, the
process can continue without transaction logs, but your publisher db will
increase in size if it is not in SIMPLE recovery model and you are not
taking transaction log backups.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Scott Emick" <semick@.ham.phoenix-sys.com> wrote in message
news:OolQXwu$DHA.1212@.TK2MSFTNGP12.phx.gbl...
> I have two sql servers, one is replicating to the other using log
shipping.
> The backup directory got deleted.
> Now replication says it is working, but I don't know how because the .trn
> files are not being generated.
> What do I have to do to get that started again?
> Scott Emick
>|||I did flip all the db's from FULL to simple, and back again, but I
still get no .trn files. I was trying to read about backups and maint
plans yesterday, but I haven't gotten anywhere yet. Yes, the
replication is still working, and I am glad of that, but I would like
to get things back to the way they were.
Scott
"Ron Talmage" <rtalmage@.prospice.com> wrote in message news:<#qyZTf1$DHA.1844@.TK2MSFTNGP11.phx.gbl>...
> Scott,
> Repliction is not the same as log shipping. If you are replicating, the
> process can continue without transaction logs, but your publisher db will
> increase in size if it is not in SIMPLE recovery model and you are not
> taking transaction log backups.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Scott Emick" <semick@.ham.phoenix-sys.com> wrote in message
> news:OolQXwu$DHA.1212@.TK2MSFTNGP12.phx.gbl...
> > I have two sql servers, one is replicating to the other using log
> shipping.
> >
> > The backup directory got deleted.
> >
> > Now replication says it is working, but I don't know how because the .trn
> > files are not being generated.
> >
> > What do I have to do to get that started again?
> >
> > Scott Emick
> >
> >|||Also, restarted sql server agent and the maint plans...Apparently one was
hung and I did not know it...
Scott
"Scott Emick" <semick@.msn.com> wrote in message
news:a2794831.0403020315.1c3ad442@.posting.google.com...
> I did flip all the db's from FULL to simple, and back again, but I
> still get no .trn files. I was trying to read about backups and maint
> plans yesterday, but I haven't gotten anywhere yet. Yes, the
> replication is still working, and I am glad of that, but I would like
> to get things back to the way they were.
> Scott
> "Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:<#qyZTf1$DHA.1844@.TK2MSFTNGP11.phx.gbl>...
> > Scott,
> >
> > Repliction is not the same as log shipping. If you are replicating, the
> > process can continue without transaction logs, but your publisher db
will
> > increase in size if it is not in SIMPLE recovery model and you are not
> > taking transaction log backups.

No "(local)" server name in servers list for SQL Server 2005

I have a new install of SQL SERVER 2005 on a new machine.
When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
or MS Access ADE Connection "Data Link Properties", there is no (local)
entry in drop-down "server Name" list. However the actual server name is
listed and I can use it for successful connection.
My main problem is that I am trying to get from SourceSafe a big Access ADE
project and it complains that it is not able to connect to (local) server for
almost each form/report.
Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
problem with my installation?
If it is a setup problem, how can I add (local) to the list of available
servers?
By the way,when I manually typed "(local)" server name, VS 2005 "add
connection" accepted it , but ADE Connection "Data Link Properties" reported
"Sql Server doesn't exist or access is denied"
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
I was able to fix the problem. ADE Connection "Data Link Properties" accepts
manually typed "(local)" after I changed the following:
1. In SQL Server 2005 Configuration Manager selected "SQL server 2005
Network Configuration/Protocols for MSSQLSERVER" and enabled "Tcp/IP".
Note that "SQL Native Client Configuration/Client Configuration" had already
"Tcp/IP" enabled.
2. Restarted SQL Server service.
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
"Michael Freidgeim" wrote:

> I have a new install of SQL SERVER 2005 on a new machine.
> When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
> or MS Access ADE Connection "Data Link Properties", there is no (local)
> entry in drop-down "server Name" list. However the actual server name is
> listed and I can use it for successful connection.
> My main problem is that I am trying to get from SourceSafe a big Access ADE
> project and it complains that it is not able to connect to (local) server for
> almost each form/report.
> Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
> problem with my installation?
> If it is a setup problem, how can I add (local) to the list of available
> servers?
> By the way,when I manually typed "(local)" server name, VS 2005 "add
> connection" accepted it , but ADE Connection "Data Link Properties" reported
> "Sql Server doesn't exist or access is denied"
> Michael Freidgeim.
> <a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
> My Blog: http://geekswithblogs.net/mnf/
> </a>

No "(local)" server name in servers list for SQL Server 2005

I have a new install of SQL SERVER 2005 on a new machine.
When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
or MS Access ADE Connection "Data Link Properties", there is no (local)
entry in drop-down "server Name" list. However the actual server name is
listed and I can use it for successful connection.
My main problem is that I am trying to get from SourceSafe a big Access ADE
project and it complains that it is not able to connect to (local) server fo
r
almost each form/report.
Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
problem with my installation?
If it is a setup problem, how can I add (local) to the list of available
servers?
By the way,when I manually typed "(local)" server name, VS 2005 "add
connection" accepted it , but ADE Connection "Data Link Properties" reporte
d
"Sql Server doesn't exist or access is denied"
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>I was able to fix the problem. ADE Connection "Data Link Properties" accept
s
manually typed "(local)" after I changed the following:
1. In SQL Server 2005 Configuration Manager selected "SQL server 2005
Network Configuration/Protocols for MSSQLSERVER" and enabled "Tcp/IP".
Note that "SQL Native Client Configuration/Client Configuration" had already
"Tcp/IP" enabled.
2. Restarted SQL Server service.
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
"Michael Freidgeim" wrote:

> I have a new install of SQL SERVER 2005 on a new machine.
> When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
> or MS Access ADE Connection "Data Link Properties", there is no (local)
> entry in drop-down "server Name" list. However the actual server name is
> listed and I can use it for successful connection.
> My main problem is that I am trying to get from SourceSafe a big Access AD
E
> project and it complains that it is not able to connect to (local) server
for
> almost each form/report.
> Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
> problem with my installation?
> If it is a setup problem, how can I add (local) to the list of available
> servers?
> By the way,when I manually typed "(local)" server name, VS 2005 "add
> connection" accepted it , but ADE Connection "Data Link Properties" repor
ted
> "Sql Server doesn't exist or access is denied"
> Michael Freidgeim.
> <a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
> My Blog: http://geekswithblogs.net/mnf/
> </a>

Monday, March 12, 2012

NIC teaming for SQL

Wanted to implement some fault tolerance and wanted to know if anyone of
you'll have implemented NIC teaming on your SQL servers ? If so, is there
any article on what it is and how to set it up ? Thanks
>
> Wanted to implement some fault tolerance and wanted to know if anyone of
> you'll have implemented NIC teaming on your SQL servers ? If so, is there
> any article on what it is and how to set it up ? Thanks
>
You might find the following information useful:
Using Redundant Network Cards
To ensure that users can access the data center, use redundant network
interface cards (NICs), and use NIC teaming to provide automatic failover
between the NICs in the event of a failure. NIC teaming combines two or
more physical NICs into a single logical NIC, which ensures that the data
center always has an active link to the network. To use NIC teaming,
connect each NIC card to a different switch on a different subnet. NIC
teaming requires software from the NIC vendor, and each NIC is configured
to use a common virtual IP address. When all NICs are working properly,
their combined bandwidth is pooled for increased performance. When a teamed
NIC begins to fail, the software stops using the failing NIC and routes all
network communication over the remaining NIC or NICs. This failover process
is transparent to the operating system and other devices on the network.
http://www.microsoft.com/technet/pro...y/harag04.mspx
Q. Is NIC teaming supported in a Server cluster?
A. Yes, however there are caveats. The use of NIC teaming on all cluster
networks concurrently is not supported. At least one of the cluster
networks that are enabled for internal communication between cluster nodes
must not be teamed. Typically, the un-teamed network is a private
interconnect dedicated to this type of communication. The use of NIC
teaming on other cluster networks is acceptable; however, if communication
problems occur on a teamed network, Microsoft Product Support Services may
require that teaming be disabled. If this action resolves the problem or
issue, then you must seek further assistance from the manufacturer of the
teaming solution.
http://www.microsoft.com/technet/pro.../technologies/
clustering/sercsfaq.mspx
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

NIC teaming for SQL

Wanted to implement some fault tolerance and wanted to know if anyone of
you'll have implemented NIC teaming on your SQL servers ? If so, is there
any article on what it is and how to set it up ? Thanks>
> Wanted to implement some fault tolerance and wanted to know if anyone of
> you'll have implemented NIC teaming on your SQL servers ? If so, is there
> any article on what it is and how to set it up ? Thanks
>
--
You might find the following information useful:
Using Redundant Network Cards
To ensure that users can access the data center, use redundant network
interface cards (NICs), and use NIC teaming to provide automatic failover
between the NICs in the event of a failure. NIC teaming combines two or
more physical NICs into a single logical NIC, which ensures that the data
center always has an active link to the network. To use NIC teaming,
connect each NIC card to a different switch on a different subnet. NIC
teaming requires software from the NIC vendor, and each NIC is configured
to use a common virtual IP address. When all NICs are working properly,
their combined bandwidth is pooled for increased performance. When a teamed
NIC begins to fail, the software stops using the failing NIC and routes all
network communication over the remaining NIC or NICs. This failover process
is transparent to the operating system and other devices on the network.
http://www.microsoft.com/technet/pr...oy/harag04.mspx
Q. Is NIC teaming supported in a Server cluster?
A. Yes, however there are caveats. The use of NIC teaming on all cluster
networks concurrently is not supported. At least one of the cluster
networks that are enabled for internal communication between cluster nodes
must not be teamed. Typically, the un-teamed network is a private
interconnect dedicated to this type of communication. The use of NIC
teaming on other cluster networks is acceptable; however, if communication
problems occur on a teamed network, Microsoft Product Support Services may
require that teaming be disabled. If this action resolves the problem or
issue, then you must seek further assistance from the manufacturer of the
teaming solution.
http://www.microsoft.com/technet/pr...3/technologies/
clustering/sercsfaq.mspx
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

NIC teaming for SQL

Wanted to implement some fault tolerance and wanted to know if anyone of
you'll have implemented NIC teaming on your SQL servers ? If so, is there
any article on what it is and how to set it up ? Thanks>
> Wanted to implement some fault tolerance and wanted to know if anyone of
> you'll have implemented NIC teaming on your SQL servers ? If so, is there
> any article on what it is and how to set it up ? Thanks
>
--
You might find the following information useful:
Using Redundant Network Cards
To ensure that users can access the data center, use redundant network
interface cards (NICs), and use NIC teaming to provide automatic failover
between the NICs in the event of a failure. NIC teaming combines two or
more physical NICs into a single logical NIC, which ensures that the data
center always has an active link to the network. To use NIC teaming,
connect each NIC card to a different switch on a different subnet. NIC
teaming requires software from the NIC vendor, and each NIC is configured
to use a common virtual IP address. When all NICs are working properly,
their combined bandwidth is pooled for increased performance. When a teamed
NIC begins to fail, the software stops using the failing NIC and routes all
network communication over the remaining NIC or NICs. This failover process
is transparent to the operating system and other devices on the network.
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/harag04.mspx
Q. Is NIC teaming supported in a Server cluster?
A. Yes, however there are caveats. The use of NIC teaming on all cluster
networks concurrently is not supported. At least one of the cluster
networks that are enabled for internal communication between cluster nodes
must not be teamed. Typically, the un-teamed network is a private
interconnect dedicated to this type of communication. The use of NIC
teaming on other cluster networks is acceptable; however, if communication
problems occur on a teamed network, Microsoft Product Support Services may
require that teaming be disabled. If this action resolves the problem or
issue, then you must seek further assistance from the manufacturer of the
teaming solution.
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/
clustering/sercsfaq.mspx
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

NIC Teaming ( Fault Tolerant Mode)

Has anyone had good or bad experiences with enabling NIC Teaming ..i.e. the
redundant method for your SQL Servers ? Any issues to be concerned with ?
Would like to hear from youll
ThanksGenerally, I haven't had/heard any problems. SQL Product Support Services
(PSS) may ask you to disable it as a troubleshooting step, especially in a
clustered environment if you open a support case, but otherwise I am unaware
of any concerns.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:unCY6rM3EHA.524@.TK2MSFTNGP09.phx.gbl...
> Has anyone had good or bad experiences with enabling NIC Teaming ..i.e.
the
> redundant method for your SQL Servers ? Any issues to be concerned with ?
> Would like to hear from youll
> Thanks
>

NIC Teaming ( Fault Tolerant Mode)

Has anyone had good or bad experiences with enabling NIC Teaming ..i.e. the
redundant method for your SQL Servers ? Any issues to be concerned with ?
Would like to hear from youll
Thanks
Generally, I haven't had/heard any problems. SQL Product Support Services
(PSS) may ask you to disable it as a troubleshooting step, especially in a
clustered environment if you open a support case, but otherwise I am unaware
of any concerns.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:unCY6rM3EHA.524@.TK2MSFTNGP09.phx.gbl...
> Has anyone had good or bad experiences with enabling NIC Teaming ..i.e.
the
> redundant method for your SQL Servers ? Any issues to be concerned with ?
> Would like to hear from youll
> Thanks
>

Nic Card Preferences

WE have three sql servers that talk to each other and pass text
files. All three are connected to the lan and also have GB crossover
cables connecting them to each other. We have certain processes that
run that we want to use a specific connection (crossover) to a
specific sql server, but the server is choosing to use the lan
connection rather than the crossover connection even when it is
specifically pointed to use the crossover connection. Is there a way
to force each sql server to use a specific connection when
communicating or transfering files from one sql server to another?
Any help greatly appreciatedYes. The technique is called a connection-specific domain suffix.
http://technet2.microsoft.com/windowsserver/en/library/9b3661c8-bf60-4b9d-8a34-2dbf6ac0f4551033.mspx?mfr=true
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<eric.c.smith@.gmail.com> wrote in message
news:1178897412.102618.129760@.y80g2000hsf.googlegroups.com...
> WE have three sql servers that talk to each other and pass text
> files. All three are connected to the lan and also have GB crossover
> cables connecting them to each other. We have certain processes that
> run that we want to use a specific connection (crossover) to a
> specific sql server, but the server is choosing to use the lan
> connection rather than the crossover connection even when it is
> specifically pointed to use the crossover connection. Is there a way
> to force each sql server to use a specific connection when
> communicating or transfering files from one sql server to another?
> Any help greatly appreciated
>|||eric.c.smith@.gmail.com wrote in news:1178897412.102618.129760
@.y80g2000hsf.googlegroups.com:
> WE have three sql servers that talk to each other and pass text
> files. All three are connected to the lan and also have GB crossover
> cables connecting them to each other. We have certain processes that
> run that we want to use a specific connection (crossover) to a
> specific sql server, but the server is choosing to use the lan
> connection rather than the crossover connection even when it is
> specifically pointed to use the crossover connection. Is there a way
> to force each sql server to use a specific connection when
> communicating or transfering files from one sql server to another?
> Any help greatly appreciated
>
You will need to configure explicit routes in and for the three servers.
From the Command Prompt, ROUTE PRINT will display the current route table.
ROUTE on its own displays a short help. IMHO it's a bit of an arcane art
...
BTW the route table is applicable to the whole computer - as far as I am
aware, you can't do what you require selectively by process.|||On May 11, 10:37 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> Yes. The technique is called a connection-specific domain suffix.http://technet2.microsoft.com/windowsserver/en/library/9b3661c8-bf60-...
> --
> Geoff N. Hiten
> Senior Database Administrator
> MicrosoftSQLServerMVP
> <eric.c.sm...@.gmail.com> wrote in message
> news:1178897412.102618.129760@.y80g2000hsf.googlegroups.com...
>
> > WE have threesqlservers that talk to each other and pass text
> > files. All three are connected to the lan and also have GB crossover
> > cables connecting them to each other. We have certain processes that
> > run that we want tousea specific connection (crossover) to a
> > specificsqlserver, but theserveris choosing tousethe lan
> > connection rather than the crossover connection even when it is
> > specifically pointed tousethe crossover connection. Is there a way
> > toforceeachsqlservertousea specific connection when
> > communicating or transfering files from onesqlserverto another?
> > Any help greatly appreciated- Hide quoted text -
> - Show quoted text -
Geoff,
Thanks for your quick reply. I read the article (about 3 times now)
and will see if that will help. These servers have natted IP
addresses since they are behind a firewall. We use hosts file to
communicate between them. can I still use the solution you referenced
me to in this article and do it using hosts files?|||Hosts files will work just fine. Think of DNS as a service-based central
hosts file.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<eric.c.smith@.gmail.com> wrote in message
news:1178900235.067952.185940@.y5g2000hsa.googlegroups.com...
> On May 11, 10:37 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
>> Yes. The technique is called a connection-specific domain
>> suffix.http://technet2.microsoft.com/windowsserver/en/library/9b3661c8-bf60-...
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> MicrosoftSQLServerMVP
>> <eric.c.sm...@.gmail.com> wrote in message
>> news:1178897412.102618.129760@.y80g2000hsf.googlegroups.com...
>>
>> > WE have threesqlservers that talk to each other and pass text
>> > files. All three are connected to the lan and also have GB crossover
>> > cables connecting them to each other. We have certain processes that
>> > run that we want tousea specific connection (crossover) to a
>> > specificsqlserver, but theserveris choosing tousethe lan
>> > connection rather than the crossover connection even when it is
>> > specifically pointed tousethe crossover connection. Is there a way
>> > toforceeachsqlservertousea specific connection when
>> > communicating or transfering files from onesqlserverto another?
>> > Any help greatly appreciated- Hide quoted text -
>> - Show quoted text -
> Geoff,
> Thanks for your quick reply. I read the article (about 3 times now)
> and will see if that will help. These servers have natted IP
> addresses since they are behind a firewall. We use hosts file to
> communicate between them. can I still use the solution you referenced
> me to in this article and do it using hosts files?
>|||<eric.c.smith@.gmail.com> wrote in message
news:1178900235.067952.185940@.y5g2000hsa.googlegroups.com...
> Geoff,
> Thanks for your quick reply. I read the article (about 3 times now)
> and will see if that will help. These servers have natted IP
> addresses since they are behind a firewall. We use hosts file to
> communicate between them. can I still use the solution you referenced
> me to in this article and do it using hosts files?
Yes.
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||On May 11, 11:34 am, "Greg D. Moore $Strider$"
<mooregr_deletet...@.greenms.com> wrote:
> <eric.c.sm...@.gmail.com> wrote in message
> news:1178900235.067952.185940@.y5g2000hsa.googlegroups.com...
> > Geoff,
> > Thanks for your quick reply. I read the article (about 3 times now)
> > and will see if that will help. These servers have natted IP
> > addresses since they are behind a firewall. We use hosts file to
> > communicate between them. can I still use the solution you referenced
> > me to in this article and do it using hosts files?
> Yes.
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Thank you all for your replies
If I wanted to use a host file for this would how would this work?
The first three in each hosts file is for LAN connectivity, the
additional ones are for private crossover connections between servers
current srvx2 hosts file
170.20.50.11 srvx2
170.20.50.12 srvx3
170.20.50.13 srvx4
current srvx3 hosts file
170.20.50.11 srvx2
170.20.50.12 srvx3
170.20.50.13 srvx4
current srvx4 hosts file
170.20.50.11 srvx2
170.20.50.12 srvx3
170.20.50.13 srvx4
servername connection to network Private lan connection#1 Private Lan
Connection #2
srvx2 170.20.50.11 (lan) 2.1.1.2 (connection to x3) 1.1.1.1
(connection to x4)
srvx3 170.20.50.12 (lan) 2.1.1.3 (connection to x2) 3.1.1.3
(connection to x4)
srvx4 170.20.50.13 (lan) 1.1.1.3 (connection to x2) 3.1.1.4
(connection to x3)
I am not sure what to add to each host file and how it will
differentiate between them. These private IP's are not registered in
a DNS zone. The servers use the hosts file like the examples I have
above.
new srvx2 hosts file
170.20.50.11 srvx2
170.20.50.12 srvx3
170.20.50.13 srvx4
2.1.1.2 srvx2
1.1.1.1 srvx2
new srvx3 hosts file
170.20.50.11 srvx2
170.20.50.12 srvx3
170.20.50.13 srvx4
2.1.1.3 srvx3
3.1.1.3 srvx3
new srvx4 hosts file
170.20.50.11 srvx2
170.20.50.12 srvx3
170.20.50.13 srvx4
1.1.1.3 srvx4
3.1.1.4 srvx4
I am not sure how to differentiate between the ip addresses, once
again appreciate all your help!|||On May 11, 1:07 pm, eric.c.sm...@.gmail.com wrote:
> On May 11, 11:34 am, "Greg D. Moore $Strider$"
>
>
> <mooregr_deletet...@.greenms.com> wrote:
> > <eric.c.sm...@.gmail.com> wrote in message
> >news:1178900235.067952.185940@.y5g2000hsa.googlegroups.com...
> > > Geoff,
> > > Thanks for your quick reply. I read the article (about 3 times now)
> > > and will see if that will help. These servers have natted IP
> > > addresses since they are behind a firewall. We use hosts file to
> > > communicate between them. can I still use the solution you referenced
> > > me to in this article and do it using hosts files?
> > Yes.
> > --
> > Greg Moore
> > SQL Server DBA Consulting Remote and Onsite available!
> > Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
> Thank you all for your replies
> If I wanted to use a host file for this would how would this work?
> The first three in each hosts file is for LAN connectivity, the
> additional ones are for private crossover connections between servers
> current srvx2 hosts file
> 170.20.50.11 srvx2
> 170.20.50.12 srvx3
> 170.20.50.13 srvx4
> current srvx3 hosts file
> 170.20.50.11 srvx2
> 170.20.50.12 srvx3
> 170.20.50.13 srvx4
> current srvx4 hosts file
> 170.20.50.11 srvx2
> 170.20.50.12 srvx3
> 170.20.50.13 srvx4
> servername connection to network Private lan connection#1 Private Lan
> Connection #2
> srvx2 170.20.50.11 (lan) 2.1.1.2 (connection to x3) 1.1.1.1
> (connection to x4)
> srvx3 170.20.50.12 (lan) 2.1.1.3 (connection to x2) 3.1.1.3
> (connection to x4)
> srvx4 170.20.50.13 (lan) 1.1.1.3 (connection to x2) 3.1.1.4
> (connection to x3)
> I am not sure what to add to each host file and how it will
> differentiate between them. These private IP's are not registered in
> a DNS zone. The servers use the hosts file like the examples I have
> above.
> new srvx2 hosts file
> 170.20.50.11 srvx2
> 170.20.50.12 srvx3
> 170.20.50.13 srvx4
> 2.1.1.2 srvx2
> 1.1.1.1 srvx2
> new srvx3 hosts file
> 170.20.50.11 srvx2
> 170.20.50.12 srvx3
> 170.20.50.13 srvx4
> 2.1.1.3 srvx3
> 3.1.1.3 srvx3
> new srvx4 hosts file
> 170.20.50.11 srvx2
> 170.20.50.12 srvx3
> 170.20.50.13 srvx4
> 1.1.1.3 srvx4
> 3.1.1.4 srvx4
> I am not sure how to differentiate between the ip addresses, once
> again appreciate all your help!- Hide quoted text -
> - Show quoted text -
After researching a bit on "friendly names for hosts files this is
what I came up with...Does this look like it will accomplish what I am
trying to do?
170.20.50.11 srvx2
170.20.50.12 srvx3
170.20.50.13 srvx4
2.1.1.2 srvx2b
1.1.1.1 srvx2c
2.1.1.3 srvx3b
3.1.1.3 srvx3c
1.1.1.3 srvx4b
3.1.1.4 srvx4c
Thanks all!|||I usually go with this:
170.20.50.11 srvx2
170.20.50.12 srvx3
170.20.50.13 srvx4
2.1.1.2 srvx2.Priv1
1.1.1.1 srvx2.priv2
2.1.1.3 srvx3.priv1
3.1.1.3 srvx3.priv2
1.1.1.3 srvx4.priv1
3.1.1.4 srvx4.priv2
Where each subnet has a connection-specific DNS suffix. You are trying to
alias a servername to a connection, which can have some authentication
issues.
For example, I want to use the Priv1 network to backup from srvx2 to srvx3.
I would reference servx3 as servx3.priv1, and it would work. I still have
the same network name, and all my authentication stuff works, but I am
forcing traffic across a specific subnet.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<eric.c.smith@.gmail.com> wrote in message
news:1178912150.700412.190180@.p77g2000hsh.googlegroups.com...
> On May 11, 1:07 pm, eric.c.sm...@.gmail.com wrote:
>> On May 11, 11:34 am, "Greg D. Moore $Strider$"
>>
>>
>> <mooregr_deletet...@.greenms.com> wrote:
>> > <eric.c.sm...@.gmail.com> wrote in message
>> >news:1178900235.067952.185940@.y5g2000hsa.googlegroups.com...
>> > > Geoff,
>> > > Thanks for your quick reply. I read the article (about 3 times now)
>> > > and will see if that will help. These servers have natted IP
>> > > addresses since they are behind a firewall. We use hosts file to
>> > > communicate between them. can I still use the solution you
>> > > referenced
>> > > me to in this article and do it using hosts files?
>> > Yes.
>> > --
>> > Greg Moore
>> > SQL Server DBA Consulting Remote and Onsite available!
>> > Email: sql (at) greenms.com
>> > http://www.greenms.com/sqlserver.html
>> Thank you all for your replies
>> If I wanted to use a host file for this would how would this work?
>> The first three in each hosts file is for LAN connectivity, the
>> additional ones are for private crossover connections between servers
>> current srvx2 hosts file
>> 170.20.50.11 srvx2
>> 170.20.50.12 srvx3
>> 170.20.50.13 srvx4
>> current srvx3 hosts file
>> 170.20.50.11 srvx2
>> 170.20.50.12 srvx3
>> 170.20.50.13 srvx4
>> current srvx4 hosts file
>> 170.20.50.11 srvx2
>> 170.20.50.12 srvx3
>> 170.20.50.13 srvx4
>> servername connection to network Private lan connection#1
>> Private Lan
>> Connection #2
>> srvx2 170.20.50.11 (lan) 2.1.1.2 (connection to x3)
>> 1.1.1.1
>> (connection to x4)
>> srvx3 170.20.50.12 (lan) 2.1.1.3 (connection to x2)
>> 3.1.1.3
>> (connection to x4)
>> srvx4 170.20.50.13 (lan) 1.1.1.3 (connection to x2)
>> 3.1.1.4
>> (connection to x3)
>> I am not sure what to add to each host file and how it will
>> differentiate between them. These private IP's are not registered in
>> a DNS zone. The servers use the hosts file like the examples I have
>> above.
>> new srvx2 hosts file
>> 170.20.50.11 srvx2
>> 170.20.50.12 srvx3
>> 170.20.50.13 srvx4
>> 2.1.1.2 srvx2
>> 1.1.1.1 srvx2
>> new srvx3 hosts file
>> 170.20.50.11 srvx2
>> 170.20.50.12 srvx3
>> 170.20.50.13 srvx4
>> 2.1.1.3 srvx3
>> 3.1.1.3 srvx3
>> new srvx4 hosts file
>> 170.20.50.11 srvx2
>> 170.20.50.12 srvx3
>> 170.20.50.13 srvx4
>> 1.1.1.3 srvx4
>> 3.1.1.4 srvx4
>> I am not sure how to differentiate between the ip addresses, once
>> again appreciate all your help!- Hide quoted text -
>> - Show quoted text -
> After researching a bit on "friendly names for hosts files this is
> what I came up with...Does this look like it will accomplish what I am
> trying to do?
> 170.20.50.11 srvx2
> 170.20.50.12 srvx3
> 170.20.50.13 srvx4
> 2.1.1.2 srvx2b
> 1.1.1.1 srvx2c
> 2.1.1.3 srvx3b
> 3.1.1.3 srvx3c
> 1.1.1.3 srvx4b
> 3.1.1.4 srvx4c
> Thanks all!
>|||On May 11, 2:46 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> I usually go with this:
> 170.20.50.11 srvx2
> 170.20.50.12 srvx3
> 170.20.50.13 srvx4
> 2.1.1.2 srvx2.Priv1
> 1.1.1.1 srvx2.priv2
> 2.1.1.3 srvx3.priv1
> 3.1.1.3 srvx3.priv2
> 1.1.1.3 srvx4.priv1
> 3.1.1.4 srvx4.priv2
> Where each subnet has a connection-specific DNS suffix. You are trying to
> alias a servername to a connection, which can have some authentication
> issues.
> For example, I want to use the Priv1 network to backup from srvx2 to srvx3.
> I would reference servx3 as servx3.priv1, and it would work. I still have
> the same network name, and all my authentication stuff works, but I am
> forcing traffic across a specific subnet.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> <eric.c.sm...@.gmail.com> wrote in message
> news:1178912150.700412.190180@.p77g2000hsh.googlegroups.com...
>
> > On May 11, 1:07 pm, eric.c.sm...@.gmail.com wrote:
> >> On May 11, 11:34 am, "Greg D. Moore $Strider$"
> >> <mooregr_deletet...@.greenms.com> wrote:
> >> > <eric.c.sm...@.gmail.com> wrote in message
> >> >news:1178900235.067952.185940@.y5g2000hsa.googlegroups.com...
> >> > > Geoff,
> >> > > Thanks for your quick reply. I read the article (about 3 times now)
> >> > > and will see if that will help. These servers have natted IP
> >> > > addresses since they are behind a firewall. We use hosts file to
> >> > > communicate between them. can I still use the solution you
> >> > > referenced
> >> > > me to in this article and do it using hosts files?
> >> > Yes.
> >> > --
> >> > Greg Moore
> >> > SQL Server DBA Consulting Remote and Onsite available!
> >> > Email: sql (at) greenms.com
> >> >http://www.greenms.com/sqlserver.html
> >> Thank you all for your replies
> >> If I wanted to use a host file for this would how would this work?
> >> The first three in each hosts file is for LAN connectivity, the
> >> additional ones are for private crossover connections between servers
> >> current srvx2 hosts file
> >> 170.20.50.11 srvx2
> >> 170.20.50.12 srvx3
> >> 170.20.50.13 srvx4
> >> current srvx3 hosts file
> >> 170.20.50.11 srvx2
> >> 170.20.50.12 srvx3
> >> 170.20.50.13 srvx4
> >> current srvx4 hosts file
> >> 170.20.50.11 srvx2
> >> 170.20.50.12 srvx3
> >> 170.20.50.13 srvx4
> >> servername connection to network Private lan connection#1
> >> Private Lan
> >> Connection #2
> >> srvx2 170.20.50.11 (lan) 2.1.1.2 (connection to x3)
> >> 1.1.1.1
> >> (connection to x4)
> >> srvx3 170.20.50.12 (lan) 2.1.1.3 (connection to x2)
> >> 3.1.1.3
> >> (connection to x4)
> >> srvx4 170.20.50.13 (lan) 1.1.1.3 (connection to x2)
> >> 3.1.1.4
> >> (connection to x3)
> >> I am not sure what to add to each host file and how it will
> >> differentiate between them. These private IP's are not registered in
> >> a DNS zone. The servers use the hosts file like the examples I have
> >> above.
> >> new srvx2 hosts file
> >> 170.20.50.11 srvx2
> >> 170.20.50.12 srvx3
> >> 170.20.50.13 srvx4
> >> 2.1.1.2 srvx2
> >> 1.1.1.1 srvx2
> >> new srvx3 hosts file
> >> 170.20.50.11 srvx2
> >> 170.20.50.12 srvx3
> >> 170.20.50.13 srvx4
> >> 2.1.1.3 srvx3
> >> 3.1.1.3 srvx3
> >> new srvx4 hosts file
> >> 170.20.50.11 srvx2
> >> 170.20.50.12 srvx3
> >> 170.20.50.13 srvx4
> >> 1.1.1.3 srvx4
> >> 3.1.1.4 srvx4
> >> I am not sure how to differentiate between the ip addresses, once
> >> again appreciate all your help!- Hide quoted text -
> >> - Show quoted text -
> > After researching a bit on "friendly names for hosts files this is
> > what I came up with...Does this look like it will accomplish what I am
> > trying to do?
> > 170.20.50.11 srvx2
> > 170.20.50.12 srvx3
> > 170.20.50.13 srvx4
> > 2.1.1.2 srvx2b
> > 1.1.1.1 srvx2c
> > 2.1.1.3 srvx3b
> > 3.1.1.3 srvx3c
> > 1.1.1.3 srvx4b
> > 3.1.1.4 srvx4c
> > Thanks all!- Hide quoted text -
> - Show quoted text -
Looks like this worked like a champ, there was one thing to consider
from this however that our developer had to tweak to make this work
proplerly...
"One caveat, SQL Server has a limit on extensions that you can use to
reference external tables from a query to a linked server:
srvx3.wire.dbo.batches (maxed)
So, when you add a dot to the host file reference it breaks the remote
reference possibility because there are to many extensions:
srvx3.priv1.wire.dbo.batches (one too many)
All I did was change the host name(s) to SRVX3P1
THANKS AGAIN ALL FOR YOUR HELP!!!|||Use [Servername.SuffixName].Database.Schema.Object and it will resolve
correctly within SQL.
Square brackets are your friend.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<eric.c.smith@.gmail.com> wrote in message
news:1179435475.288996.61950@.q23g2000hsg.googlegroups.com...
> On May 11, 2:46 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
>> I usually go with this:
>> 170.20.50.11 srvx2
>> 170.20.50.12 srvx3
>> 170.20.50.13 srvx4
>> 2.1.1.2 srvx2.Priv1
>> 1.1.1.1 srvx2.priv2
>> 2.1.1.3 srvx3.priv1
>> 3.1.1.3 srvx3.priv2
>> 1.1.1.3 srvx4.priv1
>> 3.1.1.4 srvx4.priv2
>> Where each subnet has a connection-specific DNS suffix. You are trying
>> to
>> alias a servername to a connection, which can have some authentication
>> issues.
>> For example, I want to use the Priv1 network to backup from srvx2 to
>> srvx3.
>> I would reference servx3 as servx3.priv1, and it would work. I still
>> have
>> the same network name, and all my authentication stuff works, but I am
>> forcing traffic across a specific subnet.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> <eric.c.sm...@.gmail.com> wrote in message
>> news:1178912150.700412.190180@.p77g2000hsh.googlegroups.com...
>>
>> > On May 11, 1:07 pm, eric.c.sm...@.gmail.com wrote:
>> >> On May 11, 11:34 am, "Greg D. Moore $Strider$"
>> >> <mooregr_deletet...@.greenms.com> wrote:
>> >> > <eric.c.sm...@.gmail.com> wrote in message
>> >> >news:1178900235.067952.185940@.y5g2000hsa.googlegroups.com...
>> >> > > Geoff,
>> >> > > Thanks for your quick reply. I read the article (about 3 times
>> >> > > now)
>> >> > > and will see if that will help. These servers have natted IP
>> >> > > addresses since they are behind a firewall. We use hosts file to
>> >> > > communicate between them. can I still use the solution you
>> >> > > referenced
>> >> > > me to in this article and do it using hosts files?
>> >> > Yes.
>> >> > --
>> >> > Greg Moore
>> >> > SQL Server DBA Consulting Remote and Onsite available!
>> >> > Email: sql (at) greenms.com
>> >> >http://www.greenms.com/sqlserver.html
>> >> Thank you all for your replies
>> >> If I wanted to use a host file for this would how would this work?
>> >> The first three in each hosts file is for LAN connectivity, the
>> >> additional ones are for private crossover connections between servers
>> >> current srvx2 hosts file
>> >> 170.20.50.11 srvx2
>> >> 170.20.50.12 srvx3
>> >> 170.20.50.13 srvx4
>> >> current srvx3 hosts file
>> >> 170.20.50.11 srvx2
>> >> 170.20.50.12 srvx3
>> >> 170.20.50.13 srvx4
>> >> current srvx4 hosts file
>> >> 170.20.50.11 srvx2
>> >> 170.20.50.12 srvx3
>> >> 170.20.50.13 srvx4
>> >> servername connection to network Private lan connection#1
>> >> Private Lan
>> >> Connection #2
>> >> srvx2 170.20.50.11 (lan) 2.1.1.2 (connection to x3)
>> >> 1.1.1.1
>> >> (connection to x4)
>> >> srvx3 170.20.50.12 (lan) 2.1.1.3 (connection to x2)
>> >> 3.1.1.3
>> >> (connection to x4)
>> >> srvx4 170.20.50.13 (lan) 1.1.1.3 (connection to x2)
>> >> 3.1.1.4
>> >> (connection to x3)
>> >> I am not sure what to add to each host file and how it will
>> >> differentiate between them. These private IP's are not registered in
>> >> a DNS zone. The servers use the hosts file like the examples I have
>> >> above.
>> >> new srvx2 hosts file
>> >> 170.20.50.11 srvx2
>> >> 170.20.50.12 srvx3
>> >> 170.20.50.13 srvx4
>> >> 2.1.1.2 srvx2
>> >> 1.1.1.1 srvx2
>> >> new srvx3 hosts file
>> >> 170.20.50.11 srvx2
>> >> 170.20.50.12 srvx3
>> >> 170.20.50.13 srvx4
>> >> 2.1.1.3 srvx3
>> >> 3.1.1.3 srvx3
>> >> new srvx4 hosts file
>> >> 170.20.50.11 srvx2
>> >> 170.20.50.12 srvx3
>> >> 170.20.50.13 srvx4
>> >> 1.1.1.3 srvx4
>> >> 3.1.1.4 srvx4
>> >> I am not sure how to differentiate between the ip addresses, once
>> >> again appreciate all your help!- Hide quoted text -
>> >> - Show quoted text -
>> > After researching a bit on "friendly names for hosts files this is
>> > what I came up with...Does this look like it will accomplish what I am
>> > trying to do?
>> > 170.20.50.11 srvx2
>> > 170.20.50.12 srvx3
>> > 170.20.50.13 srvx4
>> > 2.1.1.2 srvx2b
>> > 1.1.1.1 srvx2c
>> > 2.1.1.3 srvx3b
>> > 3.1.1.3 srvx3c
>> > 1.1.1.3 srvx4b
>> > 3.1.1.4 srvx4c
>> > Thanks all!- Hide quoted text -
>> - Show quoted text -
> Looks like this worked like a champ, there was one thing to consider
> from this however that our developer had to tweak to make this work
> proplerly...
> "One caveat, SQL Server has a limit on extensions that you can use to
> reference external tables from a query to a linked server:
> srvx3.wire.dbo.batches (maxed)
> So, when you add a dot to the host file reference it breaks the remote
> reference possibility because there are to many extensions:
> srvx3.priv1.wire.dbo.batches (one too many)
> All I did was change the host name(s) to SRVX3P1
> THANKS AGAIN ALL FOR YOUR HELP!!!
>

Nic Card Preferences

Friday, March 9, 2012

Next Run Date column not sorting

We've just installed SQL Server 2000 on one of our servers and have
noticed a strange behavior. When clicking the column headings in the
job display in Enterprise Manager, the list is sorted (first click
ascending, then descending) on the column clicked except for "Next Run
Date." When we click on "Next Run Date," the list is reordered, but
randomly. Each time we click it we get a different order but never
ascending or descending. This is true whether we're at the server or
on a remote machine. We never saw this behavior with SQL Server 7.0.

Any ideas? Thanks!"Rich Hurley" <Rich.Hurley@.mci.com> wrote in message
news:e3153db3.0410110535.129c4159@.posting.google.c om...
> We've just installed SQL Server 2000 on one of our servers and have
> noticed a strange behavior. When clicking the column headings in the
> job display in Enterprise Manager, the list is sorted (first click
> ascending, then descending) on the column clicked except for "Next Run
> Date." When we click on "Next Run Date," the list is reordered, but
> randomly. Each time we click it we get a different order but never
> ascending or descending. This is true whether we're at the server or
> on a remote machine. We never saw this behavior with SQL Server 7.0.
> Any ideas? Thanks!

The problem with Enterprise Manager is that you never really know what it's
doing. If you run a SELECT query with an ORDER BY clause in Query Analyzer,
does it return the correct order? QA is a much better and simpler tool for
retreiving and manipulating data than EM, because there's no guesswork
involved and you can control exactly what data you retrieve and how.

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message news:<416ad914_2@.news.bluewin.ch>...
> "Rich Hurley" <Rich.Hurley@.mci.com> wrote in message
> news:e3153db3.0410110535.129c4159@.posting.google.c om...
> The problem with Enterprise Manager is that you never really know what it's
> doing. If you run a SELECT query with an ORDER BY clause in Query Analyzer,
> does it return the correct order? QA is a much better and simpler tool for
> retreiving and manipulating data than EM, because there's no guesswork
> involved and you can control exactly what data you retrieve and how.
> Simon

ORDER BY works fine in QA. Ordering also works fine in other columns
of the job list in Ent. Mgr. The "Next Run Date" column is the only
one that is acting weird. If I use SQL 2000 Ent. Mgr. from my laptop
to look at any of our servers (4 SQL 7.0 & 1 SQL 2000) the same
behavior occurs. Ent. Mgr. on our 7.0 servers works fine but, of
course, cannot connect to the 2000 server.

Rich|||"Rich Hurley" <Rich.Hurley@.mci.com> wrote in message
news:e3153db3.0410120501.7ab303bc@.posting.google.c om...
> "Simon Hayes" <sql@.hayes.ch> wrote in message
> news:<416ad914_2@.news.bluewin.ch>...
>> "Rich Hurley" <Rich.Hurley@.mci.com> wrote in message
>> news:e3153db3.0410110535.129c4159@.posting.google.c om...
>>
>> The problem with Enterprise Manager is that you never really know what
>> it's
>> doing. If you run a SELECT query with an ORDER BY clause in Query
>> Analyzer,
>> does it return the correct order? QA is a much better and simpler tool
>> for
>> retreiving and manipulating data than EM, because there's no guesswork
>> involved and you can control exactly what data you retrieve and how.
>>
>> Simon
> ORDER BY works fine in QA. Ordering also works fine in other columns
> of the job list in Ent. Mgr. The "Next Run Date" column is the only
> one that is acting weird. If I use SQL 2000 Ent. Mgr. from my laptop
> to look at any of our servers (4 SQL 7.0 & 1 SQL 2000) the same
> behavior occurs. Ent. Mgr. on our 7.0 servers works fine but, of
> course, cannot connect to the 2000 server.
> Rich

If it's a date column, then perhaps some sort of regional settings issue
might be causing it? Although if it works properly in QA, then I personally
wouldn't worry about it; EM has plenty of other data manipulation issues
anyway, as described in some detail here:

http://www.aspfaq.com/show.asp?id=2455

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message news:<416bd8fc$1_3@.news.bluewin.ch>...
> If it's a date column, then perhaps some sort of regional settings issue
> might be causing it? Although if it works properly in QA, then I personally
> wouldn't worry about it; EM has plenty of other data manipulation issues
> anyway, as described in some detail here:
> http://www.aspfaq.com/show.asp?id=2455
> Simon

If the job list was sorted consistently when I click on the column
heading I'd believe it was a regional setting. But everytime I click
the "Next Run Time" heading, I get a random result. The other columns
sort ascending on the first click and descending on a second click and
continue to flip-flop as many times as they are clicked. Not so with
the "Next Run Time" column. There's no rhyme or reason to the order
that jobs are displayed no matter how many times I click -- it's
different each time -- not just a reverse of the previous display.

QA doesn't help when managing jobs -- as the article points out EM is
the preferred tool for that -- QA queries would simply be too long and
too complex. I'm just puzzled by what could cause this weird behavior
in EM.

Thanks,
Rich

Friday, March 30, 2012

no job history

no job history

no job history

no items in SQL Server Group

Wednesday, March 28, 2012

No errors. No replication, either...

Wednesday, March 21, 2012

No buffers

Tuesday, March 20, 2012

no .trn files

no .trn files

No "(local)" server name in servers list for SQL Server 2005

No "(local)" server name in servers list for SQL Server 2005

Monday, March 12, 2012

NIC teaming for SQL

NIC teaming for SQL

NIC teaming for SQL

NIC Teaming ( Fault Tolerant Mode)

NIC Teaming ( Fault Tolerant Mode)

Nic Card Preferences

Nic Card Preferences

Nic Card Preferences

Friday, March 9, 2012

Next Run Date column not sorting

Metadata Services

Blog Archive

About Me