Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

learn more… | top users | synonyms (3)

7
votes
1answer
1k views

SQL Server Installer Update Cache management

Is it safe to delete the old cumulative update directories from the %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Update Cache folders? At least this MSDN blog post tells to leave anything ...
6
votes
1answer
556 views

Database Backup and Full-Text Search

I am running SQL Server 2005 EE. When trying to perform a full database backup I receive the error message: Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating ...
4
votes
1answer
2k views

Get-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps'

I've tried reinstalling SQL Server 2014 and I'm still getting the following error message when trying to import-module sqlps. The same registry key exists, but is appended with 120. I'm able to use ...
4
votes
1answer
707 views

Distributed and/or Parallel SSIS processing

Background: Our company hosts SaaS DSS applications, where clients provide us data Daily and/or Weekly, which we process & merge into their existing database. During business hours, load in the ...
3
votes
1answer
98 views

Change SQL Server user SID

I have SQL Server 2012 and I am using domain users (from Active Directory). By mistake users were deleted from AD, created new with identical logins and passwords (but with different SIDs), deleted ...
0
votes
0answers
148 views

What does the sqldumper_errorlog file contain?

The SQL Server error logs are continually showing (along with many more messages) BEGIN STACK DUMP. * User initiated stack dump. This is not a server exception dump. Followed by External dump process ...
0
votes
0answers
56 views

MSSQL - Can Maintenance Plan wait for Agent Job Task to be completed?

I did start a Maintenance Plan project with Execute SQL Server Agent Job Task box. I added another task on success event. I realized that I was wrong. The second task is executed in parallel, because ...
0
votes
0answers
139 views

SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for User

I am trying to get SQL 2012 AlwaysOn Availability Groups working for an application. The cluster has 2 SQL nodes and 1 witness server. Everything appears to be failing over successfully when I do ...
0
votes
0answers
301 views

Repairing corrupt MS SQL master database - no SQL client access

