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
1 answer

Creating a clone of a SQL Server database via backup/restore

So I'm trying to 'clone' a SQL Server database by making a backup of the template, then restoring it to the new name. However, there's either something I'm missing or something I don't understand about making backups. This is what I've got so…
thecoop
  • 287
  • 1
  • 2
  • 7
2
votes
4 answers

How to run SQL Server 2005 and 2008 on the same box?

I've got MS SQL Server 2005 (default instance) and SQL Server 2008 (named instance) running on Vista Ultimate x86. I have no problem connecting to both instances locally, but when I try connecting to them from another NETWORK - no luck. SQL Server…
roman m
  • 123
  • 1
  • 2
  • 8
2
votes
3 answers

SQL Server Hardware Configuration Recommendations

We're in the process of building a new SQL server, and would like some recommendations on hardware. Currently, we build all systems in house. With the information below, what would you recommend for drives and an external SAS cage. Also, in this…
Jon Bailey
  • 257
  • 1
  • 4
  • 11
2
votes
1 answer

'Service does not respond in a timely fashion' error when restarting Sql Server

When I try to restart my SQL server, I get the following error: Why this error happens and how to solve this?
Penguen
  • 123
  • 1
  • 4
2
votes
3 answers

Cannot connect to SQL Server and Wireshark don't listen anything

I'm trying to connect to a SQL Server from outside the LAN, so I opened port 1433 (default SQL Server port) in the firewall. On the server side I'm listening with Wireshark and I can listen ping (filtering by icmp or ip address) from ip X but…
sr.u
  • 21
  • 5
2
votes
4 answers

Can I install non English version of MS SQL Server 2008 to English version MS Windows Server 2008 R2?

My friend accidently bought Japanese MS SQL Server 2008 R2 instead of the English version. However, we currently have English Windows Server 2008 R2. Can we install it anyways? I don't have a test machine to try it out on first to see what happens.
bakytn
  • 1,217
  • 5
  • 16
  • 28
2
votes
2 answers

Why does Windows Automatic Updates ignore SQL Server service Packs?

Why does Windows Automatic Updates ignore SQL Server service Packs? Windows Server 2003 Standard X64 Service Pack 2 No WSUS server in the picture just Automatic Updates enabled. Default install of SQL Server 2005 Standard and Automatic Updates won't…
2
votes
2 answers

How to monitor SQL Server database?

I have SQL Server 2008 with multiple databases on it. CPU get's up to 100% on that server quite a lot. I would like to figure out which database might be causing it. What is the easies way to do that? My "magic" idal tool would show me: CPU, RAM…
katit
  • 213
  • 4
  • 9
2
votes
5 answers

Cannot add witness to my mirroring setup

I'm trying to set up mirroring with a witness using my 3 dedicated servers running SQL Server 2008 R2. I've set up everything as described at this blog post Mirroring seems to work fine between the principal and secondary server. But when I run the…
Adrian Grigore
  • 1,072
  • 3
  • 21
  • 34
2
votes
1 answer

What is the default account/group for SQL 2008 R2 cluster permissions and can you create/add them?

Last night we had an issue where the permissions were altered a SQL 2008 R2 Cluster Instance, such that the instance could no longer access the shared drives where the system databases were installed. While we corrected it by adding the service…
2
votes
3 answers

How can I make my SSIS process consume more resources and run faster?

I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports. I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server (SSIS-Server01) is an 8CPU, 32GB RAM box. The SQL…
Raj More
  • 327
  • 1
  • 3
  • 11
2
votes
2 answers

SQL Server & Disk Space

I created a database on a local SQL server that we use for development. I created the log and data files on a second hard drive (E:\MSSQL\DATA). I am using this database to do some speed tests so I created a lot of data (7 Million rows). I started…
Dismissile
  • 175
  • 6
2
votes
1 answer

Unexplained CPU and Disk activity spikes in SQL Server 2005

Before I pose my question, please allow me to describe the situation. I have a database server, with a number of tables. Two of the biggest tables contain over 800k rows each. The majority of rows are less than 10k in size, though roughly 1 in 100…
CadentOrange
  • 141
  • 7
2
votes
0 answers

"Operating system error 1394" - How can I prevent it?

I get occasional and random failures of my SQL Server backups with the error message Operating system error 1394 Does anyone know why this error occurs and how I can prevent it? A little Googling tells me:…
Guy
  • 2,668
  • 2
  • 20
  • 24
2
votes
2 answers

Determine Who Dropped a Database?

I have a SQL Server 2005 database that has been deleted, and I need to discover who deleted it. Is there a way of obtaining this user name?
Tangiest
  • 240
  • 3
  • 10