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
1
vote
1 answer

Will a SQL Server client alias survive a sysprep?

I want to sysprep a Windows Server 2008 R2 SP1 machine that has SQL Server 2008 R2 SP1 installed (for reference, SQL Server 2008 R2 has a new sysprep feature that allows the instance to be sysprepped). On the server is a SQL Server client alias that…
shufler
  • 972
  • 1
  • 6
  • 18
1
vote
1 answer

Adding a linked server via Powershell

I'm trying to add a linked server to my local SQL Server 2008 R2 setup from within a Powershell script. Here's what I've been trying so far (and variants): EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'',…
dckrooney
  • 111
  • 1
  • 5
1
vote
1 answer

SQL2008 Max Memory set to 10GB, Target/Total perfmon counters report it's using 1.6GB. What's up?

Running SQL2008 R2 32bit on Windows Server 2003 Enterprise with 12GB of RAM. Inside the Memory settings of the SQL instance I've got max memory set to 10000MB but it isn't going past 1.6GB according to the following query. SELECT…
Justin Popa
  • 45
  • 1
  • 1
  • 7
1
vote
1 answer

Why does SQL Server Management Studio fail to connect on the first attempt?

When accessing SQL server on a remote development PC via Management Studio the connection will consistently fail on the first attempt. After the failure I retry and can now successfully connect to the database. This isn't a huge issue, but when I…
awilson53
  • 125
  • 1
  • 7
1
vote
1 answer

Remote Performance Monitoring SQL Server

I've got a couple of servers running SQL Server 2005 Enterprise and I'd like to monitor them remotely using Perfmon (Windows' Performance Monitor). On my machine, I have an instance of SQL Server 2008 R2 Developer, and I noticed that there are a…
ivanmp
  • 180
  • 1
  • 10
1
vote
1 answer

SQL Server 2008 R2 Writing To Text File

I used to write to text files from SQL Server using the code listed below: DECLARE @FS INT --File System Object DECLARE @OLEResult INT --Result message/code DECLARE @FileID INT --Pointer to file --Create file system object (OLE…
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
  • 125
  • 2
  • 9
1
vote
2 answers

Upgrade sql server 2008 to 2008 R2, in-place upgrade or new install

When upgrading we normally create a new install and migrate databases over, but we are going to test out in-place upgrade from sql server 2008 to sql server 2008 r2 (standard) in our development environment. Question is can the upgrade steps for…
maguy
  • 113
  • 3
1
vote
3 answers

SQL Server 2008 R2 Clustering inside VMware

I am working on a new Windows 2008 R2 / SQL Server R2 HA cluster and we are planning on running this inside of VMware ESX 5. I have read and heard differing views on using SQL clustering inside of ESX, some seems to say its fine others do not. We…
enterzero
  • 453
  • 6
  • 15
1
vote
1 answer

SqlServer 2008R2 sp1 CHECKDB crashes when spatial index present

We've been having an issue with DBCC CHECKDB crashing with an access violation (null pointer deference) on Sql Server 2008R2 when spatial indexes are present. It is repeatable with DBCC CHECKDB WITH EXTENDED_LOGICAL_CHECKS but also happens in some…
Michael Ferrante
  • 1,641
  • 1
  • 13
  • 10
1
vote
2 answers

Sql Server 2008 R2 connection error

I have installed Sql Server 2008 R2(express edition) on my server and now I want to connect to that server from my client. But it shows the following error: cannot connect to SMSERVER\SMTECH How can I solve this?
Kishore Jangid
  • 129
  • 1
  • 1
  • 7
1
vote
1 answer

SQL Server 2008 R2 Backup

I see this error message in log BACKUP failed to complete the command BACKUP DATABASE model. Check the backup application log for detailed messages. SQL Agent is disabled. I never issued backup command. There is a single user database on this…
Manish kumar
  • 11
  • 1
1
vote
2 answers

using win7 pc instead of windows 2003 server

Simple question, in terms of hosting an Asp.net-mvc/SQL Server 2008 R2 Express based app, will a powerful Windows 7 PC do? I just wonder if there is anything I'm missing here, being an App Dev and not a sysadmin. The application serves about 300…
gideon
  • 1,145
  • 2
  • 13
  • 28
1
vote
1 answer

how remotely connect to sql server 2008-r2 installed on vps(virtual private network)? (firewall and sql server 2008 configs)

i have sql server 2008 r2 installed on a virtual private network (vps) with one ip valid ... my sql server instance info for connect on server(vps) is like below : server type: database engine server name :…
SilverLight
  • 290
  • 3
  • 11
  • 22
1
vote
2 answers

sql server cluster - "the given network name is unusable" error in creation wizard

I'm trying to create a sql server 2008 R2 cluster. I've got two windows machines running server 2008 that are clustered and have all passed the validation tests etc. I'm now going through the "Install a sql server failover cluster" wizard and am on…
Blootac
  • 177
  • 1
  • 2
  • 9
1
vote
2 answers

How to migrate SQL 2005 to SQL 2008 R2 on new hardware with same server name

We have a need to migrate from existing hardware that is running SQL 2005 to new hardware running SQL 2008 R2. When all is said and done we want the same IP and hostname that was on the "old sql 2005" server to be on the new SQL 2008 R2 server…
TheCleaner
  • 32,627
  • 26
  • 132
  • 191
1 2 3
…
25 26