The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
2answers
46 views

Identical SQL Server databases hosted in the same physical DB server

We have hosted similar SQL Server 2014 databases TestDB and TESTDB_Copy on the same physical server. The two databases are almost the same and there may be minor differences in the number of records ...
1
vote
1answer
32 views

Virtualized SQL Server Memory Oddity

I've not seen this before, though perhaps it is common. I am looking at a virtualized (VMWare 5.5) SQL Server (2008R2 on Windows 2008 R2). What I am seeing is that in Task Manager, sqlserver.exe is ...
0
votes
2answers
43 views

How to add deleted user in sql server? [duplicate]

I have set up sql server 2008 in windows server 2008 r2 and it works fine. However, I have deleted the my user from logins in the sql server accidentally and now I cannot find a way to log in to the ...
2
votes
1answer
22 views

postgresql on windows won't install with data and executables on different disks

I am trying to install postgresql 9.4.4 on a windows 2008 rc2 machine that has 2 HDs. The first HD is, in theory, used only for executables/code/etc while the second one, being faster, should be used ...
2
votes
0answers
41 views

Disk setup for Windows 2008 R2 and SQL Server 2012 [closed]

I am wondering what would be the best disk/RAID setup for a Windows server 2008 R2 OS and SQL Server 2012 database that has heavy read/write. I have the following disks I can use: 4x 15k 146GB 2x ...
5
votes
0answers
34 views

Failover timeout problem

I'm looking for an additional bit of help with regard to some problems I'm looking at for one of my company's clients. Basically I have two related problems with regard to a 2-node active/active ...
1
vote
0answers
29 views

Quorum disk conundrum

I'm working on a problem for one of my company's clients where they are having a problem with their 2-node active-active cluster and which has been failing over lately but not bringing resources back ...
0
votes
1answer
303 views

pgAgent : how to configure pgpass.conf for a local connection on Windows Server 2008

I try to configure pgAgent on Windows server 2008 to make automatic backup on the database. pgAgent is installed on the server and the service is running normally. I use PgAdmin3 and PostgreSql 9.3 I ...
0
votes
1answer
189 views

Failed installation of SQL 2012 on Windows Server Core

I'm in the process of building the lab for 70-462 exam. On page 49 of the text, it provides the command to install SQL 2012 on Windows Server Core: Setup.exe /qs /Action=install ...
4
votes
2answers
2k views

I need the reason why we should not install SQL server on the domain controller

I am a system administrator for a small firm. Now we consider to rollout Windows Server 2008 R2 for the firm. We plan to implement Active Directory. We would also like to upgrade RDMS, from SQL server ...
0
votes
1answer
290 views

dbca cant remove database cleanly

