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)

0
votes
3answers
6k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
1
vote
2answers
66 views

SQL server structure refactoring

Often in my c# code, I can change the name of a variable, and all references to it will change as well. Is there a similar feature that allows me to do this with objects in SQL servers? Some of my ...
3
votes
1answer
347 views

RDS 2012R2: RD Connection Broker HA - cannot connect to SQL

I have a brand new RDS environment I am trying to set up. I'm trying to follow this guide: https://msfreaks.wordpress.com/2013/12/09/windows-2012-r2-remote-desktop-services-part-1/ and have gotten ...
1
vote
1answer
39 views

SQL Server Full BackUP functionality

In SQL Server 2008 R2 (or Any other Version); Transaction-1 had started at 11:50:00 and it takes 1hr.5min to complete(i.e., completed at 12:55:00) and Transaction-2 had started at 17:45:00 and it ...
1
vote
2answers
528 views

How do I use a domain account to connect to a MSSQL server for NPS accounting?

I'm trying to connect a Server 2008 R2 NPS to a MSSQL server for logging accounting data and I'm running into issues. I configured NPS Accounting through the "Configure Accounting" wizard and, using ...
0
votes
0answers
63 views

Block Windows Service Access to Remote SQL Server with Firewall

So I've got a fun firewall question. We have a windows service that we have running on a Windows Server 2012 instance. It is connecting to a remote SQL Server that we do not own, among other things. ...
1
vote
1answer
127 views

Configured Azure Backup sends me a health check report every 15 minutes

I configured my SQL Server 2014 database to back up to an Azure storage account. I also enabled email notifications via EXEC msdb.smart_admin.sp_set_parameter @parameter_name = '...
0
votes
1answer
18 views

SQL Server data and log file location on single physical drive

I have just got my hands on a dedicated hosted Windows Server 2012 R2 which has had SQL Server 2014 installed. The server has a single 2Tb drive (C:) which I assume is a standard hard-drive, rather ...
-2
votes
1answer
51 views

SQL Server Backup Procedure and different types of backup [closed]

Need to know perfect solution on how to backup SQL server Database Version SQL server 2008 R2.
0
votes
1answer
88 views

Install WSUS with remote SQL on port different to default

How do I specify the connection parameter to a remote MSSQL Server during WSUS setup that's default instance is not running on the default port?
0
votes
1answer
144 views

SQL Server 2014 “Relocate all files to folder” option

In SQL Server while restoring database .bak file are are two option "Relocate all files to folder" and "Restore As". I can change the location of database using "Restore As" option, what is the ...
1
vote
2answers
259 views

SQL Server Error: Failed Assertion = ‘m_iteratorInSafeState’

We have a client running our .NET application which connects to SQL Server 2005 on the backend. A few weeks ago the database crashed and the whole server had to be rebooted. This happened again today ...
4
votes
1answer
36 views

Back up a database nightly

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ...
6
votes
1answer
184 views

DL380 Gen9 which processor and what impact on NUMA

We are about to build a new server and I was wondering what would the impact on NUMA with the options available. The system will be built using a Proliant DL380 Gen9 8SFF which has 2 sockets, and 12 ...
2
votes
5answers
14k views

Error when restoring database (Windows 7 test environment)

I have a windows 7 operating system as a test environment. I have SQL Server EE installed with two instances, named as test and production. I took a full backup from AdventureWorks database from test ...
0
votes
1answer
101 views

How to fix a slow connection between web to sql

I use Microsoft SQL Server, my web server is IIS When the database server was on the same network as the web server, it worked very good. Now that the web server is in one network in one city and ...
39
votes
7answers
32k views

Is it safe to have SQL Server auto-shrink turned on?

There are many SQL Server options that can be enabled for databases, and one of the most misunderstood ones is auto-shrink. Is it safe? If not, why not?
0
votes
2answers
853 views

SQL Server in “Recovery Pending” status after reboot

We have quite a few programs of our own design which communicate to our SQL Server (SQL Server 2014 Express). Every now and then they start blowing up all over the place; we run around trying to ...
6
votes
2answers
1k views

Listing pending reboots in windows

