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

learn more… | top users | synonyms

1
vote
3answers
710 views

Can I use SQL-Server on Windows Server 2008 R2 core?

Is it possible to run SQL-Server 2008R2 or 2012 on Windows Server 2008 R2 Core installation. There are three questions to answer: Does the license allow this? Can I install and operate it? Is it ...
0
votes
1answer
24 views

clustered windows service

I will have a clustered instance of SQL server over two nodes (active/passive) available in my deployed architecture. I want to deploy a windows service and have it also be active/passive on the two ...
0
votes
4answers
1k views

Two MS SQL Instances, one database file

Is it possible to have one database file attached to two different instances of SQL? Consider that the MDF is located on a NAS and I want a primary and secondary instance of MS SQL on two different ...
0
votes
2answers
419 views

In Amazon RDS, how can a disabled master user be re-enabled?

With a SQL Server instance on Amazon RDS it is possible to do the following to your master user: ALTER LOGIN masteruserid1 DISABLE GO If this command is executed while logged in as the that master ...
0
votes
1answer
2k views

How to Deploy an ASP.NET Web API- and Browser-based Application to a Production Environment [duplicate]

Possible Duplicate: How to Deploy an ASP.NET Web API- and Browser-based Application to a Production Environment We have an ASP.NET Web API server that serves up a SQL Server data driven ...
1
vote
1answer
502 views

Is there a negative impact to using SQL Server with a lower compatibility level

We have SQL Server 2008 R2 which we are using for a database with a compatibility level set as 2005 (90). We will by upgrading it to 2008 at some point, but in the meantime I would like to know if ...
1
vote
1answer
145 views

Will more memory help my CPU-peaking SQL Server 2008 R2

I'm supporting a system running against a SQL Server 2008 R2. The server is a single-CPU box with 8 GB of memory. As traffic has increased, the server has started saturating, peaking to 100% CPU ever ...
1
vote
0answers
360 views

MS SQL 2008 R2 64bit will not use more than 1.5GB in task manager

I have the latest MS SQL 2008 R2 installed on Windows Server 2008 R2 64-bit. The SQL server process never surpasses 1.5GB in the task manager resulting in heavy disk usage. I have solve this problem ...
-3
votes
1answer
956 views

Compatibility issues with sql server 2008 data center edition on windows 8 [closed]

I am trying to install Sql Server 2008 R2 Data Center Edition on Windows 8 but I am getting this message: "This program has compatibility issues" Is it save to install it anyway? Maybe someone has ...
0
votes
1answer
150 views

What to do instead of shrinking your databases and how to fix issues caused by previously shrunk databases?

I'm a fairly new SQL Server DBA but come from a software engineering background. I've been reading on several blogs that shrinking a database on a regular basis is bad and I understand why. The issue ...
0
votes
1answer
224 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
4k 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
3k 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
339 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
281 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
661 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
696 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
2k 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
2k 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
299 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
6k 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
1k 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
92 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
2k 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
123 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
27 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
3k 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
56 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
2k 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
816 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
85 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 ...
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
242 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
607 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
195 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
881 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
274 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
3k 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 an expensive contractor has just come in and said we need 72gb of ram so that the whole DB ...
0
votes
1answer
759 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
73 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
702 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
70 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
57 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
2k 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
745 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 ...