Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008-r2]

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

SQL Server 2008 R2 was released to manufacturing on April 21, 2010. SQL Server 2008 R2 adds certain features to SQL Server 2008 including a master data management system branded as Master Data Services, a central management of master data entities and hierarchies.

SQL Server 2008 R2 includes a number of new services, including PowerPivot for Excel and SharePoint, Master Data Services, StreamInsight, Report Builder 3.0, Reporting Services Add-in for SharePoint, a Data-tier function in Visual Studio that enables packaging of tiered databases as part of an application, and a SQL Server Utility named UC (Utility Control Point), part of AMSM (Application and Multi-Server Management) that is used to manage multiple SQL Servers.

The first SQL Server 2008 R2 service pack (Service Pack 1) was released on July 11, 2011.

390 questions
3
votes
3 answers

Transferring SQL Server 2008 R2 tables/data from dev box to server

I'm nearing the end of site development, and am now facing transferring my table structure and data from my development machine to the live server. SQL Server 2008 R2 is already installed and ready to go on the live server, so at least that's out…
Major Productions
  • 185
  • 6
  • 17
3
votes
5 answers

SQL Server 2008 R2 transactional replication over VPN

I'm having difficulty setting up replication over a VPN. I have a SQL Server 2008 R2, Enterprise Edition database on a Windows 2008 R2 Server. SQL Server is running on a non-standard port. I have set it up so that it is acting as its own distributor…
enashnash
  • 131
  • 1
  • 3
3
votes
2 answers

Can I create SQL v10.0 databases in SQL R2 server?

Is there a way to create non-R2 databases in an R2 database server? I was hoping to do this in the compatibility options during the database creation, but only options are available for 2005 and 2000. Am I only stuck with installing the non-R2 SQL…
TruMan1
  • 435
  • 2
  • 9
  • 18
3
votes
3 answers

Does SQL Server 2008 R2 lock memory pages by default?

Does anyone know if the locked pages of SQL 2008 ENT R2 x64 operates as ON as default (I assume it does as my SQL memory usage does not show up in task manager) on Server 2008 R2 x64. And if so, could this cause a .net app competing for some memory…
WickedW
  • 133
  • 1
  • 6
2
votes
0 answers

Importing data from Informix DB to SQL Server

Configured Informix drivers (32-bit) ODBC on my local machine and trying to import the data to SQL Server using SQL Server IMPORT and export wizard. I selected source tables and views(steps in SQL import): When I click on preview I'm getting the…
aditya y
  • 21
  • 2
2
votes
0 answers

Virtualised SQL Server Cluster test environment error "originally formatted with sector size 4096"

I am trying to set up an environment for testing a clustered SQL Server upgrade, so I have built a replica here on VMware Workstation 11. I have provisioned 3 servers for this, two Windows Server 2012R2 for the SQL, and a FreeNAS 9.1 to provide the…
Cylindric
  • 1,127
  • 5
  • 24
  • 45
2
votes
2 answers

SQL Server, local instance, No process is on the other end of the pipe

On a fresh installation, on my local SQL server instance, using SQL Server Management Studio, I can login with my Windows authentication, but not with my sa user. In both cases, I'm using (local) as my Server name. The error is the following: A…
Nicolas C
  • 173
  • 2
  • 2
  • 9
2
votes
1 answer

ASP.NET MVC Getting Error 504 after 10 minutes of File Upload

I have an ASP.NET MVC2 Web application, working with SQL Server 2008 R2, running with IIS 6.2. I have a functionality where one particular admin needs to upload about 5000 documents, which then get to be processed and stored in the server, while…
SantLev
  • 23
  • 1
  • 5
2
votes
1 answer

Manage SQL Agent Jobs On Multiple Servers

Is there a way to deploy/modify/remove//manage SQL Agent Jobs across multiple servers within a domain without third-party software?
totalfreakingnoob
  • 145
  • 1
  • 6
2
votes
0 answers

SQL Upgrade Adviser for win2k

I'm trying to upgrade a SQL Server 2000 instance to SQL Server 2008 R2. SQL Server 2000 resides on an old win2k box, and the new SQL instance is being run on a Server 2008 R2 platform. I am attempting to use Microsoft's SQL Upgrade Adviser tool to…
kubiej21
  • 289
  • 1
  • 5
  • 12
2
votes
1 answer

Connection to SQL Server 2008 R2 Database Server is SLOW

The database server is a VM running SQL Server 2008 R2 on top of Windows Server 2012, 24GB RAM allocated and 2TB of disk space. Overall, the database connections are very slow and one thing that stands out is that the connection to the database…
AbeP
  • 135
  • 2
  • 7
2
votes
1 answer

AD Integrated OpenVPN Server User Cannot Connect to MS SQL Server

I have a Windows 2008 R2 Domain/Forest functional level environment with an OpenVPN Access Server (v1.8.4.400) that is Active Directory integrated and working smoothly. I've been working with our DBA to streamline the permissions process and we have…
rws907
  • 231
  • 2
  • 8
2
votes
2 answers

How do I force a restore over an existing database?

I have a database, and i want to force a restore over top of it. I check the option: Overwrite the existing database (WITH REPLACE) But, as expected, SSMS is unable to overwrite the existing database. Of course i don't want different filenames; i…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
2
votes
1 answer

Upgrade Expired SQL Server 2008R2 Evaluation to SQL Server 2012

We have been working on developing several SharePoint sites as a POC using the evaluation versions of SharePoint 2013 and SQL Server 2008R2 Enterprise Evaluation. POC worked, went into limited production, well the SQL Server Evaluation expiration…
Matt Bear
  • 874
  • 3
  • 12
  • 28
2
votes
1 answer

SQL Server cannot be reached by name only by IP

I have several computers (XP) connected to domain controller (2008R2). Last time I had to change IP address of the SQL Server 2008 R2 (simple instance, no clustering or replication). DNS has been updated and on all computers everything work great.…
user1121956
  • 123
  • 1
  • 4
1 2 3
…
25 26