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

learn more… | top users | synonyms

2
votes
1answer
363 views

Existing tables with binaries to use filestream

I've got a few tables for which I want to use filestream storage. These tables already contain binary data and have rowguids. However at the time they were were created, the tables were not added to ...
0
votes
1answer
79 views

SQL Server 2008 instance's listening on mulitple ports on a cluster [closed]

I have three SQL Server 2008 instances running on a cluster. SQLInstance1 is listening on default port 1433, SQLInstance2 is listening on port 39999 and SQLInstance3 is listening on port 49999. Can ...
2
votes
2answers
3k 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
210 views

Should a SQL Server tempDB partition be shared by the cluster?

We have a 2-node SQL Server 2008 RS cluster. The data and log partitions are shared among the cluster nodes. Does the tempDB partition need to be shared as well, or will local server node storage ...
1
vote
1answer
346 views

SSRS Errors “Use Local”, even though I am

I am at a loss. I posted this on SO, but think this is probably a better place. I have searched high and low and don't know what to do. I am running SQL Server Web Edition on Server 2008, which only ...
1
vote
2answers
159 views

What ports do I need to open up on my Win 2k12 server for MSSQL Express 2008?

I'm running Microsoft SQL Express 2008 on a Windows 2012 Server box. Got everything work, and I even manage to connect with the firewall down. But I dont really want the firewall turned off at all ...
1
vote
2answers
323 views

What factors affect the noise in a rack server?

I have a DELL Poweredge 1950 rack server.On this server my SQL Server database is hosted. Since last month it has become very noisy and irritating. I checked my CPU usage but it is normal.Is it due to ...
0
votes
0answers
339 views

SQL Server Reporting authentication not working

I'm not exactly sure what went wrong but our SQL Server Reporting Services authentication is no longer working correctly. When I try to load the site, it asks for a username and password, and mine ...
0
votes
1answer
541 views

Error in install sql server 2008 rn

When running the SQL Server 2008 setup, I receive the following error message: TITLE: Microsoft SQL Server 2008 R2 Setup The following error has occurred: Unable to open Windows Installer file ...
0
votes
1answer
192 views

Create Report in Microsoft Excel - Permissions Issue in Team Foundation Server 2010

I am trying to use the feature "Create a Report in Microsoft Excel" for Visual Studio TFS 2010. I am being prompted for a username and password in Excel for any given Team Project when right clicking ...
2
votes
1answer
1k views

Ram recommendations vs SQL DB size

we have a medium sized SQL db of around 40GB, and are about to move it to a new box with server 2008 r2 x64 some expensive contractor blokey has just come in and said we need 72gb of ram so that the ...
0
votes
1answer
619 views

How can I uninstall SQL Server Express from Windows Server 2008?

I installed Windows Server 2008 as my OS, but I dislike the SQL Server Express which it provided by default, so I changed to SQL Sever 2008 Enterprise. The problem is, I don't know how to remove the ...
0
votes
0answers
136 views

How to speed up SQL Sever - More RAM didn't work

We have a server with 48 GB RAM on it. We're running some pretty heavy processes on SQL Server 2008 64 bit, but it tops out at 3 GB and won't use any more. It only uses about 15% of the CPU. The ...
0
votes
1answer
67 views

Difference between having two filegroups and having two databases

I have a thousand web servers writing their logs to a SQL Server 2008 database. The log information can be up to 100 GB per day, and we keep 1 month’s worth of logs. Each day, we run queries on the ...
0
votes
1answer
495 views

lost session after putting DB in single user mode

I have same problem as here: SQL2005 Stuck in Single Mode User Only difference, I am using SQL Server 2008. Tried everything, nothing works. When I run my ALTER DATABASE [CS_10.1] SET MULTI_USER ...
1
vote
1answer
54 views

Sql Server - Minimum rights to be able to grant other people similar rights

I would like to grant someone on our web dev team the ability to grant other users (other web developers as well as application users they create) datareader, datawriter, and exec sproc in our Dev and ...
2
votes
5answers
1k views

Cannot connect to windows server by name over vpn connection

