SQL Server 2008R2 is Microsoft's latest public version of SQL Server, released April 2010.

learn more… | top users | synonyms

-2
votes
2answers
156 views

What replication should I use for my Sql Server

We have a dedicated server that will host our client's database for a web portal. To connect to this database, you need an ip address. I figured I'd try Merge Replication since I already have the ...
-1
votes
2answers
266 views

SQL Server 2008 R2 installation hangs

On a freshly installed Windows Server 2008 R2 Standard SP1 I am installing SQL Server 2008 R2. After configuring setup, install starts, but then it will hang on: ...
4
votes
2answers
2k 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
2answers
369 views

Cannot install SQL Server 2008 R2 on Windows Server 2008 R2

We are attempting to install SQL Server 2008 R2 on a Windows 2008 R2 SP1 box. We keep running into errors at the end of the install - "the service did not respond to the start or control in a timely ...
2
votes
1answer
349 views

MS SQL Server is accessible locally but not over the internet

When I try to access a named instance of Microsoft SQL server 2008 R2 SP2 on the local network, I have no problem. But when access it outside office from the internet, I can not connect to the ...
0
votes
2answers
996 views

SQL Server 2008 R2 Replication log reader could not execute sp_replcmds

This log reader agent worked perfectly for several months until the user referenced in the error was removed from the domain. After that time the error 'The process could not execute 'sp_replcmds' on ...
1
vote
3answers
421 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 ...
0
votes
1answer
765 views

error when trying to load SQL server 2008 R2 native client x86

There's technically 2 problems interlinked with each other here... I'm currently working on connecting to a mssql database from a website and testing everything through Xampp on a VM. When running ...
0
votes
1answer
93 views

Can't install SSRS 2008 R2 default instance

I have a SQL Server 2008 R2 that had Reporting Services included and uninstalled. Default Instance. I now need to add Reporting Services to the installation and I am getting an "Instance Name in use" ...
3
votes
1answer
831 views

SQL Server Maintenance Plan: Rebuild Indexes and Transaction Log Backup File Size

In my nightly maintenance plan, I was doing everything - reorganising and rebuilding indexes, updating statistics, etc. There's an hourly maintenance plan that does a transaction log backup. I ...
1
vote
1answer
295 views

Clustering MSDTC on windows Server 2008 R2 returns “No storage Available”

I've set up a failover cluster, with SQL Server 2008r2, and it is running fine. I want to cluster MSDTC as well, but when I go through the high availability wizard, it tells me that there is no ...
0
votes
1answer
534 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 ...
6
votes
1answer
4k views

How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?

I'm managing about 90 SQL Server instances and need a query to determine how much memory has been allocated to each instance. Please note, I'm not asking how to set it, just to see what it's currently ...
3
votes
2answers
626 views

Attempting Unauthorized operation - SQL 2008 R2 install

I've been banging against this for a few days. Keep getting this unauthorized error when trying to install SQL 2008 R2 on a Windows 7 machine. I've changed permissions on the key, does not fix... ...
2
votes
1answer
174 views

Windows 2008 R2 Enterprise SQL Server Enterprise 2008 R2 only using half the memory

We have built a new 2 CPU, 6 core server, with 96GB of RAM. SQL server Enterprise Edition was configured with a maximum memory setting of 92GB. A few days after adding into the load balancer I have ...
1
vote
3answers
3k views

SQL 2008 R2 Named Instance Client Connectivity Issues?

We're upgrading our software from using SQL 2000 to 2008 R2. Our customers will be installing an update which uninstalls 2000 and installs 2008 R2 under the same instance. So if no instance existed, ...
-1
votes
1answer
54 views

SQL Server 2008 R2 remote connection

I am having problems making my ms sql server 2008 take remote connections, local workes fine. I have enabled the TCP/IP and the server browser server in the sql server config I have opened the ...
0
votes
1answer
65 views

ASP project and SQL Server 2008 database connection

I have a hosted Windows Server 2008 virtual machine. It is for my Internet sites. I installed IIS services on my Windows Server 2008. It is normal work. I installed SQL Server 2008 R2 on my Windows ...
0
votes
2answers
176 views

