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

learn more… | top users | synonyms

7
votes
13answers
28k views

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 ...
6
votes
2answers
1k views

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 ...
1
vote
1answer
958 views

port number of SQL Server

I am wondering what ports are used by SQL Server database engine? I need such port number to write configuration scripts to grant access to specific port of the machine installed with SQL Server to ...
17
votes
2answers
107k views

I cannot connect to my local SQL Server 2008?

I've just installed SQL Server 2008 and I cannot connect to it with SQL Server Management Studio. My intention is to just let my local windows user be authenticated but I am not totally sure how to do ...
3
votes
7answers
35k views

Cannot connect to SQL Server

I'm having a problem connecting to my SQL Server Express instance. I can connect to the sa account from the local machine but as soon as I try to connect from a separate workstation, the connection ...
2
votes
7answers
3k views

Problem attaching mdf file in sql server 2008

I have an mdf file of sql server 2005 database now i want it to attach in sql server 2008 R2 but when i try to attach it, it gave me error saying. Unable to open the physical file ...
10
votes
2answers
12k views

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 ...
10
votes
2answers
20k views

How to enable remote connections for SQL Server 2008?

How do I enable remote connections on an SQL Server 2008 installation? I have created a rule in the windows firewall to allow traffic through port 1433, but that does not seem to be enough.
13
votes
7answers
13k views

SQL Server Files Local or NAS or SAN?

I have to install a new Server with SQL Server 2008, What do you recommend, One server with Raid 10 or the Files in a NAS? What about iSCSI should I use it? What about SAN? The server has 4Gb of ...
4
votes
1answer
503 views

SQL Server 2008 R2 100% availability

Is there any way to provide 100% uptime on SQL Server 2008 R2? From my experience, the downtimes for the different replication methods are: Log Shipping: Lots (for DR only) Mirroring w. NLB: ~ 45 ...
5
votes
5answers
19k views

Don’t have permission to access SQL Server Express 2008?

I have a remote PC with SQL Server 2008 setup and allowing remote connections. I am an Admin user on the PC and have remotely connected to the SQL Server and I am trying to restore a database from ...
13
votes
6answers
30k views

Diagnosing Microsoft SQL Server error 9001: The log for the database is not available

Over the weekend a website I run stopped functioning, recording the following error in the Event Viewer each time a request is made to the website: Event ID: 9001 The log for database ...
6
votes
5answers
2k views

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 ...
3
votes
2answers
984 views

SQL 2008 Memory Usage

I have a SQL Server 2008 (ver 10.0.1600) running on a Windows Server 2008 R2 Enterprise server with 8 GB of physical ram. If I open Task Manager I can see on 'Physical Memory' section of 'Performance' ...
2
votes
2answers
810 views

SQL Cluster install on Hyper V options

I've been reading up on running a SQL Cluster in a Hyper V environment and there seems to be a couple of options: Install guest cluster on 2 VMs that are themselves part of a fail over cluster. ...
3
votes
8answers
8k views

How to stop Log file from growing in SQL Server 2008?

In my application right after restore I perform many(>100,000,000) updates to the newly created database. Thus, LOG files grows significantly. How can I stop it from growing? NOTE: Setting recovery ...
2
votes
2answers
2k views

Can't connect to a remote SQL server 2008 instance

I want to deploy my Database to a web server but I can't get a connection to the SQL server installed in the web server using management studio 2008. I have already enabled TCP/IP protocol in sql ...
2
votes
2answers
427 views

Benchmark tests for MSSQL 2000 VS MSSQL 2008.. (thinking for upgrade)

How much of a difference will there be (for speed and other benchmark results) for a database about 5 and even 10 GB to move from MSSQL 2000 to MSSQL 2008? It's running on a Windows 2003 VMWare guest ...
2
votes
4answers
473 views

SQL server failover clustering

How many failover clustered nodes can you have?, and if you add more and more nodes, is it going to slow down?
1
vote
1answer
424 views

Attempting to open a dll whenever logging on to server after SQL Server upgrade to 2008 R2

The environment is Windows Server 2003 SP2 32-bit, SQL Server 2008 R2 SP1 When logging on to the server the following message box is displayed 'you are attempting to open a file of type 'application ...
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
1
vote
2answers
299 views

not able to attach mdf file sql server 2008

I installed the sql server 2008 enterprise version that i got from mcts 433 prep kit. after installing i tried to attach the adventureworks mdf file and got the error below "the server principal ...
1
vote
5answers
797 views

Setting up a SQL server outside the domain

im very new to this. I've set up an account "SQLBOX" thats on the a network, but not connected to the domain. I have installed an instance of SQL Server 2008 and am trying to connect to it from ...
0
votes
1answer
207 views

SQL server port is blocked on client machine

I have a client machine on which sql server is installed. This machine is using the internet though a proxy machine. On the proxy machine wingate is installed. I could not connect to the remote sql ...
0
votes
2answers
110 views

How can I check what files people are downloading from my server

I have small server with IIS and windows server 2008 hosting one page. Sometimes my bandwidth is completely overloaded. How can I check what files are being downloaded from my server that is killing ...
0
votes
1answer
4k views

windows could not start sql server ( error 1067 the process terminated unexpectedly)

when i strat sql server 2008 in y computer this error windows could not start sql server (mssqlserver) servise on local computer error 1067 the process terminated unexpectedly.
0
votes
1answer
6k views

