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
0
votes
2 answers

SQL Server 2008 R2 memory limit per instance or server?

I'm getting ready to deploy a new SQL server and realized that the memory limit of SQL Server 2008 R2 is supposedly 64GB of RAM (http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx). Potentially an upside, there will be many instances…
Dan
  • 1,278
  • 18
  • 27
0
votes
2 answers

How to run :connect (local)

When I run the following on SQL Server 2008 R2, I am getting Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ':'. What is wrong? :CONNECT(local) Go USE msdb go
user46529
  • 137
  • 1
  • 6
0
votes
1 answer

Setting up Windows Server 2008 R2 and SQL Server 2008 on a VPS

I wish to deploy trusted apps in a secure way. I got one empty VPS (with no operating system). But I don't know how to install Windows Server 2008 R2 (Enterprise/Datacenter) and SQL server 2008 (Enterprise) on it. The main purpose is to deploy…
1myb
  • 201
  • 1
  • 4
  • 10
0
votes
1 answer

Automating an SSRS 2008 R2 Report Snapshots and run report with most recent data

I would like to automate a report snapshot, but there is only an option to take a snapshot in the Report History Tab. All the resources I've found suggest I need to go to processing options and select "Render this report from a snapshot". But I…
Mr Shoubs
  • 363
  • 2
  • 9
  • 32
0
votes
1 answer

SQL Server not starting after hard reset

A server (Windows Server 2008 R2) in our office got hard reset and now SQL Server (2008 R2) is not starting. The Event log shows this error: Faulting application name: sqlservr.exe, version: 2009.100.1746.0, time stamp: 0x4cabc0fc Faulting module…
Malachi
  • 441
  • 2
  • 9
  • 18
0
votes
2 answers

SQL: Find Last Integrity Check Date

Is there a way to check when was the last integrity check run for each database? I know when the service startup it checks for these values, so they exist, and they are probably writen on the database header information. By the way I would like an…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
2 answers

SQL Log Shipping Two Databases using the same shared folder

I will configure Log Shipping for more than 1 database on single a server. And I wan't to know If I can use a single Shared Folder or if I have to create a Folder For Each Database. What I mean is: Does SQL know what backups to copy If I use a…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
1 answer

Default Data and Log Directories from remote server using TSQL

How do I know the directories independently of Instance Name, cluster Name or default instance? **UPDATE: ** Very important you can't read registry data with a nvarchar(MAX) only with a valued nvarchar like for example nvarchar(4000). I didn't know…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
2 answers

Moving SQL Server 2008 R2 Databases to Different SAN location

I have a sql instance up and running with the data files located on a SAN drive. I need to move this instance to a different SAN. I have server/instance on san drive p:\ in rack 1. I have a new server on rack 2 that I want to move it to. How do…
user59234
0
votes
3 answers

Sql Server 2008 killed Sql server 2005

I have a windows server 2008 machine, which I had sql server 2005 running on happily, then I needed to install 2008 R2 for another job. I was hoping to run them side by side. I configured 2008 to run as SERVERNAME\SQLSERVER08 and 2005 is on…
Mark Milford
  • 103
  • 1
  • 3
0
votes
1 answer

Installing SQL Server 2008 R2 32bit on 64bit : WoW64 error

It looks like it's possible for 2008 SP1: previous question. But what about current newer 2008 R2 version? We plan to use single 32bit Express edition package to install on every machine. However, on 64bit Windows 7 it produces this…
Mikhail Orlov
  • 249
  • 1
  • 3
  • 9
0
votes
1 answer

Programmatically Copy Database like SQL Server 2008 Copy Database Wizard

I need the ability to copy a database similar to what the Copy Database wizard accomplishes in SQL Server, but in a more automated (i.e. command line) fashion. I am writing a small application in C# that is making a copy of a web site (both files…
Scott
  • 137
  • 1
  • 1
  • 9
0
votes
1 answer

Sql 2008 r2 DEV install failed

I am trying to install Sql 2008 r2 DEVeloper on Windows 2008 STD. It previously had Sql 2008 Enterprise installed. I first uninstalled SQL 2008. I think uninstall still leaves some crap in registery, and in Program files. Installation fails in the…
obulay
0
votes
2 answers

Two way synchronization with SSIS?

Can I use SQL Server Integration Services (SSIS) to create a two-way synchronization between tables in two different databases? I am using SQL Server 2008 R2. If it is possible, then how do I handle synchronization conflicts?
Jan Aagaard
  • 175
  • 1
  • 9
0
votes
1 answer

Problems with side-by-side-installation of SQL Server 2008R2 and MSDE?

I installed SQL Server 2008 R2 Standard on a server, without knowing there was an installation of MSDE (Microsoft SQL Server 2000 Desktop Engine). After I installed SQL Server 2008 R2 the client software of the MSDE won't start anymore, instead they…
Sam
  • 909
  • 5
  • 15
  • 28
1 2 3
…
25 26