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 2008 R2: How to determine who restored the database?

Our database was recently restored. It caused some real grief. Is there an audit mechanism to determine who executed the most recent restore? Thanks.
Jerry Nixon
  • 103
  • 2
0
votes
1 answer

How much to increase page file value for SQL Server 2008 R2 Full Text Search Engine

SQL Server 2008 R2 Full-text search engine (FTS) is taking up too much resource (I/O & Memory) in my production server. (migrated from SQL server 2005). I have been reading up on SQL Server FTS engine Internals and Enhancements and there was a…
dance2die
  • 2,011
  • 7
  • 32
  • 41
0
votes
1 answer

SQL Server Data and Log folders

I have used mysql happily for years; however, due to certain software requiring SQL Server, I am now evaluating SQL Server 2008. When I am setting up the previously mentioned program it is giving me the following error: Default Data/Log location…
knpwrs
  • 357
  • 1
  • 5
  • 14
0
votes
1 answer

MsSQL Server 2008 R2 Setup Discovery Report shows instance but Management studio sees nothing

I've just installed Microsoft SQL Server 2008 R2 (64 bits with BI) on a windows dedicated server with the cheap Web Edition. I launched Microsoft SQL Server 2008 R2 Setup Discovery Report which says: Product Instance Instance ID Microsoft SQL…
user46250
  • 362
  • 1
  • 6
  • 22
0
votes
1 answer

Access windowsauthentication SQL Server 2008R2 after Domain change

When I installed the SQL Server 2008R2 on the windows server, the computer was not in a domain. After I installed it, now someone moved the server into a domain. Problem is: the server can not be accessed anymore, since it is set to windows…
Sam
  • 909
  • 5
  • 15
  • 28
0
votes
4 answers

how to install mssql 2008 r2 from iso

I'm trying to install ms sql from iso. I've installed virtual clonedrive which mounts the iso as drive however i'm getting the following error. E:\Resoourse\1033\setup.rll is either not designed to run on Windows or it contains and error. Try…
Frosty
  • 233
  • 1
  • 4
  • 10
0
votes
1 answer

SNMP and SQL Server, is it possible to store the alerts in sql server without using any program?

I have an old system (a legacy system) that reads SNMP messages and stores (somehow) them into a SQL server 2008 tables (or 2008r2). The system is working, however, I am clueless about how it stores into a SQL server table. Is it possible to read…
magallanes
  • 167
  • 3
0
votes
2 answers

MS SQL 2008 R2 disaster restore

I need to restore an MS SQL 2008 R2 server. The original server was completely destroyed, nothing to salvage. Yet there is backup of all data, plus system databases, master, msdb, model; .bak files. I setup a new machine, exactly same version of…
Krackout
  • 1,575
  • 7
  • 20
-1
votes
1 answer

Does Microsoft SQL Server 2008 R2 Service Pack 1 install the SQL Server?

Does the SQL Server 2008 R2 Service Pack 1 include the SQL Server when you install it? Cause after a long online search couln't found the answer.
Victor DM
  • 1
  • 1
-1
votes
1 answer

Restoring From Another Dev's MDF on Same Database: MDF Cannot be Overwritten

Here is the situation: We have multiple developers. We want to import/export(restore/backup) .bak files whilst working on the same, but local, databases(Each dev has a local instance of DB: A). The problem is as follows: I try to do a BACKUP…
Moo
  • 97
  • 1
-1
votes
1 answer

Windows update 2919355 causes our SQL based app perf to drop to 1/6 of previous perf

We have a VB6 app calling out to a local SQL2008R2 instance. We have had complaints about it's performance dropping considerably. After a lot of experimental research, we have determined at least 1 cause of this speed decrease. Whilst running on a…
Rory Becker
  • 528
  • 6
  • 13
-1
votes
1 answer

Slow WRITE operations SQL Server, corrupt backup file after COPY

I am not a network type but a Programmer. I have been working with our DBA and Network technician about a problem I am experiencing. First, our DBA recently moved the database I support from one server to another. They are virtual machines but the…
David
  • 1
-1
votes
1 answer

SQL Server Express 2008 R2 limitations

When considering to use an Express Edition of SQL Server 2008 for a system that officially is only tested with full editions, what do I need to know about the limitations? Memory, connections? What about backup and restore features? Can I set up…
lox
  • 167
  • 1
  • 7
-1
votes
2 answers

Is it possible to restore database without Filestream

I have actually a small Production Filestream enabled database. Data (150 Mo) + Filestream (500 Mo). Tomorow, the filestream will grow until 30 Go... I have many Test Databases that I want to restore with Production dump. Is it possible to restore…
alain
  • 7
  • 1
  • 2
-1
votes
1 answer

How can I find what is using the RAM in the server?

I am dealing with 32bit Windows 2003 server which was once a physical box, but now is virtualized in vmware. There are two SQL Server instances running. One is 2000 Standard, another is 2008 R2 Express. The machine supposedly has 3GB of RAM…
John
  • 7
  • 3
1 2 3
…
25
26