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

Best practice for instaling multiple instances of MS SQL 2008r2 on Windows server 2008r2 (running on esxi)

I wann't to move my sql server onto virtualized platform (Vsphere, esxi 4.1). Here is my plan on how would I install it: Vm with 3 disk's. C: for windows and sql binaries, D: for sql data, E: for logs All disk on different datastores Disks D: and…
2
votes
2 answers

Distributed MS SSAS database?

Is it possible to distribute a single SSAS database over multiple physical servers in order to improve performance? I've been looking at the Microsoft PDW architecture and am not clear if this is possible using that, or if there are any…
Mike Gates
  • 185
  • 1
  • 1
  • 3
2
votes
2 answers

Backup MS SQL 2000 db from SQL Management Studio 2005 on another server?

The situation: I have an instance of MS SQL 2000 running on one server. On another server I've installed SQL Management Studio Express 2005. I can access the SQL 2000 server from Management Studio. I try to run a backup of a database, but when I try…
Mikael Grönfelt
  • 677
  • 3
  • 7
  • 14
2
votes
3 answers

How to I export transaction log of MS SQL 2008 database?

How do I export / view changes between 3:00am and 8:30am on my database? I have people entering data to the server and during that time, we had an issue where people data were not properly entered into the system. Thanks!
2
votes
3 answers

Amazon EC2 MS SQL Instances

We have an Amazon EC2 box running the Windows Server 2008 with MS SQL Server 2008 R2. The default instance of the SQL server is running fine (the default MSSQLSERVER), we want to add a second one - when we go to the the set up and configuration (the…
Anonymous
  • 193
  • 1
  • 1
  • 7
2
votes
2 answers

restoring the SQL Server Agent account after it's been deleted

I have removed by accident SQLServerAgent account and now I can't get access to the database. Connecting from SSMS throws me an error, and system log shows: Error 26 SQLServerAgent could not be started (reason: Error creating a new session). .…
jackal
2
votes
5 answers

SQL Server Maintenence Plan error on an offline Database

Today is SQL day for me :) I have a maintenance plan that is failing to run with the following error: Failed:(-1073548784) Executing the query "USE [SharedServices1_DB]" failed with the following error: "Database 'SharedServices1_DB' cannot …
Sean Earp
  • 7,227
  • 3
  • 36
  • 38
2
votes
3 answers

What RAID level do you use on SharePoint databases?

When configuring the storage for your SharePoint databases what RAID level do you use? The scenario I'm looking for is for a medium to large farm. What I'm interested in is how the different workloads that you can do affect the choices that you…
Aaron Weiker
  • 686
  • 1
  • 5
  • 10
2
votes
4 answers

SharePoint - Do DPM and SQL backups affect each other?

I am trying to clear up an ugly maintenance plan on SharePoint databases that happen to also be backed up by Data Protection Manager (which is setup to take snapshots at 15-minute intervals). The business would like to separately perform backups of…
Sean Earp
  • 7,227
  • 3
  • 36
  • 38
2
votes
2 answers

Transfering BLOBS on a MSSQL -> MySQL Linked Server

Working on setting up a new MySQL database for a website, and I'm trying to figure out how to transfer over long strings. I have quite a few MSSQL tables that have Varchars ranging from 500 to 2000. Obviously in MySQL these have to be stored in a…
AndyD273
  • 207
  • 1
  • 11
2
votes
10 answers

SQL2005 vs SQL2008

We are investigating replacing an existing SQL2000 server on Windows2003 (32Bit) with new hardware and a newer version. We are looking at an application that requires at least SQL2005, but will run on SQL2008 as well. Our other DB's should run on…
BillN
  • 1,503
  • 1
  • 13
  • 31
2
votes
1 answer

Best Way to "Upgrade" SQL Server Express to Web Edition

I'm in the position where I've run into the limitations of SQL server express and have bought a license for SQL Server Web edition. What is currently installed on the server is SQL Server 2008 Express with Advanced Services, and I'm trying to…
Luke
  • 121
  • 1
  • 3
2
votes
1 answer

Is there a way to configure SQL server 2000 (or 2008) to accept 'sa' connections only from the local subnet?

I want to tighten security by forbidding 'sa' logins unless they're from the local subnet. Is there a way to list somewhere the acceptable subnets certain users can connect from in SQL server 2000 or SQL server 2008? Thanks! Isaac
IsaacB
  • 335
  • 1
  • 5
  • 12
2
votes
1 answer

Full, Differential and Log backups of databases, MSSQL an MYSQL

Best I give a back story so you get the full picture. I am in the process of setting up a new business, which hopefully will start in April 2012, and as such I am preparing every aspect of it. One part of the business will be web hosting. I am quite…
Anthony
  • 367
  • 1
  • 4
  • 14
2
votes
1 answer

Using Encrypting File System on SQL Server data files

I have SQL Server 2008 standard edition running on Windows Server 2003. I need to encrypt the databases. One obvious option is to upgrade to enterprise edition and use TDE. However, this might not be an option due to cost. Can anyone provide any…
Robin Day
  • 506
  • 1
  • 8
  • 19