when I ran dbca as administrator under windows server 2008R2 is used to delete the database completely ( database folder, control files, datafies, redo logs, then remove all related windows services ...
0
votes
1answer
129 views

MySQL Create Table with Partition Very Slow on server machine

Following create table statement with Partition runs in 10 Second on My Development Machine windows 7, i5 , 8GBRam, single disk runs in 16 Second on Virtual Machine windows server 2012 , xeon 2GHz , ...
1
vote
2answers
939 views

SQL Server Cumulative Updates - not visible in Windows Update

I just installed all possible Windows updates on WS2008R2/SQL2012 instance. When I run SELECT @@VERSION I get Microsoft SQL Server 2012 - 11.0.5058.0 (X64) May 14 2014 18:34:29 Copyright ...
0
votes
1answer
155 views

Add linked server from SQL-Server to MySQL: “Data source name not found” (Error:7303)

I'm trying to link my SQL-Server 2005 on Windows Server 2008 R2 with MySQL 5.5.40 on a different computer. I have followed this guide: ...
-1
votes
1answer
246 views

Debugging Remote Connection Failure of SQL Server 2012 [closed]

I am running SQL server 2012 web edition on Windows Server 2008 R2. I have followed all these steps http://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/. But still unable to ...
0
votes
1answer
68 views

Similar hardware, Same DBconfiguration and Database but different status variables result between Windows and Linux server [closed]

I have two database servers - one is Windows - 2008 and another is RHEL5 with similar hardware configuration. Both OS are 64 bit. MySQL 5.1.58 community edition is installed on Windows servers while ...
3
votes
1answer
169 views

Difference in space used

When reviewing the space used by datafiles in SQL Server, there is a large difference betweens what SQL reports and Windows. How can this be explained?
2
votes
2answers
204 views

How can I wipe all databases and users from a SQL Server database?

Okay, here is the story. I have a Windows 7 Ultimate box with a SQL Server 2008 R2 Standard installation that I inherited from a person who left the company long before I started at my company. No ...
2
votes
1answer
209 views

Perfmon and SQL Server Clustering

I'll be going onsite to run some performance tests for a client. They have a Windows Failover Cluster, which has a clustered instance of SQL Server. Let's assume for this post that my client's ...
1
vote
1answer
111 views

MySQL Server 5.6 wont start on Windows

I'm having an issue getting MySQL Server 5.6 (community edition) running. it was working just fine until I restarted my server. Now it wont start at all. after doing a bit of research, I discovered ...
1
vote
1answer
433 views

How to obtain SQL feature list from the command line

Is there a command at the CLI or in PowerShell that will list the components installed for SQL? I'm looking for something like the Feature List you can get from running the discovery report from ...
0
votes
0answers
120 views

Oracle Counters for Windows Performance Monitor exceeding handle quota

On several windows 2008 R2 servers with an oracle 11.2.0.3.0 database installation i see the following warning in the eventlog every couple of days: Windows Management Instrumentation has stopped ...
2
votes
1answer
361 views

Complete Failover Cluster Failure SQL Server 2012

We have experienced a full cluster failure on our 3 node cluster running SQL Server 2008 R2 with 7 SQL Server instances. It started when we rebooted one of the nodes and it returned an error: Node ...
1
vote
2answers
1k views

Proper Shutdown of SQL Servers in a Cluster

I was just wondering what the best approach should be for shutting down an Active/Active Cluster where both nodes need to be shutdown for disk maintenance. I was thinking of this process: Open ...
1
vote
0answers
37 views

Windows Clustering 2008 R2

I'm trying to build a Windows cluster with 3 nodes, 2 Active and 1 Passive, And If I have to build in a way like N1 Active - N3 Passive will be refer as "cluster network 1" and N2 Active and N3 ...
2
votes
1answer
453 views

Unable to run update_mysql in MySQL 5.5

I have recently taken over managing a MySQL database running on Windows Server 2008 R2 . It is running 5.5.37 Community Edition. When it is started, it includes the following lines: Thread, Type, ...
2
votes
1answer
5k views

Oracle program “lsnrctl” is missing after the installation of 32bit Oracle client

I cleaned up my computer for all old Oracle stuff using Uninstall (OUI) and then later used regedit to delete all references to Oracle and then deleted all remains of Oracle directories. I have HP ...
0
votes
1answer
203 views

Recurring Memory Issues

We have a Windows Server 2008R2 server with 32GB or RAM running SQL Server 2008R2, along with an IIS server. The machine is also used as a backup server. The problem is, periodically (every week or ...
0
votes
0answers
1k views

Installing SQL Server 2012 failed setup administrator

Can anyone tell me why this keeps failing? I am logged in as "Administrator" on Windows Server 2008 r2 I added Administrator to the "Backup ... " Group And I checked to make sure everything is as it ...
0
votes
2answers
67 views

SQL Server 2012 - cannot login

Just installed a single instance of SQL Server 2012. The instance name is called Example and the server is called WIN2K8R2. It's on a virtual machine and I am RDP'd into it. I'm trying to login with ...
3
votes
2answers
377 views

Running MongoDB and SQL Server on the same host- memory pressure

We have a new application that is making use of both traditional MS SQL and MongoDB for data storage. We're running both instances on the same Windows 2008R2 x64 machine, with 64GB RAM. There have ...
2
votes
0answers
67 views

Attaching Existing Oracle Home to fresh Windows Install

I have a client who recently was forced to reformat and reinstall Windows Server 2008 R2. Their ORACLE_HOME (Oracle 11g) and all of the data was located on a D: drive that was not reformatted. Can I ...
2
votes
2answers
2k views

SQL Agent - PowerShell step “syntax error”

I have the following code setup in SQL Agent Job step that is not running. The message received is simply: Unable to start execution of step 1 (reason: line(46): Syntax error). The step failed. ...
2
votes
1answer
2k views

Can't restore my distribution DB postgres 9.2 backup into my staging DB postgres 9.3

I keep getting this pg_restore: [archiver] did not find magic string in file header when i execute a pg_restore -Fc -U "username" -d "dbname" "filename".dmpon my staging DB. These DB are running on ...