OLTP Sql Server RAID configuration with 10 disks, allocation Unit and disk stripe size

On a new db server I only have 10 disks to play with, The usage is about a booking every 3-5 seconds, so not high volume, I know compromises have to be made, but my initial thoughts are - DISK 1 ...
0
votes
1answer
112 views

Can a network failure cause a user to be removed from SQL as an authorized user?

We are trying to get to the bottom of our issue. We have a service that connects as MyDomain\ServiceAdmin to a SQL 2008 database. I believe we have just setup database mirroring too in case the ...
1
vote
1answer
2k views

Quorum Disk size for Windows 2008R2 failover

I am setting up a two node failover cluster for SQL Server 2008 R2 on Windows Server 2008 R2. Microsoft recommends minimum 512MB size LUN for the quorum disk and don't have a recommendation for the ...
1
vote
1answer
86 views

Moving MS SQL Server installation files

I need to move the installation files for SQL Server 2008 R2 from where they currently reside (S:\Program Files...) to a new drive (yet to be created). My S: holds my SQL backups, active data files, ...
0
votes
1answer
462 views

Lync using SQL 2008 R2 SP1 - Publish Topology error

Error that shows in the web page opened by the Topology builder: Error: An error occurred: "Microsoft.Rtc.Common.Data.SqlConnectionException" "A network-related or instance-specific error ...
2
votes
1answer
65 views

How do I troubleshoot a server I can't get logged into?

This morning I am unable to log into SQL Server because it appears to be busy doing something, so much so that CPU usage is constantly at 98%-99%. I am guessing that something has gone wrong with the ...
2
votes
1answer
198 views

Electricity gone off while shrinking database, how can I recover my database?

While executing a shrink on a 25GB database, the electricity has gone down, and I can't access my database. It shows as "In Recovery". How can I recover it?
0
votes
2answers
53 views

Can not create a linked server between SQL Server 2008 on a desktop and my laptop

I'm having an issue getting the linked server to connect between a desktop and my laptop. Both have SQL server 2008 and the link is coming from the desktop to my laptop. Also, both computers have ...
0
votes
1answer
61 views

Parallel Processing in SQL Server 2008 R2

I want to run my 2(two) SQL Server 2008 R2 Enterprise Edition as if one server. If one server is too busy, system should direct the requests to other server. How can I do this? Thanks..
1
vote
2answers
129 views

Transaction log backups

