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
3 answers

Sql Server 2005 cluster - unable to rename to old server name

We have a sql 2005 cluster on W2K8 cluster. It is a named instance say SRV1\A. Then I built a new W2K8 (with a diff cluster service name) but the same service account. Then I installed a new sql 2005 cluster say SRV2\A. Now when I bring down the sql…
Paul2020
2
votes
2 answers

How much memory to allocate to sql server

I have SQL Server inside an ESX VM... the server has 32GB Ram. Right now, I've given it 4GB of Ram because I had some to spare. How do I know how much memory I should throw at SQL Server (since it takes all it can get at bootup) and if moving to 64…
user45006
  • 23
  • 2
2
votes
2 answers

Moving SQL 2000 to new hardware and O/S. How to copy everything

We're replacing our Windows NT server running SQL 2000 with newer hardware running Windows Server 2003 but still SQL 2000. What is the easiest way to do this? We know how to copy the normal databases etc either by backup and restore or moving and…
tetranz
  • 315
  • 2
  • 6
  • 14
2
votes
4 answers

SQL server failover clustering

How many failover clustered nodes can you have?, and if you add more and more nodes, is it going to slow down?
001
  • 491
  • 1
  • 11
  • 21
2
votes
1 answer

How can I get the bak file and most recent diff file for every database on my SQL Server?

I need to restore about 1000 backups with the latest diff (for about 1000 databases). Some data was deleted last night in one column of a table. So I need to run a script on each restored vs current database to repair the data loss. I know how to…
Bill Paetzke
  • 855
  • 4
  • 12
  • 19
2
votes
3 answers

SQL Server 2008 Database 250GB on a 250GB drive

Started a new job and there is a 2008 sql database that is 250gb in size. The developers insist that the size is about right. THe problem is that the 250gb MDF file is sitting on a 250GB drive. I have tried to do a backup of the database but i get…
Skeep
  • 165
  • 1
  • 6
2
votes
1 answer

Generating my own SQL Server SSL Certificate

I hear it's possible to make myself a test certificate with MakeCert from Windows SDK, but the beast is 1.5 GB, which I feel reluctant to download for a half-megabyte program. I do, however, have IIS Resource kit with me, which has selfssl to…
Haoest
  • 189
  • 1
  • 6
2
votes
2 answers

SQL database testing: How to capture state of my database for rollback

I have a SQL server (MS SQL 2005) in my development environment. I have a suite of unit tests for some .net code that will connect to the database and perform some operations. If the code under test works correctly, then the database should be in…
Vivian River
  • 359
  • 4
  • 10
2
votes
1 answer

How to rename database without first stopping SQL instance to flush connections

Is there a way to force a database into single user mode so a script can be run to rename databases? I find I have to Restart the instance of SQL (to force off any connections from a web app, etc.) and then I can run this script: USE…
DaniellaMercuryFan
  • 249
  • 1
  • 8
  • 17
2
votes
3 answers

What would be the optimal disk config for SQL Server 2008 R2?

We have a new Dell R710 server that came with the following storage configuration: 8 x 146GB SAS 10k 6Gbps disks 1 x Perc H700 Integrated Controller (2 x 4 disks - 2 ports each supporting 4 disks) What would be the optimal configuration if we were…
Kev
  • 7,877
  • 18
  • 81
  • 108
2
votes
3 answers

Managing SQL Server users via Active directory groups

I'm building SQL Server instance for reporting purposes. My plan is to use AD groups for server and database logins. I have several groups with different roles (admin, developer, user etc.), and I would like to map these roles into SQL Server…
hyty
  • 431
  • 1
  • 5
  • 6
2
votes
2 answers

SQL Server 2005 Patch Corrupts SQL Installation on Windows 2003 Standard x64

We're in a holding pattern on this one right now, but I thought I'd poll folks for some added info in case this has happened to anyone else. We have 2 SQL 2005 Enterprise servers on Win2K3 Std x64. We installed the MS08-040 patch last year and it…
squillman
  • 37,883
  • 12
  • 92
  • 146
2
votes
4 answers

Tune SQL Server Express using Profiler?

I have a SQL Server 2005 database... a copy of it is running in development on a full version of SQL server. Another copy is running in SQL Server 2005 Express on a web server. I've used SQL Profiler and saved a Tuning trace log from activity on the…
Glen Little
  • 455
  • 3
  • 7
  • 17
2
votes
4 answers

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 tables, columns, and stored procedures are in need…
Carlos
  • 213
  • 1
  • 8
2
votes
3 answers

Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment?

Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment? From an IT professional position, why would I not allow Oracle XE and MSSQL2005 to run on the same server?
Michael Rosario
  • 141
  • 2
1 2 3
…
99
100