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

learn more… | top users | synonyms

0
votes
1answer
184 views

Sql Server 2008 Create Foreign Key Manually

I have inherited an old database which wasn't designed very well. It is a Sql Server 2008 database which is missing quite a lot of Foreign Key relationships. Below shows two of the tables, and I am ...
2
votes
1answer
3k views

Unable to start SQL Server Instance 2008 R2 - DB file corrupt

I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is " The log scan number passed to log scan in database ‘master’ is not valid. This ...
1
vote
1answer
50 views

Altering a table via SQL Server Management Studio - get SQL

Is there a way to get the ALTER statement run by the management studio when altering a table in the design view?
0
votes
3answers
2k views

2008 SQL Server, attach option does not show all the drive letters

I have a cluster DB, and i am trying to attach DB files, it doesn't let me navigate to any other drive except for DB? Is there something wrong that i am doing? Example, if my DB is created in F:\, i ...
1
vote
1answer
46 views

SQL Server 2008 login issue using Active Directory users [closed]

Sir i installed sql server 2008 in one domain i can login sql server in both login mode.Is it possible to login sql server from diffrent domain?
1
vote
1answer
318 views

What's the importance of restoring SQL Server system databases (model, master, etc.)?

I had to restore some production databases to a different drive on the same Microsoft SQL Server 2005 machine. That worked fine and the application using the databases is back online. However, i have ...
3
votes
2answers
277 views

Windows Failover and Load Balancing confusion

In the next couple months we are looking to add Failover and Load Balancing to our environment. We will have 2 servers that are Hyper V Hosts. We are looking to have an IIS App server and SQL ...
0
votes
1answer
587 views

SQL Server 2008 R2: starting SQL browser failed

During troubleshooting of the failed connection to sqldb in my testsystem I've tried to start sqlbrowser via command line. This results the following error message "failed starting SSRP redirection ...
1
vote
1answer
3k views

SQL 2008 Backups to UNC Share Failing 0xC002F210

This problem is driving me NUTS!! We take backups of all of our production databases to a network share, which are then backed up to tape nightly. 8pm Mon-Fri - Full backup, followed by log backup ...
0
votes
1answer
607 views

cannot connect to sql server express from sql server standard

... like my title says... I cannot connect to my instance on sql server express from sql server standard... I have tried disabling firing wall and checked sqlbrowser is started but for some reason I ...
0
votes
1answer
1k views

physical memory usage is high on production sql server [duplicate]

Possible Duplicate: SQL 2008 Memory Usage I'm going threw high physical memory usage in SQL Server. It always around 90%.When i reboot the server, it will initially good but end of the day ...
2
votes
1answer
1k views

unable to locate trace definition file for microsoft sql server version 10.50.0

I try to create a new trace in sql server profiler. got following error: unable to locate trace definition file for microsoft sql server version 10.50.0 the database I connected to is sql server ...
1
vote
1answer
245 views

String search and replace across an entire database

After an exploit on an ASP.NET site, the client was left with a specific string of malware code sprayed across the entire database, multiple columns of multiple tables. The prepended string is ...
0
votes
1answer
1k views

“could not find the database engine startup handle sql 2008 r2” error

I have hit a brick wall here... I am trying to install ssrs in one of my other VM. After installing sql server express and ssms(which installs successfully), I have tried to install ssrs(making ...
2
votes
3answers
5k views

Linked server issue. Can't use windows authentication as remote login account

I tried to set up linked server. The target server is MS SQL 2008R2. It works fine if I set Remote login by sa account. However, if I use a windows account, it will popup an error. And I get the ...
1
vote
1answer
892 views

Cannot deploy reports on localhost/reports

I am using Microsoft SQL Server 2008 R2, Sql Server Reporting Services(SSRS) on an xp virtual machine.. I have created a report and am trying to deploy it... but getting this error... The specified ...
0
votes
1answer
87 views

Unable to install SQL Server 2008 Express SP1

I am facing difficulties installing the MS SQL Server Express 2008 Service Pack 1. I already have MS SQL Server Express 2008 installed and all I want to do is to install the SP1 however I get ...
0
votes
2answers
1k views

Alias a linked Server in SQL server management studio?

Hoping someone can help - is there a way in SQL server management studio 2008 R2 that I can alias a linked SQL server? I have a server, added by IP address, to which I do not have the login ...
2
votes
1answer
116 views

SQL server 2008 enterprise installation error on Windows 7

When I try to install SQL Server 2008 enterprise on my Windows 7 machine, I get this error message. When I click on Retry, I get the same error again. Error reading from file ...
0
votes
1answer
26 views

installing a second instance of SQL Server 2008

I am trying to install second instance of SQL Server 2008 enterprise edition in my window 7 machine using network server, local service, and my admin account. However I keep getting the below error. ...
1
vote
2answers
2k views

Setting Timeouts: SQL Server 2008/IIS 7.5

We have recently migrated from a Win 2003/SQL Server 2000 system to Win 2008 64 bit R2, SQL Server 2008 R2. Our websites are in classic asp, and this can't be changed to another scripting language at ...
0
votes
1answer
55 views

What are the things to look out for when adding other domain user to your IIS?

I have a Windows Server 2008 R2 called Jack11 that joined a domain called Watson.org. It has IIS 7 installed. From my understanding, we need to add the following into the web.config file ...
2
votes
1answer
1k views

PerfMon counters have different Page File % Usage values for _Total and C:\pagefile.sys for SQL Server on VM

I am collecting PerfMon counters on a SQL Server 2008 server (which is hosted on a VM), and I am getting different Page File % Usage values for _Total and C:\pagefile.sys. The C:\pagefile.sys values ...
2
votes
2answers
1k views

When adding second processor to SQL Server, will it automatically balance the load?

We have a SQL Server 2008 R2 (10.5) on a dedicated box with a single 2.4Ghz processor, which regularly runs at 70-80% CPU. We are going to be adding a significant number of users to the application ...
3
votes
1answer
637 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
80 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
4k 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
226 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
564 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
184 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 ...
0
votes
1answer
757 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
2answers
223 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 ...
3
votes
1answer
2k 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
710 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
1answer
71 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
616 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 ...
0
votes
1answer
68 views

SQL server 2008 are prevented form being installed on Windows 7 - error message “access is denied ”

I have recently installed Windows 7 enterprise . When I try to Install Microsoft SQL server 2008 EXPRESS edition , I get an error message : "Access is denied" just right after the installation process ...
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
663 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
2answers
454 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
49 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
387 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
87 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 ...
1
vote
1answer
626 views

Why is SQL maxing out at 50% of CPU on my EC2 c1.medium instance?

I'm new to AWS, so I think this might be a really simple question: I'm using an EC2 t1.micro instance as my SQL DB server for some small-scale analysis that I'm doing (Windows, SQL Express 2008). It ...
0
votes
1answer
59 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
179 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 ...
3
votes
1answer
305 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
774 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 ...