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
11
votes
2 answers

SQL Server 2005 / 2008 - multiple files / filegroups - how many? Why?

I'm a developer at heart - but every now and then, a customer doesn't have a decent DBA to deal with these issues, so I'm called in to decide.... What are your strategies / best practices when it comes to dealing with a reasonably sized SQL Server…
marc_s
  • 1,152
  • 4
  • 21
  • 35
10
votes
6 answers

cannot add a user to sysadmin role in SQL Server

I am using SQL Server 2008 Management Studio. The current logon account belongs to machine local administrator group. I am using Windows Integrated Security mode in SQL Server 2008. My issue is, after log into SQL Server Management Studio, I select…
George2
  • 1,137
  • 6
  • 22
  • 41
10
votes
2 answers

DB auto failover in c# does not work when the principal server physically goes offline

I'm setting up DB auto failover in C# with SQL Server 2008 and I have a 'high safety with automatic failover mirror' using a witness setup and my connection string looks like "Server=tcp:DC01; Failover Partner=tcp:DC02; database=dbname;…
user62521
  • 121
  • 2
  • 4
10
votes
6 answers

How to migrate from SQL Server 2005 to 2008

How do you migrate SQL Server 2005 databases to SQL Server 2008? Is it as easy as backing up 2005 databases and simply restore in 2008? Are there any compatibility issues? Is SQL Server Reporting service changed in anyway? How would you go about…
dance2die
  • 2,011
  • 7
  • 32
  • 41
10
votes
6 answers

SQL Server Timeout on first attempt

I'm having a strange issue where I try to attach to SQL Server 2008 running on a second computer (both machines running Win7 64-bit), either through the Data Sources in Visual Studio or via the SQL Management console itself. On first attempt to…
SergioL
  • 153
  • 1
  • 1
  • 7
10
votes
5 answers

What's the lowest cost, legal, Microsoft server stack you can assemble?

Assuming that you have an app infrastructure that generally only requires: ASP.NET MVC / C# / .NET Database or NoSQL data store (must be accessible from C#) Here's the challenge to you server gods: What is the least expensive configuration that…
McKAMEY
  • 635
  • 1
  • 6
  • 14
9
votes
1 answer

Ballooning occuring on SQL server

From what I understand ballooning should occur only when the host begins to run out of physical memory, somewhere above 90% usage. I have an SQL server running in a three node cluster (64 GB RAM in each host) and it has been assigned 8 GB of RAM as…
user35213
9
votes
5 answers

Bad Performance when SQL Server hits 99% Memory Usage

I've got a server that reports 8 GB of ram used up at 99%. When restart Sql Server, it drops down to about 5% usage, but gradually builds back up to 99% over about 2 hours. When I look at the sqlserver process, its reported as only using 100k ram,…
user2125551
  • 325
  • 2
  • 4
  • 9
9
votes
13 answers

HP Proliant DL380 G4 - Can this server still perform in 2011?

Can the HP Proliant DL380 G4 series server still perform at high a quality in the 2011 IT world? This may sound like a weird question but we are a very small company whose primary business is NOT IT related. So my IT dollars have to stretch a long…
BSchriver
  • 91
  • 1
  • 1
  • 2
9
votes
9 answers

What should I do about someone trying to brute force attempt to login to our SQL Server 'sa' account?

Looks like someone or something is trying a brute force attempt at logging into our production SQL Server instance with the 'sa' account. They haven't been successful because our 'sa' account is disabled, but what steps should I take to make sure…
Jon Erickson
  • 405
  • 1
  • 5
  • 8
9
votes
4 answers

Does MSSQL Server have the equivalent of MySQL's query logs?

I have used MySQL for a long time and have found the general query log and the slow query log to be very useful in finding out what is happening on the server, and in identifying bottlenecks. Now I need to use SQL Server. Does SQL Server have…
Martin
  • 516
  • 2
  • 4
  • 14
8
votes
3 answers

SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain

A few months ago we installed SQL Server 2012 in Windows 2008 R2 under the virtual account "NT Service\MSSQLSERVER", all good. A few days ago, one of the admins of the IT dept installed Full Text Search component to the SQL Server 2012 (the problem…
unruledboy
  • 183
  • 1
  • 1
  • 5
8
votes
3 answers

SQL Server transaction log BACKUPS are very large

In SQL Server 2008 R2 I have a database that has full backups nightly and transaction log backups every ten minutes. The database is in full recovery model. The problem is that the backup files for the transaction logs are hundreds of megabytes in…
Dustin Martin
  • 181
  • 1
  • 3
8
votes
5 answers

SQL Server Issue: Login failed for user 'username'

I am running a copy of SQL Server 2008 Standard and trying to setup a new user login for access to a DB through a web app. I am using Security -> Logins -> Add login to create the user. Login name and password is specified Default database has been…
GONeale
  • 614
  • 3
  • 7
  • 11
8
votes
2 answers

SQL Server memory constantly going up, from 1GB RAM used to 7GB in a week

I have a ~45GB database that increases rapidly (~1GB every week). So it's doing a lot of inserts; the web app doesn't have many users so reads are low right now. But I'm noticing that the RAM sql server users goes from ~1GB when the server is…
rksprst
  • 445
  • 1
  • 6
  • 9
1 2
3
…
99 100