The server tag has no wiki summary.
0
votes
1answer
16 views
Should snapshot agent continue to run in transactional replication?
We have transactional replication running for a large number of publications on sql server 2008 R2 2 node active/active cluster. I have noticed that the snapshot agent job runs hourly and it looks ...
0
votes
0answers
41 views
Can't connect to service after updating ODBC driver
I am upgrading a VB6 program at work and one of the changes is that it now uses PostgreSQL 9.2.4 instead of 8. I was getting a 'client encoding mismatch' error, so I updated the ODBC driver, and the ...
1
vote
2answers
79 views
SQL Server db user mapped to windows login not in SQL Server logins
I am on a SQL Server 2008 where i login with DOMAIN\USER_A
On my database i can see this login is mapped to the user dbo of that database.
What i don't understand is that DOMAIN\USER_A is nowhere to ...
0
votes
0answers
20 views
How do I get let SQL Server 2005 know that I changed host name in Amazon AWS server?
I am using an Amazon AWS SQL Server 2008 R2 server for dev purposes. In order to follow a new naming convention, we changed the name of the host. I then tried to let SQL Server know about this ...
2
votes
1answer
81 views
SPI postgresql - insert data into table from postgres.c
I'm working inside postgres.c (inside exexc_simple_query) of postgresql 9.1 (line 1094 of http://doxygen.postgresql.org/postgres_8c_source.html#l00829 ). I need to insert some query information in a ...
2
votes
1answer
152 views
MySQL Query: Delete from 'table2' where column = 'value' IF column in 'table1' = 'value'
I am trying to execute a MySQL query to delete rows from 'table2' where column = 'value' IF column in 'table1' = 'value'
I have 2 tables...
Table 1 is called accounts
Table 2 is called ...
4
votes
2answers
114 views
How to run an exe file exists on a different server from SQL Server Job
We have an exe file on a server, say Server1 which should be run from a SQL job exists on a different server, e.g.: Server2. How can it be done? I know if it's a local file, I can use xp_cmdshell in ...
0
votes
0answers
31 views
How to/advice for hosting a multi-user database on the cloud with specific objectives
I have developed an application that users will be able to download and create an account with through our company. This application will always be connected to the internet. I have been testing the ...
0
votes
1answer
92 views
Database replication using wamp?
I have created a POS system for our corporation, in the HQ we have a wamp server with the main database, we also have more than 25 branches across the country.
I will setup a wamp server on each ...
0
votes
0answers
166 views
Server doesn't listen
I try in Win7 by means of PGAdmin 3 to be connected to a host 192.168.1.8 with the virtual machine with linux. Already which time I receive the message
Server doesn't listen
The server doesn't accept ...
1
vote
2answers
63 views
Is it possible to remove a database server from a cluster resource, but keep it running on the node
I was wondering if anyone knew whether it was possible to delete the cluster resource, but keep all of the disks and sql instance running on the node instead? So if I was to delete the cluster ...
-2
votes
1answer
138 views
Windows Server 2008 R2, Active Directory, and Oracle Database Server
I have a group of clients, Windows server 2008 R2(Active Directory Installed in it), and an oracle database Server
I Want to know how to make the configuration of the following Diagram in this link:
...
-3
votes
1answer
66 views
Are database servers less scalable than web servers? [closed]
Isn't it possible to scale database servers through virtualization, like forever? I like to keep most of the workload on database server because it optimizes queries and the architecture decreases the ...
0
votes
0answers
16 views
Myisam Mysql server crashed
I have a server with linux fedora 11 Operating System.
Recently , I discovered that every morning mysql has been crashed, so I have to restart mysql service.
Can any body help me?
1
vote
2answers
128 views
Get the list of all Tables, Views, Stored procedures that are not added in a publication for replication
How do i get the list of all Tables, Views, Stored procedures that are NOT added in a publication for replication?Can you help me to make the stored Proc for that?I am new to Replication....Thanks
1
vote
1answer
82 views
Public Database for Mobile Application
What are the proper steps to hosting a public database. Currently I a building a mobile application with Adobe Flash Builder. I have used Microsoft SQL Server, My SQL as well as WAMP Server. All of ...
0
votes
0answers
29 views
How can i configure sql server 2012 to use multiple nic? [duplicate]
I've a server with 4 nics.
I want to use 2 nics to query db and 2 nics to retrieve results from db
I want they work in load balancing and still continue to work if one nick is down.
It is possible?
...
0
votes
1answer
246 views
PostgreSQL server log connection message [closed]
I'm seeing the following message in PostgreSQL server log:
LOG: could not receive data from client: No connection could be made because the target machine actively refused it.
There are ...
4
votes
2answers
1k views
Can we minimise the risk of using xp_cmdshell?
Using xp_cmdshell can be quite helpful and sometimes possibly the only answer to some scenarios. I've read some posts on the internet that enabling xp_cmdshell might jeopardize the security of the ...
0
votes
1answer
83 views
Server default collation change or not change
The default collation of our new server is SQL_Latin1_General_CP1_CI_AS. However the collation of the other databases which are used as the source to migrate data into the target databases on this ...
2
votes
1answer
78 views
Unique Non Clustered Column in Partitioned table
We have partitioned one of our SQL Server tables on a Clustered Index datetime column, we have a Primary key Non-clustered index column with Identity data type and this column is setup as a ...
1
vote
3answers
866 views
Computer restarted and Postgres 9.2 service cannot be started?
My firewall is down and when I tried to start the Postgres service it gave me an error that said: the service started and then stopped. Some services stop automatically if they are not in use by other ...
2
votes
1answer
471 views
Unknown option '--no-beep'
I installed a new version of MySQL server (previously 5.0, now 5.5) and I copied the data folder in to the new one. Now I should perform mysql_upgrade. I opened the command prompt (server is located ...
0
votes
1answer
208 views
what's the optimal partition setup for a linux db server?
My host wants to know how I want to partition my server before installing CentOS. I need to be able to do use xtrabackup to create quick backups from 20-50GB databases. I know I need to use a LVM, but ...
5
votes
1answer
433 views
SQL Server 2008 R2 DMV Question
I have a query to retrieve the Top 10 queries based on total logical reads from the dm_exec_query_stats DMV.
SELECT TOP 10
SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
((CASE ...
-3
votes
1answer
57 views
What is Better SQL Server Configuration? [closed]
First think : MDF and LDF separate on raid 1
Second think : All in one raid5.
1
vote
0answers
148 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 ...
1
vote
1answer
58 views
System test Database user management
We are in development stage and to be able to give the developers an integration test environment, we need to give them access to the database, they can share and test their code in the system ...
4
votes
2answers
505 views
Query two SQL Server databases in same function but on two different servers
Suppose I have two database servers (DB-SERVER-1 & DB-SERVER-2), and there is a single database on each server (DB1 & DB2). Both are SQL Server databases. Is it possible to query both ...
0
votes
2answers
4k views
How to print out the query SQL text of a transaction by querying the “fn_dblog” or DBCC LOG('DataBaseName')?
At some point in the last 24 hours some changes were made to a customer SQL server 2008 (v 9.0 SP4) by one of a couple if possible applications that use the DB.
Its not particular critical, but it ...
1
vote
1answer
80 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 ...
1
vote
3answers
4k views
I've got 16GB of ram, how should I configure MySQL Server?
I've got a dedicated production server with multiple cpus and 16GB of ram.
I would like to know how can I configure it better to take advantage of the server resources for better performance because ...
1
vote
0answers
116 views
Writing project proposal for renovation of university server? [closed]
I am sorry if this really off-topic from this stackexchange, but I don't really know where to get the help. My group was asked to create a proposal for renovation of university's web server. The ...
0
votes
0answers
354 views
Update Statistics Maintenance Plan - Ambiguous column name error
Microsoft SQL Server 2008 R2 Web Edition (RTM) - 10.50.1600.1 (Intel X86)
Windows 2003 R2 SP2
I am in the process of setting up a maintenance plan to update statistics on a daily basis for all user ...
0
votes
2answers
189 views
SQL Server build
We are building a new server at work and I'm hoping to get ideas of how we should build it out for optimum performance and back-up capability. We have 6 drives and we need to have an OS (Windows ...
1
vote
2answers
348 views
Oracle Linked Server query error
We have a problem with a query from a SQL Server 2008R2 - 64bit
to an Oracle Linked Server.
We use the Oracle 64-bit driver for Windows.
When we query a certain table we get the following error:
...
2
votes
1answer
114 views
Aborted restoring from back up Sql Server 2008
I started restoring from backup using (WITH REPLACE, RESTORE WITH RECOVERY)
and realized that it was a mistake, so I stopped restoring.
Now this db is unavailable and has a 'Restoring' status.
Can ...
7
votes
2answers
247 views
Mirroring the Distributor
Has anyone had success with mirroring the distribution database? We have a dedicated server as a Distributor. It handles all our push replication from prod to reporting. We'd like to build an ...
0
votes
3answers
1k views
Figuring out database timezone
Does anybody know of a way to alter a time zone on a SQL database?
Is there any tool that could find the objects using the date and time?
3
votes
2answers
315 views
Windows Storage Server, SQL Server, regular files — means to protect from insider threats?
This is my first post here, and I am by no means qualified as a Windows Server or Storage Server 2008 or SQL Server 2008 administrator. I am mostly a Unix guy, however tasked with a job to investigate ...