Maintenance Cleanup Task(s) running 'successfully' but not deleting back up files

I have a maintenance plan setup for all my user databases on a particular server, which does all the usually things at various intervals. The 7th and final subplan is a two stage cleanup plan; ...
17
votes
2answers
30k views

“'' is not a valid login or you do not have permission” on sql server installation

I have tried installing SQL Server 2008 multiple times on my machine, and I always receive this error about 3/4 of the way through: '' is not a valid login or you do not have permission. I use SYSTEM ...
8
votes
1answer
3k views

Alias to SQLEXPRESS

I have developer edition from SQL Server 2008, but now I have a piece of software with a hardcoded connection string: Data Source=.\SQLEXPRESS;Initial Catalog=db;User Id=sa;Password=1234; Now I ...
7
votes
5answers
3k views

Why is CPU use so asymmetric on our 8-cpu SQL Server box?

I've noticed that the CPU usage on our 8-CPU database server, running SQL Server 2008, is not balanced at all. Here are the 1 day averages for a random day a while back, which is typical and ...
4
votes
2answers
3k views

How to make SQL Server 2008 redundant?

At the moment I'd like to combine my departmental SQL Server into one big SQL Server 2008 instances spread across two servers (for redundancy reason). How/what is the best way to approach this ? is ...
8
votes
10answers
43k views

Can't remotely connect through SQL Server Management Studio

I have setup a SQL Server 2008 Express instance on a dedicated Windows 2008 Server hosted by 1and1.com. I cannot connect remotely to the server through management studio. I have taken the following ...
2
votes
3answers
6k views

Add the current admin user to SQL Server Express 2008

I have managed (in 'eksperiments') to remove both my Windows users from my SQL Express instance. I am now logged in as windows admin, and have re-created the corresponding SQL login, but I cannot ...
1
vote
1answer
2k views

Can't connect to Sql Server 2008 named instance

I just installed Sql 2008 Express on a new server running Windows Server 2008. I know Sql is working properly, because I can connect to the db fine locally, on the server. I cannot connect to it from ...
6
votes
5answers
548 views

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 ...
4
votes
9answers
10k views

SQL Server 2008 failover strategy - Log shipping or replication?

We just moved from SQL Server 2000 to SQL Server 2008. We were using our own log shipping on 2000 for failover. For 2008, we need to decide to use our own log shipping, built in log shipping, or ...
3
votes
2answers
5k views

Does splitting out Data, Logs, and TempDB matter using a SAN with SQL 2008

I'm not a server admin. So be gentle. But I was just at a conference and in one of the training classes the Instructor explained some SQL DBA best practices. One of which was to separate out ...
2
votes
1answer
433 views

Windows Essential Business - limitations/experience?

Our company is mid-size, and we are considering the purchase of both Exchange server and SQL server. Buying all the software products and CAL's seperately seems kind of expensive, so I'm wondering if ...
2
votes
10answers
598 views

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 ...
1
vote
3answers
551 views

Update permission denied, can't give self db_datawriter permission despite being admin on box

I'm in the administrators group on a Windows 2008 database server. My username appears in the Security -> Logins section of the SQL Server Management Studio and under Properties -> Server Roles I see ...
1
vote
3answers
2k views

How do I properly set up SQL Server Profiler in a production environment?

In our production environment (SQL Server 2008 Enterprise), we've been having issues with CPU usage and network utilization. Based on the specs of the (multiple) machines we have and the general ...
0
votes
1answer
237 views

SQL authentication not authenticating in MS SQL Server 2008

When I try to connect to the SQL Server running on localhost using Windows Authentication in SQL Server Management Studio, I am able to connect but when I try to connect using SQL authentication, it ...
0
votes
2answers
1k views

Windows Server 2003 supports SQL Server 2008 Express edition?

I am wondering whether we could install SQL Server 2008 Express edition on Windows Server 2003? Or only SQL Server 2005 Express is supported on Windows Server 2003? thanks in advance, George
0
votes
2answers
480 views

SQL Server 2008 Express edition download package

I want to download SQL Server 2008 Express edition. I am downloading from http://www.microsoft.com/express/sql/download/, but cannot find a standalone install package. I can only find a install ...
6
votes
4answers
4k views

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 ...
4
votes
2answers
4k views

User Provisioning Tool for SQL Server 2008?

Yesterday I moved my machine from one domain to another - foolishly forgetting the implications for my local instance of SQL Server! Mixed Mode authentication is not enabled, and the only local ...
4
votes
2answers
6k views

Running SQL server 2005 and 2008 on same machine?

Running SQL server 2005 and 2008 on same machine ? Is this possible/practicable ? It's only for developers and not very resource intensive - is there anyone out there who's done it ? Would be ...
3
votes
1answer
3k views

Windows 2008 R2 services not working

EDIT I spawned the Windows events logging service won't start issue to a separate question here I have a strange problem: SQLAGENT won't start Windows events logging service won't start Today I ...
3
votes
2answers
484 views

Do I need to back up the SQL Server Encryption Password and Symmetric Key?

I'm trying to setup SQL Server to use Cell-Level Encryption on some sensitive data. It seems straightforward per this example on the MSDN: Create the Master Key with a strong password. Create a ...
3
votes
2answers
1k views

repair suspect database

My sql server 2008 told me that you database is suspect and I can't see my tables or my data or use it what should I do ?