I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works. From what I understand, (correct me if I'm wrong...) the log is actively stored in ...
1
vote
1answer
263 views

Is start-process supported in a powershell step on SQL Server 2008 R2?

With the described configuration, I have a SQL Agent Job that includes a Powershell step. That step throws an error when it gets to the line $app = start-process -passthru $program $program_args ...
2
votes
4answers
1k views

Do I really need a 128GB pagefile

I'm running out of space on one of my servers and the only space that I can free in the immediate is re-sizing the enormous pagefile. The server has 128GB of memory and is currnetly set to ...
0
votes
1answer
61 views

Updating SQL Server 2008 R2 using slipstreamed source

I have a requirement to create a SQL Server 2008 R2 SP1 setup media. I have done this using slipstream method as recommended by Microsoft. I can only use this to create new installation. But is there ...
1
vote
1answer
587 views

SQL Server 2008 R2 GHOST CLEANUP hanging processes

2008 R2(SP1) - 10.50.2500.0 (X64) Hi, I am having the following problem intermittently on my development machine. I am running some T-SQL in a FOR loop. During each loop iteration, first we delete ...
-1
votes
1answer
184 views

Difference between SQL Server 2008 Express and Workgroup in regards to CAL's

I am currently using SQL Server Express edition, and am thinking of upgrading to SQL Server Web or Workgroup edition. My question is what restrictions will I experience with the introduction of CAL ...
3
votes
2answers
434 views

How to change max server memory in SQL Server

I was trying to change the max server memory for my database server, and I accidentally saved it as "4" instead of the number I wanted to enter. Now I can't even connect to the server. Is there a ...
0
votes
1answer
1k views

Can I downgrade SQL Server 2008 R2 Standard To Web Edition?

We are running a SQL Server 2008 R2 Standard Evaluation version. The client has decided they don't want to pay for full SQL Server standard and feel the Web edition is suitable. Can I downgrade SQL ...
0
votes
1answer
206 views

SQL Server 2008 R2 tempdb files configuration

On sql server 2008 r2 how do I check that tempdb files are configured for one data file per physical processor core? I have been looking on SQL Server Studio screens, but I haven't been able to find ...
0
votes
2answers
126 views

what is a good frequency for setting up snapshot replication in sql server 2008

My requirements: I have a publisher database from which I intend to replicate to a subscriber. Not all tables need to be replicated. Amount of data could be ~20-30GB. Given the above: is ...
2
votes
2answers
201 views

SQL Server 2008 R2 Cluster with HOSTS file entries to active node on the application servers

I questioned the decision of a colleague concerning the use of a HOSTS file entry on an application server (standard SQL database backed .NET solution), which I think would cause connections to the ...
1
vote
1answer
1k views

Do I need Windows CALs for a dedicated SQL Server database server? [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? This would seem an easy enough question, but I wasn't able to find any definite answer anywhere. If I'm running SQL ...
0
votes
1answer
175 views

exe hangs when scheduled from SQL Agent, but fine when run by user

I have a SQL Agent job on a clustered SQL 2008R2 server on Windows 2003 Enterprise. It's an Operating System (CmdExec) step, running an executable. When it runs on schedule, the process does start up, ...
2
votes
4answers
262 views

Data file size - SQL Server 2008

I am transferring a database that i made onto a server machine, but the size of the database is around 8GB, for some reason. It shouldn't be needing so much space as i only have a few hundred records. ...
2
votes
1answer
60 views

How to set up SQL Server to offer high availability during windows updates

We have a load-balanced web farm talking to a single SQL server instance. It is easy to demote web servers, install Windows updates, reboot, and then bring them back into the fold. However, we have to ...
3
votes
3answers
2k views

How do I encrypt SQL Server traffic with IPSEC?

I've found all sorts of documentation on what IPSEC is and how to (in very non-specific ways) configure it, but I can't seem to configure a Windows Firewall With Advanced Security rule that both A) ...
0
votes
1answer
2k views

SQL Server 2008 service pack installation error

When I am trying to install the SQL Server 2008 service pack I am getting the error as: There are no SQL Server instances or shared features that can be updated on this computer, and The version ...
0
votes
2answers
107 views

Backup for SQL & Server 2008 R2?

What's the best/easiest backup solution for my use case? Windows Server 2008 R2 Has a finance program called The Financial Edge (Blackbaud) that uses SQL Server 2008 R2 to keep its database Stores ...
4
votes
2answers
696 views

MS SQL access to restored database without sysadmin role

I have databases from different projects on one server. I can't give all developers administrative (sysadmin) access to the databases. They have to have the permissions needed to create and restore ...
2
votes
0answers
282 views

SQL Server 2008 R2 mirroring failing

I have two Windows 2008 R2 (Amazon EC2) instances running SQL Server 2008 R2. I use 9TB striped disks (9x1TB EBS volumes) for storage. One server is running as principal and second one as mirror. Both ...
-4
votes
1answer
867 views

Does SQL Server 2012 Developer Edition exist? [closed]

On my server, I have SQL Server 2008 R2 Developer Edition installed, and setup don't want to upgrade it to SQL Server 2012 Express. Does SQL Server 2012 Developer Edition exist?
3
votes
1answer
472 views

Is SQL Management Studio 2012 avaliable, without Engine itself?

On my dev machine, I have SQL Management Studio 2008 R2 installed. I tried to upgrade to SSMS 2012 Express, setup finished but nothing happened. Is it possible to get SQL Management Studio 2012 ...
0
votes
1answer
214 views

SQL Server tempdb performance

I have been doing some .net performance tests on a bunch of different data access frameworks. One of the things I've noticed is that performance when accessing the tempdb table in SQL is much ...