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
22k 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
949 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 ...
15
votes
2answers
75k 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
33k 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
2k 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 ...
9
votes
2answers
11k 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
16k 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
10k 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
415 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 ...
10
votes
6answers
14k 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
707 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
799 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
5k 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
1k 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
358 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
438 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
223 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
294 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
560 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
174 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
105 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
2k 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
4k 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; ...
6
votes
5answers
2k 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
2k 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 ...
4
votes
1answer
1k 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 ...
2
votes
3answers
4k 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
515 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
9k 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 ...
2
votes
1answer
415 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
597 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
477 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
0answers
110 views

SAN device storage config for SQL 2008 cluster

Windows Server 2008 R2 (clustered active/passive) - SQL Server 2008 Enterprise - Dell MD3200i PowerVault SAN 8 x 450GB 15k SAS drives (RAID 10) What is the best stripe unit size for this ...
0
votes
1answer
228 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
995 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
409 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 ...
4
votes
4answers
3k 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
3k 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
5k 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
266 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
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 ?
3
votes
2answers
358 views

SQL Server 2008 - scheduled copy of production database into test and development databases

I wish to schedule a copy from my production database into two other databases. The databases are located on same server (instance?). The databases are currently backed up to server hard drive every ...
3
votes
1answer
972 views

SQL Server 2008 Copy Database Wizard: Fail

I am trying to use the SQL Server 2008 Copy Database Wizard to copy a SQL Server 2008 database. I am using the SQL Management Object method. However, the copy fails with the following error: ERROR : ...
3
votes
6answers
3k views

1 logical drive vs 2 logical drivers on 1 raid controller to separate data from log files?

I'm configuring a new server: it has 1 raid controller with 8x 146 Gb disks. The system is currently configured in Raid 1+0 but has only 1 logical drive, which is not that optimal as data and ...
3
votes
2answers
167 views

sql 2008 disk layout on a budget this is for database mirroring

Guys I'm rolling out a SQL database server that will be used to back Sharepoint 2007. Right now I need some advice on my disk layout. I have two Dell servers that are configured a little differently ...