The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
2answers
370 views

Backup SQL DataBase to C$

Another simple SQL backup question from me.... I've got a SQL Server database running on SSMS 2008 and am trying to configure some backup jobs. I am now seemingly fine with backing up and restoring ...
1
vote
0answers
268 views

Sybase anywhere sql server connection problems

in my work we have a software system based on sybase adaptive server any where version 6 installed on a windows server 2008. the system work fine but after a period of time from system start problems ...
3
votes
1answer
2k views

Network design considerations for Oracle Database Appliance

With the introduction of Oracle Engineered Systems the DBA is moved somewhat closer to infrastructure design decisions, and expected to at least have some opinions of the network design requirements ...
2
votes
1answer
2k views

Remove an IP address from server config

What is the safe way to remove an old IP address from SQL Server configuration? The scenario is, I have a server with 2 NIC's that should have been configured for teaming but weren't at the time SQL ...
1
vote
1answer
75 views

Disabling protocols using SQL Server Configuration Manager or ENDPOINTs

Besides SQL Server Configuration Manager, it's possible to disable access to specific SQL Server protocols by disabling the default ENDPOINTs, but what's the difference between the two options? Are ...
4
votes
2answers
8k views

SQL Server: Should we use TCP or Named Pipes or use the default?

When connecting to a SQL Server 2008 R2 from a .NET 4 client application on a different server in the same LAN, one can set three different network protocols: TCP Named Pipes Don't set anything in ...
1
vote
1answer
881 views

MySQL Cluster over WAN: Best Architecture Options?

My company is looking at a multi-data-centre solution for high-availability, fun, and profit. We have businesses across the planet, with the need for MySQL database clustering solutions that can keep ...
4
votes
1answer
5k views

Analysing SQL Server Network I/O

A frequent request I get from clients is to help figure out what queries or clients are making the largest contribution to SQL Server saturating an Ethernet link. Ideally I'd look at some counters ...
26
votes
2answers
9k views

I/O requests taking longer than 15 seconds

Usually our weekly full backups finish in about 35 minutes, with daily diff backups finishing in ~5 minutes. Since tuesday the dailies have taken almost 4 hours to complete, way more than should be ...
2
votes
1answer
197 views

database connection time expired issue

I have a server machine and four client machine for database connectivity. I installed sqlexpress 2008 in server and one machine and all remaining systems, they have connected the database through ...
1
vote
1answer
139 views

Change Oracle IP

If I change Oracle database server IP , what problem may exist and how to solve? modify hosts file modify tnsnames.ora file modify listener.ora file modify clients' tnsnames.ora files As I know ...
3
votes
1answer
2k views

Where do I find the meaning of TdsInputBufferError numbers?

We are having some sporadic connection errors on some of our SQL servers. I did some searching and found out about the Ring Buffer in SQL 2008 R2 and found some information, but I am not entirely sure ...
3
votes
2answers
3k views

How do I limit Oracle to use specific ports?

I've built a new Oracle 9iR2 instance on a Windows 2003 32-bit cluster. Of course, it's version 9i for reasons out of my control. Several application servers connect to this instance, and each opens ...
1
vote
1answer
429 views

PostgreSQL: Trouble accessing another server's Data via NFS

Background: I'm working on a 2-node High Availability PostgreSQL database cluster for my company. The system has a master/standby setup where the standby takes over the duties of the master when the ...
3
votes
2answers
2k views

TdsInputBufferError not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers

I've got an issue with SQL Server. The value of TdsInputBufferError is not 0 in LoginTimers errors of RING_BUFFER_CONNECTIVITY of sys.dm_os_ring_buffers. This happens randomly, once or twice a week, ...
5
votes
3answers
820 views

Using SQL Server on separate networks

I have a bunch of SQL Servers installed on Windows2008R2. Currently, each windows server has two NIC's, each connecting to separate networks. In other words, each server appears on each network. ...