Apologies for any duplication but I feel like I'm falling at the first hurdle. I have a MS SQL 2005 Server which is refusing to start and for which I don't have a password (including the 'sa' ...
0
votes
0answers
52 views

MSSQL 2005 - Server Service unable to start while installing

I am trying to install MSSQL 2005 Express on an VM running Windows Server 2012. I get to the point where it installs everything but fails to start the service. I have tried checking the Log-On ...
0
votes
0answers
155 views

How do I migrate a database between servers from SQL 2008 Std to SQL 2014 Std using T-SQL without losing data?

What is the process using T-SQL to copy/move/relocate a database from one server to another? Do I need to take a log backup on the source as well and restore it on the new server? I am pretty sure ...
0
votes
0answers
220 views

Single node SQL Server 2014 cluster at DR environment

We are setting up a new Disaster Recovery environment. On Production we have SQL Server cluster with two nodes. For DR we decided that one node should be enough. The plan is to add the second node ...
0
votes
0answers
705 views

SQL server session tasks all waiting

I have a query that often completes in a fraction of a second (~200ms). Sometimes it takes 10-13 seconds to complete. Doing SET STATISTICS TIME ON it shows: SQL Server Execution Times: CPU time = ...
0
votes
0answers
63 views

Is it possible to create my own custom SQL 'trigger' with Powershell?

I'm familiar with MSSQL triggers already, however they aren't fine grained enough for what I want to do. In my scenario I want the trigger to fire after a row containing certain information lands in ...
0
votes
0answers
216 views

Route sql server traffic through firewall

We currently host our web application on multiple servers using Rackspace Auto Scale. This causes our outbound IP addresses to regularly change. At the same time we need to connect to an external sql ...
0
votes
0answers
144 views

SQL Server service dependency not working

I have an service that tries to connect to a MSSQL DB on startup, but when I start the computer it throws an error becouse it's not able to connect to the DB. This happens becouse the specific DB was ...
0
votes
0answers
392 views

How to execute unicode .sql file on azure sql via sqlcmd?

I have an Azure blog created via "Brandoo WordPress" template (wordpress website and azure sql server). All works fine, but if I populate wordpress tables from .sql file with unicode characters via ...
0
votes
0answers
152 views

EMC AVAMAR Compatibility with SQL Server 2008 R2 in Active/Passive Clustered Mode

We are currently using EMC AVAMAR as part of our backup policy for backing up all our servers. We also have a SQL Server 2008 R2 active/passive setup. Does anyone know if EMC AVAMAR is compatible in ...
0
votes
0answers
67 views

SQL Server Witness Server Alternative Approach

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
0
votes
0answers
34 views

Password change to SQL user and SQL Agent user broke mail agent

We changed the passwords on the accounts which the SQL Server service and the SQL Server Agent use to log in. Both seem to be mostly working fine, however the mail agent is now having problems. It is ...
0
votes
0answers
312 views

Migrating SQL Server 2000 from Physical to Virtual

My team will be tasked with a Physical-to-Virtual migration of SQL Server 2000. The main requirement will be: Minimization of downtime and minimization of impact on operation. The action plan is as ...
0
votes
0answers
34 views

MSSQL High Availability Advice Required

I'm looking to implement a high availability SQL installation using MSSQL2012 or 2014 and there is 1 part of this I'm not sure about. I plan to have a SQL cluster at site a, and a secondary SQL ...
0
votes
0answers
34 views

SQL Server 2000: Monitor replication

starting with (Microsoft) SQL Server 2005, there are stored procedures available to monitor replication (http://www.g-productions.nl/index.php?name=sp_replmonitorhelppublication) But as we are a bit ...
0
votes
0answers
78 views

SQL Server 2014 Standard 2014 no access and bad preformance

My company looks after a server which is running SQL Server 2014 Standard Edition. The main application database on the server is replicated out to about 20 subscribers. The server has only been in ...
0
votes
0answers
128 views

Network Issues Connection to SQL database on MS server

Prior to asking this question, I followed this thread: Cannot telnet to SQL Server on port 1433 I am attempting to connect to a database on a server distinct from the computer upon which I am ...
0
votes
0answers
289 views

Powershell Get-Counter not returning values for SQL counters

This is a cross-post from dba.stackexchange.com: http://dba.stackexchange.com/questions/64898/powershell-get-counter-not-returning-values-for-sql-counters I am attempting to use PowerShell to get ...
0
votes
0answers
983 views

How do you RESET the SQL Server 2008 TCP/IP Protocol settings back to default?

We have a SQL Server with multiple interfaces and a previous admin wanted to enable TCP/IP protocol to listen on a specific port. I believe that wherever he saw a specific IP address, he replaced it ...
0
votes
0answers
1k views

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, ...
0
votes
0answers
167 views

Running MS SQL Server DB for Ubuntu PHP site

I'm going to be developing a php site (actually more of a application), but the standards and restriction of what I'm building make MS SQL Server the most appropriate DB solution (will also be running ...
0
votes
0answers
373 views

sql server, group by then count, 25 million rows per month, feasibility

So. We are doing some analytics in a scale I have no experience with. We have to extract some aggregate numbers and data from a whole bunch of server logs. (Estimated at 2gig a month total). I'm ...
0
votes
0answers
41 views

Can't Find SQL Server 2008 R2 SP2 uninstall option

Supposedly, the method to uninstall a service pack to SQL Server 2008 R2 (and other versions after a certain point) is through Control Panel > Programs and Features. I think it's supposed to be ...
0
votes
0answers
294 views

SQL database instance cannot be set to SINGLE_USER

I am trying to make my database Single User Mode and I tried executing this: ALTER DATABASE [db] SET SINGLE_USER WITH NO_WAIT and it returned: Option 'SINGLE_USER' cannot be set in database 'master'...
0
votes
0answers
1k views

SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component

I have a huge 200MB .SQL file. When I try to open this in SQL server management studio 2008, I get the error -Error HRESULT E_FAIL has been returned from a call to a COM component. What could the ...
0
votes
0answers
142 views

Mail to Mailenable group sometimes bounces back because it cannot find one of the group members

I am using MailEnable Enterprise Edition 6.53. On one of my PostOffices I have a group address set up with 5 members in the group. Under normal circumstances when someone sends a mail to this group ...
0
votes
0answers
331 views

After installing MS SQL Server 2012 not able to log into SSMS

Okay, lot's of posts around the internet on this subject. But I haven't been able to find an answer I was looking for. I installed SQLS 2012 on Windows Server 2012. I installed the Engine and the ...
0
votes
0answers
770 views

Backup Exec 2012 not backing up SQL logs

I am unable to make BUE 2012 backup (and truncate) the SQL Logs from our Microsoft SQL 2005 and SQL 2008 database servers that are set to FULL mode. No errors are being reported, but the Transaction ...
0
votes
0answers
345 views

A connection was successfully established with the server, but then an error occurred during the pre-login handshake

While i was logged in SQL server following error was occurred : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (Provider: SSL ...
0
votes
0answers
943 views

Event ID 5586 on SP Foundation and SQL Express

I have a brand new Hyper-V VM with Windows 2012, fully updated up to today (11 Sept 2013). I installed SharePoint Foundation 2013 and additionally MS SQL Express 2012 on the same instance. In my ...
0
votes
0answers
488 views

Unable to launch SQL Server Configuration Manager - WMI provider issue

Hoping you can help. I am having issues opening SQL Server Configuration Manager on Server 2k3 with the following error: Cannot connect to WMI provider. You do not have permission or the server is ...
0
votes
0answers
114 views

Errors after moving DB from server

I am moving a database (MS SQL Server) from a server to a new one (virtual machine). Running CHECKDB on the original server I get no errors, the DB is OK. After moving the DB to the new server and ...
0
votes
0answers
374 views

SQL Server Cannot see tables in Object Browser where Login = db_owner

A colleague is trying access a particular SQL Server over a remote link. He can login to the server (via SSMS) with the SQL Server credentials I supplied, but although he can view tables/etc in the ...
0
votes
0answers
165 views

Identical tables, different sizes?

I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express). I need to add another subscriber, and come to ...
0
votes
0answers
47 views

Inserted 3k rows into MsSql, now querying them times out

I have a table which had about 4k rows, then I inserted 3k rows from another table into it. The import have caused me problems, querying for new data never seems to finish. And I cannot figure out how ...
0
votes
0answers
323 views

Can't select database for transaction log backup in maintenance plan

I am running into a problem while trying to save a transaction log database backup maintenance task: Add the 'Back Up Database Task' to the maintenance plan. Edit the task. Select backup type: '...
0
votes
0answers
29 views

SQL server Error

I am trying to load the data from text file to database table by running a job. Sometimes its giving an error like "Failed at split file".. Can anybody suggest on this how to overcome this error.
0
votes
0answers
415 views

to overwrite a table or update it?

I've had situations where there was a large feed I was taking in that basically overwrote a table in the db. This tabled information was queried a lot. If Sql Server uses memory to store the queried ...
0
votes
0answers
71 views

AppFabric vs AD LDS

I'm helping design a solution for a huge organization which relies on a SQL cluster. If this cluster is unavailable, the entire organization will not be able to authenticate to printers. there are ...
0
votes
0answers
538 views

Getting “error: 26 - Error Locating Server/Instance Specified” all of a sudden

Alright, a little explanation. I have two separate PCs, both of which have virtually an identical installation of SQL Server 2012 Express on them. During installation for both, I had chosen the ...
0
votes
0answers
94 views

Moving WSUS Content - Issue with SQL Server

Im trying to gain some space on the main partition on the C:\ drive of a Win 2008r2 SBS server. Im following this guide . However, after detaching the Db ,moving it to the new partition E:\ i can't ...
-1
votes
0answers
21 views

How can I tell if there is a prepared SQL Server install on a machine using PowerShell?

How can I check in PowerShell if the SQL Server install on a machine is just a prepared install (done before a sysprep) or a full ready to go instance?