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
32k 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 ...
1
vote
1answer
974 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 ...
6
votes
2answers
2k 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 ...
3
votes
7answers
36k 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 ...
11
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 ...
14
votes
7answers
14k 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 ...
17
votes
2answers
129k 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 ...
10
votes
2answers
24k 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.
5
votes
5answers
21k 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 ...
6
votes
5answers
3k 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
1k 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
813 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. ...
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 ...
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; ...
0
votes
3answers
7k views

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

When i start SQL Server 2008 in my computer this error windows could not start SQL Server (mssqlserver) service on local computer error 1067 the process terminated unexpectedly.
0
votes
2answers
117 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
216 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 ...
18
votes
2answers
40k 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 ...
9
votes
1answer
4k 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 ...
2
votes
3answers
8k 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
8k views

SqlServer 2008 How to correctly install/configure SSL certificate to require encrypted connections

SqlServer 2008 instance is installed on Windows Server 2008 and is running under this identity: NT AUTHORITY\NETWORK SERVICE SSL cert from third-party CA has been installed in Local Computer\Personal ...
6
votes
5answers
565 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
7k 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 Mdf,...
2
votes
1answer
12k views

SQL 2008 SP2 RsClientPrint ActiveX - “Unable to load client print control”

We recently updated our SQL 2008 server to use SP 2 and its causing a few headaches. We use SSRS on this server and when a client tries to print a report by the built-in print function, we're needing ...
2
votes
10answers
602 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 ...
2
votes
1answer
441 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 ...
1
vote
3answers
571 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 ...
1
vote
2answers
1k views

Migrating to a new SQL Server machine: should master database be restored?

I'm currently working on a migration plan to migrate our SQL Server to some new hardware. The current installation is SQL Server 2005 standard: it used to be clustered but the node got removed at ...
0
votes
1answer
241 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
505 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
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
1answer
555 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 ...
3
votes
1answer
1k 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
2answers
174 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 ...
3
votes
1answer
4k 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
3answers
6k views

SQL server could not connect: Lacked Sufficient Buffer Space

I recently moved my app to a new server - the app is written in c# against the 3.5 framework. The hardware is faster but the OS is the same (Win Server 2003). No new software is running. On the prior ...
3
votes
2answers
691 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
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
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
481 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 ...
2
votes
3answers
1k views

Can a SQL Server 2000 database be hosted on SQL Server 2005/2008

I have a SQL Server 2000 database backup, but I don't have SQL Server 2000 installed. I have SQL Server 2005 installed. I'd like not to have multiple pieces of DB server software installed. Is it ...
2
votes
1answer
536 views

Intermittent unavailability of an instance in a failover cluster while a standby node is offline in a SQL Server 2008 failover cluster

I've got a small failover cluster that I run for the websites my company has. During a RAM upgrade of the standby server, our websites started to show errors about not being able to access the ...
2
votes
3answers
4k views

What would be the optimal disk config for SQL Server 2008 R2?

We have a new Dell R710 server that came with the following storage configuration: 8 x 146GB SAS 10k 6Gbps disks 1 x Perc H700 Integrated Controller (2 x 4 disks - 2 ports each supporting 4 disks) ...
2
votes
2answers
8k views

Is using the /3GB statup switch in Windows 2008 x64 only running Sql Server 2008 x64, a good thing?

there's plenty of articles that explain the use of the /3GB startup switch. The general explanation is .. Regardless of the amount of physical memory in your system, Windows uses a virtual ...
2
votes
1answer
2k views

SQL Server Windows Auth Login sees Domain as untrusted

I've had someone set up a domain controller on windows 2008 on one server, and sql server 2008 on another. The domain seems to be working fine, I'm logged on as a domain user on both servers, nothing ...
2
votes
2answers
109 views

Sql Server 2008 Backup and Restore

I have a production critical database which is in Simple Recover Model Currently. We take a Full Backup Every night at 2:30AM. Now I have to change the recovery model back to full. I have to design ...
2
votes
1answer
1k views

Best Way to “Upgrade” SQL Server Express to Web Edition

I'm in the position where I've run into the limitations of SQL server express and have bought a license for SQL Server Web edition. What is currently installed on the server is SQL Server 2008 ...