I'm trying to install SQL Server 2008 on a Windows Server 2008 x86 system, and I'm getting an error saying "Rule 'Restart computer' failed." I've already found a lot of people saying to clear the ...
0
votes
0answers
8 views

error configuration HTTP connect to analysis services

I want to connect to cube using HTTP/ internet outside. I already set up : copy Folder OLAP in inetpub/wwwroot Added Aplication pool in IIS Added website with application pool i just created enable ...
0
votes
1answer
109 views

multi instance failover clustering (sql server)

just want to straighten my concept properly - when we are talking about SQL multi instance failover cluster, e.g. on a 2 node cluster, it means that each node can run its own sql instance, but each ...
21
votes
4answers
33k views

Database 'XXX' is in transition. Try the statement later

im trying to connect to a sql server database i get this error Database 'XXX' is in transition. Try the statement later. i cancelled a long query earlier today but for some reason i can't get the ...
1
vote
2answers
102 views

What is the risk of a SQL Server backup strategy that is only weekly full backups and daily transaction log backups?

I'm trying to convince a client that their SQL Server backup strategy is insufficient. Long story short is that their current backup "strategy" is a weekly full backup followed by daily transaction ...
0
votes
1answer
1k views

Failing SQL Server Cluster installation, Addnode: Remote registry call failed

I'm adding a node to a SQL Server failover cluster. The installer throws the error "Addnode: Remote registry call failed. Unable to retrieve primary node Filestream settings" when adding node two ...
6
votes
4answers
17k views

Is there a way to run sqlcmd to get query output without showing the number of rows affected?

