Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008]

A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here

1806 questions
6
votes
5 answers

Virtualizing Microsoft SQL Database server

My company is looking to virtualize our Microsoft SQL server. I read on another question that databases on VM's suffer from a IO bottleneck which is not very good for us. But I was wondering if since we are using Microsoft HyperV, Microsoft Server…
poconnor
  • 635
  • 2
  • 5
  • 13
6
votes
2 answers

Windows File Cache drops suddently

I have a 64-bit Windows 2003 server with 48 CPU cores and 128GB of RAM running a single application (SQL 2008 Analysis Services). SSAS is currently using about 50GB of memory. SSAS relies to a large extent on the Windows File Cache to hold…
BradC
  • 2,220
  • 4
  • 27
  • 36
6
votes
4 answers

Storing SQL Server System Databases On A Seperate Drive

Is it worth moving the SQL Server system databases master, model and msdb from the default install path on the main OS hard drive over to their own drive? I've already moved TempDB on to 2 separate drives one for the log file and one for the data…
Gavin
  • 253
  • 1
  • 2
  • 8
6
votes
5 answers

Double hop problem with sql server 2008

I'm trying to set up the following scenario. I have 3 servers, they are all in same domain. Server A has web application which runs under (domain) service account, dom\web. Server B has instance of SQL Server 2008 R2 which runs under (domain)…
dunno
  • 61
  • 1
  • 2
6
votes
3 answers

Giving a user database permissions in SQL Server Management Studio

In SQL Server Management Studio, when I right click my database and click properties, a window opens showing the permissions users have on the database. I have recently added a user to active directory with the intention of granting this user…
KyleM
  • 165
  • 1
  • 1
  • 9
6
votes
4 answers

SQL Server 2008 R2 Error 15401 when trying to add a domain user

I am trying to add a domain user. I am doing the following. Expand Security Right click on Logins Select New Login... Login name select search Click on location and select entire directory Type username Click checkname The name goes underlined and…
Alice
6
votes
4 answers

SQL Server 2Kx: How to move a database to a different partition in the local file system?

SQL Server creates its databases in the system program files directory structure. I want to separate the database files away from the system partition. Assuming the database is already created and populated: How do I move all files related to a…
Matias Nino
  • 1,392
  • 7
  • 25
  • 40
6
votes
1 answer

How to backup/restore excluding filestream varbinary in SQL Server 2008?

There is an application used in a production site that uses SQL Server 2008 as its DBMS. The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into the DB tables. The point is that now and then it…
fdierre
  • 161
  • 4
6
votes
3 answers

Does running the sql server profiler affect performance on the server?

I need to see which indexes I should add to my database so I need to run SQL Server Profiler so I can use it as input for the Database Engine Tuning Advisor. My question is, does the profiler affect the performance of the DB? Also, would running the…
Jonas Stawski
  • 479
  • 2
  • 8
  • 18
6
votes
3 answers

Does resizing a column lock the table?

What happens if I change a column from nvarchar(2) to nvarchar(10) or a column from char(2) to nvarchar(10). Does this lock, reorganize the table or does this work without any impact or downtime? I tried to find what happens if I alter a column, but…
kcode
  • 1,825
  • 4
  • 19
  • 21
6
votes
2 answers

How can I copy a SQL Server 2008 instance to another server?

What is the best way to create an exact copy of an entire SQL Server 2008 instance to another server? I want to copy everything: user accounts, logins, permissions, databases and all database objects, etc. I know how to copy things for each database…
Kevin Babcock
  • 243
  • 1
  • 4
  • 12
6
votes
4 answers

Troubleshooting SQL connectivity issues after database migration

We have a just completed a migration from SQL 2000 to SQL 2008 R2 and have started to intermittently receive SqlExceptions with the following two error messages: A transport-level error has occurred when receiving results from the server.…
Chris Shaffer
  • 768
  • 2
  • 8
  • 14
6
votes
6 answers

Can't connect to SQL Server 2008R2 on Windows Server 2008R2

I reinstall a server Windows Server 2008 R2, I installed SQL Server 2008 R2 no problem during installation. When I try to connect with "Microsoft SQL Management Studio" via sa account or Windows Administration account, I have this error (picture1),…
TheBoubou
  • 161
  • 1
  • 1
  • 3
6
votes
5 answers

What is the best way to configure 6 disk raid for SQL Server + OS?

I'm setting up a SQL Server on Win 2k8 with following hardware: 6 x WD RE3 500G SATA PERC H700 I've read some suggested that putting log file and OS on its own RAID1 while the rest of data is on RAID10 would be the best config for 8 disks. However…
BlueFox
  • 169
  • 2
  • 5
6
votes
1 answer

TFS is wonky after server move

We did a server move a while back and ever since then we have been having a weird "error" happen repeatedly. In a nutshell, when you first request connection (via VS.NET, TFS Admin Console or Web Site) it fails with a DB timeout. Then, just hit…
Keith Barrows
  • 309
  • 1
  • 3
  • 15
1 2 3
…
99 100