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

How to change default recovery for new databases?

How can i configure the database server on our development server so that when new databases are created that they are Simple recovery model by default? Currently if we remember, when creating a database we have to click on the options tab and…
Valamas
  • 365
  • 1
  • 4
  • 9
15
votes
4 answers

With SQL Server (2008), can you grant create table permission within a schema?

Working with security in SQL Server 2008, I'm trying to grant a user CREATE TABLE permissions, but only within a specific schema. Does CREATE TABLE permission only apply at the database level? Can I limit the user to create table only within a…
RyanW
  • 528
  • 3
  • 9
  • 19
15
votes
7 answers

SQL Server restore a backup results in an error

I have a database in dev (SQL Server 2005 on Windows Server 2008) that I need to move to prod (SQL Server 2000 on Windows Server 2003). My process is as follows: Login to dev, open SQL Server Management Studio Right click on the database | Tasks |…
Mario
  • 321
  • 1
  • 5
  • 12
15
votes
2 answers

What is a SQL Server instance?

When I install SQL Server 2008 Express in prompts me to create an instance and aborts if I don't. Then I see that information in an entry in Sql Server Configuration Manager on SQL Server Services. What is a SQL Server instance?
Pablo Fernandez
  • 7,438
  • 25
  • 71
  • 83
14
votes
1 answer

Parallel Redo Is Shutdown

When looking in Windows event logs, i'm seeing the following messages on an almost continuous basis - Starting up database 'Database'. Parallel redo is started for database 'Database' with worker pool size [1]. Parallel redo is shutdown for…
Gavin Coates
  • 410
  • 1
  • 6
  • 17
14
votes
9 answers

Why is it so important to backup your transaction log?

We're currently implementing a backup solution for a client and their ERP solution uses SQL Server. The ERP solution was set up by a different company. And they are telling me that it is super important to back up and truncate the transaction…
Oliver Salzburg
  • 4,635
  • 17
  • 55
  • 82
14
votes
6 answers

SQL Server Express for Production Databases?

We are about to roll out a dual web/internal transactional application where each client has their own database. Each database is very small - under 50MB each, so we were wondering if it would make sense to use SQL Express 2008 instead of the full…
Beep beep
  • 1,833
  • 2
  • 18
  • 33
14
votes
1 answer

Can MS SQL Management Studio 2012 be installed without installing SQL SERVER?

We have a windows server 2012 with SQL Server 2012 BI installed. I can remote desktop and use the sql management studio in the server. However I would like to install that tool - sql management studio 2012 - in my local machine, but I don't see a…
cusco
  • 168
  • 1
  • 1
  • 8
14
votes
7 answers

SQL Server - Force DB in memory?

We have a beefy Windows 2008 x64 server (4 x 4 core CPU, 32GB RAM) running SQL Server 2005 64-bit. We have a small (6GB) but very important database that is somewhat slow to access until the pages are cached in memory (the usage is very much random…
Matt Rogish
  • 1,512
  • 6
  • 25
  • 41
14
votes
3 answers

DBA who is worried reorganizing or rebuidling indexes may cause data loss?

We have some databases with index fragmentation that is > 95%. As best I can tell the indexes have never been rebuilt much less reorganized. In years. (In fairness, these tables do seem to have auto-updated statistics enabled. Also in fairness, he…
Greg Hendershott
  • 816
  • 1
  • 8
  • 12
14
votes
4 answers

Recommended disk/partition setup for a SQL Server

I'm looking for some advice regarding the best way to set up my disks/partitions for SQL Server. Here are some of my major concerns: How should the SQL files be seperated (data files, logs, temp)? Is it better to RAID a lot of HDDs and partition the…
Shane
  • 1,869
  • 4
  • 20
  • 34
14
votes
3 answers

Combining SharePoint and Database Mirroring

This isn't a how-should-I-do-this question, just to set the stage. It's a what has your experience been? Please read through the whole question before quickly replying. I spent the day yesterday teaching the current round of SharePoint MCM…
Paul Randal
  • 7,194
  • 1
  • 36
  • 45
14
votes
19 answers

What is the simplest and fastest way to transfer large file through a Windows network?

I have a Window Server 2000 machine running MS SQL Server that stores over 20GB of data. The database is backed-up every day to the second harddrive. I want to transfer those backup files to another computer to build another test server and for…
Sake
  • 417
  • 3
  • 5
  • 12
14
votes
8 answers

Is using integrated security (SSPI) for accessing SQL Server better for web applications?

When deploying web applications (.net) to a production environment, is it better to use integrated security or does it even matter? It seems to me that if a hacker breaks the web server, it won't really matter as they can easily impersonate the…
NotMe
  • 3,772
  • 7
  • 31
  • 43
13
votes
6 answers

Advantages of upgrading 32 bit Windows Server and SQL Server to 64 bit?

Suppose that I have a 32 bit Windows Server box that operates several server applications along with an SQL Server, with a RAM usage of about 2 GB at peak times. What would be the advantages of upgrading the Windows Server OS and SQL Server to the…
Someone
  • 139
  • 1
  • 3
1 2 3
…
99 100