Questions tagged [sql-server]

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.

The tag is for general questions related to Microsoft SQL Server and its various technologies. SQL Server is a very broad topic, much of which is perfectly suited for serverfault. SQL Server programming questions involving code, however, will be generally be better suited for stackoverflow.

If you have a SQL Server question, ask yourself the following questions to determine the best site:

  • Is the goal of my question to solve a SQL Server system administration (DBA) function? If not, then it's a good bet you should head on over to stackoverflow https://stackoverflow.com/ or superuser https://superuser.com/

  • Who would use the code that my question relates to the most, a developer or a DBA? If a developer, stackoverflow is your place. If a DBA, ask away here.

For information on how to handle installation errors related to the system language versus the installation media language, see SQL Server setup media does not support the language.

4775 questions
2
votes
2 answers

backing up sql server logs to external USB drive

Let me start off by saying that I am a SQL Server newbe so please be nice. Background: I have inherited a project which requires a database export. I quickly found out that the log files have never been backed-up and therefore has grown to over 37…
Brian S
  • 21
  • 1
2
votes
7 answers

Nagios - host inherit from multiple templates?

Is it possible to have a host in Nagios use multiple templates? I'm trying to monitor some MSSQL servers. Some of these are standalone single servers with a single instance, and others are using MSCS to form 2-node HA clusters. The things I want to…
growse
  • 8,020
  • 13
  • 74
  • 115
2
votes
2 answers

Distributed File System (DFS) and MS SQL 2008

There are two physical servers on which we want to install MS SQL 2008 and our application. Our application is using DB in separate *.mdf file. Our application works only on one server at the point of time. Can we create this file (*.mdf) on the…
Sasha
  • 229
  • 2
  • 5
  • 12
2
votes
2 answers

SQL Server database with two log files

SQL Server 2008 Enterprise I have inherited a SQL database that has been configured to use two transaction log files. I'd like to just get rid of one of the log files, because it's really not best practice and just creates additional maintenance…
EkoostikMartin
  • 208
  • 2
  • 7
2
votes
4 answers

To DMZ or not-DMZ on new web site

We are about to release a web application for our users, and are trying to figure out if others put their servers in a DMZ, or just keep it off the domain behind the firewall and greatly restrict access via firewall rules? Has anyone here found any…
Beep beep
  • 1,833
  • 2
  • 18
  • 33
2
votes
3 answers

Why does SQL Server Uninstaller not uninstall everything?

This could me just me not understanding how this is done but I find it infuriating that I can install SQL Server Express from a single executable file that dumps all this stuff like SQL Publishing Wizard and SQL Compact and TSQL this and that... But…
2
votes
4 answers

Creating a copy of a large database

I want to make a copy of a largish SQL 2008 database (1TB). I only have 1.9TB of disk space free so I don't have enough to create a backup of the database and restore it into another. Are there any other techniques I can use? How to I do it quickly…
Dan
  • 143
  • 2
  • 10
2
votes
3 answers

Replication or?

Recently, we have been hammered by Google Bots and all kinds of other bots( 60% of the website traffic that we experience on an average are from Bots. We are trying to segment out the Google Bot Traffic to a different server (low cost server).…
2
votes
4 answers

Copy a SQL Server DB to an external HD

I found a lot of similar questions in the archives, but none quite answered this. I need to copy a database from one server (SQL Server 2008) to another. Each server is in its own system, and no computer can connect to both servers. My original…
Geoff
  • 21
  • 1
  • 2
2
votes
1 answer

How to extract data from an MSDE .dat backup file

A client wants me to extract customer data from his old system The application he was using appears to have used MSDE as the database and its backups have the extension .dat SSMS express edition or Access do not appear to have a way to import data…
jjb
2
votes
1 answer

SQL Data Recovery and Merger

I had my principal database in a SQL server that was scheduled to back up at 9 AM and 3 PM. A second server contained these backups in case of failure. The main server went down yesterday at about 2 AM, and the most recent backup was at 3 PM the…
2
votes
1 answer

How can I setup scripts to run as period maintenance against my SQL Server?

I need to be able to run maintenance scripts against my SQL server to expire records and generally clean up the database. Is this best accomplished with some sort of trigger or something within the database itself? I'd like to run the script daily…
Jordan
  • 163
  • 1
  • 4
2
votes
0 answers

Visual Studio giving Microsoft SQL Server Compact 4.0 error when trying to perform any database operation

"An unexpected error occurred in the .NET Framework Data Provider for Microsoft SQL Server Compact 4.0. Please contact the provider vendor to resolve this problem." is the actual error message. I am not sure when this error started but I have…
RBZ
  • 165
  • 1
  • 7
2
votes
1 answer

Repairing Dynamics CRM 2011 Server

As stated above, I had a bit of an issue with my CRM 2011 server last week. I run a small computer repair company and use it to manage my clients. I was running the server in a VirtualBox VM and the host hard drive ran out of space. My original…
2
votes
1 answer

Implementing Automatic failover with SQL Server 2008 R2 Web Edition

I am trying to implement automatic failover for an ASP.NET MVC website running on Windows 2008 R2 Web Edition / SQL Server 2008 R2 Web Edition. I know that this is not supported out of the box, but I have to make do with the software licenses which…