Server Fault Stack Exchange
Server Fault Stack Exchange

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

SQL 2000 - WAITSTATS: CXPACKET query

Platform: SQL 2000 Enterprise with SP4, running on Windows 2003 Enterprise, 8 cores, 8GB RAM, and internal (!) storage. Databases are roughly 100GB in total. Scenario: The waitstats are heavily skewed to hardware: CXPACKET - 35.9% WRITELOG -…
user3914
2
votes
1 answer

SQL Server 2008: Is it possible to store differential backups in a separate files?

We're moving some of our applications to a new hosting provider and we want to make it seamless for our users. Nonetheless, we have big databases and we've got to move about 48GB of data. Our proposal -if it's possible- is taking full backups of our…
SDReyes
  • 653
  • 2
  • 8
  • 15
2
votes
2 answers

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database mirroring fails over. I'm curious as to what…
Paul Randal
  • 7,194
  • 1
  • 36
  • 45
2
votes
1 answer

SQL Server full upgrade

our current SQL server is on windows 2003 32bit hence we have planned to rebuild the server from scratch in 64bit, however we have got about 200 databases running in the server so i may have to backup everything at ones and restore them after the…
New IT Manager
  • 88
  • 1
  • 5
2
votes
2 answers

Multiple SQL Server unique indexes with different includes

In SQL Server, suppose I have a very large table (columns A through Z) which has a CLUSTERED PRIMARY KEY on A and a UNIQUE NONCLUSTERED index IX1 over columns B,C,D include E,F,G. I then need to cover another query with a new NONCLUSTERED index IX2…
CraigN
  • 194
  • 9
2
votes
2 answers

Does MSSQL 2000 run in VMWare ESX?

Does MSSQL 2000 run in VMware ESX? We are planning on going into a virtualized environment and are wondering if main production database will run in VMware ESX. We cannot upgrade the SQL version.
Kratz
  • 323
  • 2
  • 7
2
votes
1 answer

Microsoft SQL alternative for Oracle's Imp and Exp command

I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp and exp commands of Oracle databases. Any suggestions?
ferdyh
  • 183
  • 10
2
votes
1 answer

Sql Server 2008 high availability in EC2

I'm currently evaluating a strategy that will enable high availability with SQL Server 2008 and redundant servers to limit DB downtime. My thought right now is to setup SQL server 2008 mirroring in high safety mode so two machines will be perfectly…
user596162
2
votes
1 answer

SQL server start-up bringing online database priority

we have hundreds of databases on one sql server instance. After restart sql server takes databases online one by one using default order from sys.databases view. This order use database_id, so first created database in sql server startups first(as I…
Alexey Smolyakov
  • 113
  • 3
2
votes
1 answer

Can't Access Database when Logged in As SA

We are using mixed mode authentication. I can see and qbe uery all of the databases on the server except for one. I am logged in as the SA account. One database does not expand in SSMS when I attempt to look at it and I get the error: "The…
John Azzolina
  • 23
  • 1
  • 4
2
votes
2 answers

With MS SQL Server mirroring, are indexes part of what is mirrored?

When using MS SQL mirroring, changed rows on the principal are pushed to the mirror. What I imagine/guess is that the data itself is pushed over, but not indexes. (I imagine this because I think of indexes as a secondary entity that exists to…
Greg Hendershott
  • 816
  • 1
  • 8
  • 12
2
votes
1 answer

SQL Server on EC2: What way do i set up the EBS

Good morning. We have a service with a SQL box on Amazon EC2 and, as suggested on this question, we are using EBS to store the data... the problem is, What is the best way to setup the storage? At the moment, during the Development phase, we have 4…
TiernanO
  • 744
  • 7
  • 17
2
votes
1 answer

Is an SQL Server (Express 2008 R2) database operational during backup? How about consistency?

I am expecting to have a long backup on a certain database and I was wondering if the application can access (read only? read/write?) it while it is being backed up. If read/write access would be available then how will consistency be achieved?…
Andrei Rînea
  • 310
  • 5
  • 17
2
votes
2 answers

How do you setup a SQL 2005 cluster in amazon EC2?

I am trying to setup a highly-available DB architecture in an EC2 servers. We are forced to use SQL 2005 for now. What kind of solutions would work in this context? Has anyone done it? I can't find a way to setup an active - active cluster in AWS.…
Jorge Guzman
  • 337
  • 2
  • 4
  • 14
2
votes
1 answer

Sql Server 2008 databases randomly go in and out of (In Recovery) mode

We have an instance of Sql Server 2008 (Express) that holds our in-progress and production databases for our company. If I had to guess, there is probably 65-70 databases on the server. Some are fairly high use, others are very low/no use. We've…
Sharbel
  • 85
  • 8
1 2 3
…
99 100