I am running a simple query in SQL Server 2005 and want it to export to a file via sqlcmd. I was hoping to get the results in a csv format without the headers and the query metadata (how many rows ...
3
votes
2answers
19k views

Permission error during installation of Microsoft SQL Server 2008 R2

During setup I get several errors like the one bellow and none of the service for SQL server get installed. I did quick google search but it seems like the only solution for resolving this issue is re-...
3
votes
1answer
38 views

OK to disable TLS1.0 with IIS and SQL Server 2014?

(This identical question in dba is drawing a blank) Background We need PCI-DSS compliance, and so must disable TLS1.0. In my test environment we have SQL Server 2014 SP1 with CU 1 (as per this post) ...
2
votes
3answers
1k views

What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0

I'm trying to decide whether this performance counter is worthwhile monitoring: \\SERVER\MSSQL:Transactions\Longest Transaction Running Time. So during testing I tried to create some long running ...
0
votes
1answer
190 views

XA transaction timeouts with SQL Server, MSDTC, and WebSphere

I have a Java/WebSphere application that is doing XA transactions with a SQL Server 2008 instance. In some environments, everything works as expected. In two of our environments, transactions will ...
0
votes
2answers
85 views

Unable to start SQL server agent automatically

I am working on SQL 2012, I already been set up my SQL server agent in automatic start up mode in windows services as well in SQL config. Even though it was not starting automatically. How can I fix ...
3
votes
1answer
5k views

ASP.NET MVC incorrect connection string when connecting to mssql server

I built my website on ASP.NET MVC4 using mssql database, I deployed it on my local IIS 7 server and it works fine, but when I do to the exactly the same thing on virtual server hostgator.com it throws ...
8
votes
4answers
20k views

mdf file cannot be overwritten when restoring a database in SQL Server

I got a databse A. It has some data in it. I created a backup for A as A.bak file. Then I create a new empty database B. And then I try to restore B from A.bak. But the SQL Serve tell me the following ...
-2
votes
4answers
14k views

How to make SQL Server visible on internet? [closed]

This is embarrassing for me, but I have no idea what to do. I want to connect to SQL server from my home and field office; what else should I tweak? I could use VPN (it works), but I* prefer to ...
0
votes
1answer
160 views

Best Way to Restart 2 Node SQL Cluster To Perform Windows Updates?

So I have a 2 node MS SQL Server cluster, using AlwaysOn, on Windows 2012 r2. SQL1 is the primary. SQL2 is the secondary. I want to restart both servers today to perform windows updates which will ...
0
votes
0answers
21 views

Is there Equivilent of SQL Server 2012 Distributed Replay for SQL Azure?

I have a client that wants to replay their daily work load in a SQL Azure environment to test it's performance against their current environment. Does anyone know a product or process I could use to ...
1
vote
2answers
117 views

TFS DB and Recovery Model. Is Simple Safe

On my TFS database server all the databases are set to Full Recovery Model. We don't do any log shipping and just do full db backups each night so would there be any impact to TFS is we changed our ...
-1
votes
1answer
22 views

SQL Server Failover Clustering (4 nodes)

I think I was able to convince my cow-erkers that jamming all the databases on one server is a good idea. So, our setup will be something like this: Production - SQL 2014 Enterprise Standby - SQL ...
0
votes
0answers
37 views

Establishing performance baseline with SCOM 2012 APM

We're lookign at establishing a performance baseline for our production environment. This could be as simple as establishing highest measured TPS for MS SQL environment and highest measured RPS for ...
0
votes
1answer
22 views

SQL Server: One Production server be Failover for other

I'm surely using the wrong terminology, but I have the following: SQL Server A (SAN1) - DB1, DB2, DB3 SQL Server B (SAN2) - DB4, DB5, DB6 It's currently SQL 2008 and we're looking to move to SQL ...
0
votes
1answer
59 views

SQL Server login for other domain user with the same name

Due to some circumstances I had to dis-join from the domain Windows Server 2012 R2 based machine with SQL Server 2014 Business Intelligence Edition installed . Let's call it 'mydomain.local'. Then I ...
-1
votes
1answer
44 views

Sync two Non-Enterprise SQL Servers [closed]

We have a SQL Server 2005 in one of our company's locations. Since DB calls from other locations are very slow, we would like to set up another SQL Server on the other location and keep the server ...
35
votes
6answers
44k views

SQL Server (2005/2008): Does full backup truncate the log in full recovery mode

I've just read through a lot of MSDN documentation and I think I understand the different recovery models and the concept of a backup chain. I still have one question: Does a full database backup ...
0
votes
3answers
59 views

Changes to data ordering between SQL Server 2000 and 2012

My company recently migrated a .NET 1.1/SQL Server 2000 web application to SQL Server 2012. We've had a couple of support calls relating to unusual behaviour - particularly with stored procedure ...
1
vote
1answer
37 views

Failing over to mirror instance when not using a witness server

I have a set up where I have two SQL servers set up for failover mirroring to two other SQL servers. I am not using a witness server. I had previously used a witness server and that of course would ...
3
votes
1answer
41 views

Finding SQL Server Bottleneck - not CPU, IO, available memory

I'm trying to identify the bottleneck on a new SQL Server implementation (2012 Enterprise). I've been running some meaty queries/ETL jobs which are taking a considerable time - but I'm having ...
0
votes
1answer
133 views

SQL Server, local instance, No process is on the other end of the pipe

On a fresh installation, on my local SQL server instance, using SQL Server Management Studio, I can login with my Windows authentication, but not with my sa user. In both cases, I'm using (local) as ...
2
votes
3answers
3k views

Database Mirroring Properties Page Missing

I am having a problem with one database on my SQL Server 2005 production server. A number of databases are already set up for mirroring, however when I right click and go to properties in SSMS, on ...
1
vote
2answers
795 views

SQL 2014: Add Table gives “The requested operation cannot be completed. The computer must be trusted”

A single user is not able to "Add Table" to a database that he (or anyone else) created. Other users can add tables. We have checked permissions and they are the same - but obviously we've missed ...
1
vote
2answers
319 views

SQL Server read-only user can connect local but not remotely

I have a SQL Server where admin users can connect locally and remotely, but read only users can only connect locally and get a "Login failed" error when connecting remotely. It's using SQL Server ...
2
votes
2answers
533 views

KVM top shows high CPU load on host for windows7 guest though windows is on idle

we have an virtualization environment with actually 4 VMs (2 x linux, 1 x w2k3, 1 x win7). In the host system (Debian Jessie) top always shows a CPU load of 30-70% (or more) for the qemu process of ...