I have a rented dedicated windows server on a public ip that is acting as a SQL Server and VPN server. I need to connect to this server via computer name to get replication in place. I cannot use an ...
0
votes
2answers
507 views

Configuring SQL Server 2008 log shipping

I am trying to configure log shipping from a cluster of two Windows Server 2008 R2 x64 machines running SQL Server 2008 R2 to a single machine running the same OS and DB. Setup appears to go okay (no ...
1
vote
1answer
100 views

SQL Server 2008 Timeout Expired

I asked the question below on Stackoverflow without any answers, however, someone suggested I ask the question on serverfault also. Hopefully someone can help. I recently publish my ASP.Net MVC 3 web ...
2
votes
2answers
47 views

SQL Server Tuning Advisor

I've run the Tuning Advisor on a workload I had saved. In its recommendations are a lot of create statistics and a few create indexes. I know the indexes will improve performance but can anyone ...
1
vote
1answer
340 views

Database I/O RAID 10 vs single disks

I'm currently hosting a game server with the current specification E1230 32GB Ram 500Gbx4 SATA Windows 2008 server SQL Server 2012 Databse size is 10Gb Number of players 1k The problem at first I ...
0
votes
1answer
79 views

SQL Server 2005 connection to SQL Server 2008 R2

I having trouble with SQL Server 2008 R2 Express. I installed it and the service is running but SQLexpress, but without success. I even tired to uninstall SQL Server 2008 R2 and I could it said that I ...
4
votes
2answers
3k views

Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?

I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still ...
0
votes
1answer
57 views

SQL server 2008 database

i am getting following error in all my websites when i am trying to access the database from websites. A network-related or instance-specific error occurred while establishing a connection to SQL ...
1
vote
1answer
144 views

Is replication less resource intensive than high frequency reads?

I am beginning the development of a new web application which needs to be designed to scale from the word go. I am looking into database replication and the concept of master/slave replication (or ...
0
votes
0answers
196 views

MS Sql Database is not responding in random manner

I've created a database in MS-SQL and used it in my application. But sometimes it doesn't responds randomly and throws an exception System.Data.DataRowView' does not contain a property with the name ...
0
votes
0answers
1k views

SQL Server error: Error: 802, Severity: 17, State: 20

I'm randomly getting this error while running a script... Exception calling "ExecuteNonQuery" with "1" argument(s): "An exception occurred while executing a Transact-SQL statement or batch." ...
3
votes
1answer
280 views

Highly available and scalable SQL Servers with read-only databases?

I've been thinking about building a website which could potentially get a lot of traffic. It would be a research site of sorts with wiki capabilities. So users would be able to edit information on ...
2
votes
2answers
665 views

How to prevent hackers attacking SQL Server 2008 R2?

I checked my SQL Server 2008R2 log in Log File Viewer and found out that someone from China keeps trying to login as 'SA' all the time, but failed of course. Is there anyway to prevent these hackers ...
0
votes
1answer
29 views

Login Failure issue - SQL Server 2008 SETUP on Windows Server 2008

Hi I am trying to upgrade Edition on SQL server 2008 on Windows Server 2008 and while the Setup it checks all the system requirements and When in the end i click Upgrade It gives me error that ...
1
vote
3answers
627 views

SQL Server returning empty result sets (to busy?)

My apologies from the start, I don't have much information to go on and I am just looking for some help debugging my issue. I have 5 sites running on a Windows Server Web Edition 2008 with SQL Server ...
1
vote
2answers
324 views

automatically restart sql server after job completes

I'm looking for a way to automatically restart the SQL service after an agent job has completed or as the last step of an agent job. It occurs to me that the agent service is dependent on the server ...
1
vote
1answer
137 views

Installing instance of Sql - SQL server 2008 R2

I am extremely new to SQL server. I am running the SQL Server 2008 R2 setup wizard and following a tutorial that I found online. Nowhere am I able to configure my instance, even after completing ...
1
vote
2answers
105 views

Database Server Can't Find 300GB

I have a Windows Server 2008 R2 running Microsoft SQL Server 2008 R2. I have some how lost 300 GB of disk space, and I can't seem to find it anywhere. The Hard Drive is 500GB and I can only account ...
0
votes
0answers
402 views

SQL 2008 Standard R2 - MSA vs Virtual Accounts vs Domain Accounts?

Just wondering if someone could point me to the right direction. Im about to implement an SQL server on the DC machine. I know that it is not recommended to run the SQL server on the DC but that is ...
1
vote
4answers
216 views

Sql Server Backup Compatibility - 2008 with 2005

I'm hoping to restore a backup from SQL Server 2008 into a Sql Server 2005 instance. Is there a way to have Sql 2008 back up in a format that 2005 will understand?
1
vote
1answer
180 views

single application multiple users through thin client

I am having one application built in C# winforms. In the backend I am using SQLSERVER 2008 Express. The application is used remotely through thin clients. My problem is that when one user is using my ...
0
votes
1answer
183 views

Is it possible to batch restore backups and remove users from databases in MSSQL 2008?

We're having to do an emergency migration of all of our MSSQL databases from a dying box to a new shiny instance of SQL2008. Unfortunately, we're having to do it by restoring from nightly backups ...
-1
votes
2answers
2k views

High memory usage, where is it coming from?

I have a virtual machine (Windows 2008 Server R2 64 bit running on vmware esxi 4) with 6 GB of installed RAM. It's reporting 95% memory usage and close to 0% CPU. This server hosts some WCF services ...
0
votes
0answers
118 views

Can not connect to MSSQL Server 2008 Express

I'm trying to connect to a Microsoft SQL Server 2008 Express edition over the internet. Connecting to the server over LAN works just fine. I have opened port 1433 on the firewall and set the ...
0
votes
1answer
674 views

Enable remote access to SQL Server 2008

I've just built a virtual SQL Server 2 node cluster using VMWare workstation. The windows cluster has been created, SQL has been installed on both nodes and added to the cluster, all latest updates ...
3
votes
3answers
2k views

adding additional disks to existing RAID 5

I have been handed the challenge of adding 4 additional drives to an IBM ThinkServer with a RAID 5 array on an MS Windows Server 2008 Std. living life as a SQL server. First question is "is it even ...
1
vote
1answer
345 views

Can an instance of amazon ec2 be upgraded automatically from sql server 2008 r2 to sql server 2012?

Is there a tool from Amazon or Microsoft to automatically upgrade an ec2 instance's sql server 2008 to 2012? Or do I have to create a new instance and then import all the databases?
0
votes
1answer
141 views

Upgrading SQL Server 2008 to 2012

I have SQL Server 2008 running on my development machine that I wish to upgrade to the 2012 release. In your experience, is it better to use the upgrade wizard or to remove the SQL Server 2008 and ...
1
vote
1answer
4k views

SQL Server 2008 R2 database stuck in single user mode

We tried to restore a database and it failed for some reason. Now it is stuck in single user mode. Here is what I tried: select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame from ...
0
votes
1answer
269 views

Problems Installing SQL Server 2008 on Windows Server 2008 R2 Standard SP1

I'm attempting to install SQL Server 2008 on Windows Server 2008 R2 Standard with SP1, and am failing the "Operating system supported for edition" operation in the Installation Rules portion of the ...
2
votes
1answer
132 views

Retrieve SQL Server 2008 Product Key

I am trying to obtain the SQL Server 2008 Product key from an installed instance on Server 2008 Std. The previous company never passed us the details and we need to install on a new server to ...
1
vote
1answer
315 views

Enable Remote Access to SQL Server 2008 R2 (no SSMS)

My VPS has limited space, and was trying a few times to install SQL Server 2008 R2 with SSMS; but installation has failed due to hard drive free space (there only 2.5 GB). Now my plan is to install ...
2
votes
1answer
935 views

Restore SQL Server 2008 db without affecting users

When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA ...
1
vote
1answer
64 views

sql log backup expiration settings

I have a DB in full recovery mode. The DB makes a full backup every Friday night, then a differential backup all other nights. We perform a log file backup every two hours. I noticed in the ...