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

learn more… | top users | synonyms

1
vote
2answers
646 views

What version of PowerShell is required for SQL Server 2008 R2?

Today I tried to install SQL Server 2008 R2 Express on my computer but I the installation failed, it said that PowerShell must be installed on it. My question is then, what version of PowerShell ...
1
vote
2answers
1k views

Migrate SCOM 2007 R2 Databases to SQL 2008 R2 (change server)

UPDATE I have a SCOM 2007 R2 server that uses a sql 2005 server. Machine 1: SCOM (SCOM 2007 R2 - W2K3) Machine 2: SQL2005 (SQL 2005 SP2 - W2K3) SQL Cluster: SQLCLUSTER (SQL 2008 R2 on Cluster - ...
1
vote
3answers
4k views

“RESTORE HEADERONLY is terminating abnormally” error when restoring backup

When I try to restore a database backup file, I get the following error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ...
1
vote
4answers
9k views

Permission denied when creating database in Sql Server 2008 express

Running the following (generated by Sql Server Management Studio) on Sql Server 2008 Express under Vista: CREATE DATABASE [test] ON PRIMARY ( NAME = N'test', FILENAME = N'c:\Program Files\Microsoft ...
1
vote
2answers
142 views

Setting Sql server security rights for multiple situations

We have an application which uses an instance of Sql Server locally for its backend storage. The administrator windows login has had its sysadmin right revoked, and instead two sql logins have been ...
1
vote
1answer
72 views

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 ...
1
vote
1answer
63 views

deploy ssis 2012 packages on 2008r2 server

We've developed SSIS packages on ssis 2012, but now upon deployment, we need to deploy these to sql server 2008. I've been searching but haven't found a solution to do this. Is this even possible and ...
1
vote
1answer
287 views

ASP.NET Session State SQL Server 2008 R2 Freezes with High CPU Usage

Our ASP.Net website uses SQL Server as the session state provider. We currently host the database on SQL Server 2005 since it does not play well on 2008 R2. We would like to know why, and how to fix ...
1
vote
2answers
471 views

SQL Server stops regularly on every windows restart

Edit 3 & 4 Added Although the SQL Server instance is set to run automatically and TCP also is enabled in its Network Configuration, the SQL Server is stopped after each system restart. I have to ...
1
vote
2answers
84 views

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 ...
1
vote
2answers
582 views

Amazon EC2 MS SQL Instances

We have an Amazon EC2 box running the Windows Server 2008 with MS SQL Server 2008 R2. The default instance of the SQL server is running fine (the default MSSQLSERVER), we want to add a second one - ...
1
vote
1answer
310 views

Can only debug once

I can only debug a query once, after that I get this error and have to restart Management Studio. Unable to start T-SQL Debugging. Could not connect to computer '(local)'. The requested name is ...
1
vote
2answers
263 views

cannot at all find sql instance (while installing an asp.net app on IIS)

So I'm really not a DBA, I'm an app dev. I had to install my asp.net mvc3 app on my client's(a large company) IIS6 + Win2k3 machine, with absolutely no help from their sysadmins. The final problem ...
1
vote
1answer
622 views

SQL Agent History settings not being saved

I'm using Win 2K3 R2 + SP2 with SQL 2K8 R2 installed. I'm trying to set SQL Agent History to keep 1 week of logs. So here's what I do: After I connect, I right click SQL Server Agent and select ...
1
vote
2answers
61 views

SQL Server 2008 constantly reads MDF file, performance terrible [closed]

We have an app that runs SQL Server 2008 R2 Express on the back end on a Windows 2008 R2 virtual server running on VMWare ESXi. Users complain that the app is very slow. I see very high disk IO that ...
1
vote
1answer
45 views

Installing SQL Server 2012 on older instance

I have SQL Server 2008R2 installed on my server which I can connect either by providing server name "xyz" or IP address "127.xx.xx.xxx". Does it mean my installation is done with default instance? ...
1
vote
1answer
52 views

Restoring database to a point in time not working

I have a database that is backed up nightly via a maintenance plan I created using the wizard in management studio. The recovery model is set to full. On the 26th something happened and SQL Agent ...
1
vote
1answer
27 views

SQL server many to one mirroring

I have two SQL servers, server A and server B running SQL Server 2008 R2 Standard. Can I setup a third server that will be a mirror for both server A and server B? I can't seem to find any ...
1
vote
1answer
320 views

SQL Server 2008 R2 on Windows Server 2003 - “ failed to initialize 0x84B10001”

I am trying to install SQL Server 2008 R2 Express on Windows Server 2003 and I get an error "failed to initialize 0x84B10001". Googling got me the following link - ...
1
vote
1answer
268 views

Troubleshooting I/O latency possibly caused by file system driver

I have a SQL Server instance (SQL Server 2008 R2, Windows 2008 R2) that complains, for very short, random periods of about 15-20 seconds, that some of its I/O requests are taking longer than 15 ...
1
vote
1answer
114 views

SQL Server account disabled even in single user mode

I'm integrating with a third-party product via its SQL Server 2008 R2 database. In a previous version, I was able to access the database via SQL Server Management Studio and SQLCMD as a Windows ...
1
vote
1answer
311 views

Error upgrading from SQL Server 2008 to SQL Server 2008 R2

I needed to restore a database (created in SQL Server 2008 R2 - version 10.50.1600) to a new DB in Server 2008 (version - 10.00.2531). I got the error - Restore failed for Server .... Additional info ...
1
vote
1answer
3k views

Connection failed: SQLState: '01000' SQL Server Error: 10061

I'm trying to connect my access front-end to the SQL Server backend. It was working when SQL Server was on my computer but now i'm trying to connect to a server So when I create the DSN file with ...
1
vote
1answer
342 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 ...
1
vote
1answer
230 views

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 ...
1
vote
1answer
2k views

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 ...
1
vote
2answers
4k views

Can't login to SQL Server in Single User mode

I've been trying all sorts of different combinations of startup flags to SQL Server 2008 R2 Express and I can not get past this error: Login failed for user 'LOCALSERVER\Administrator'. Reason: ...
1
vote
1answer
1k views

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 ...
1
vote
1answer
2k views

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 ...
1
vote
1answer
466 views

Report Server w/ SQL 2008 R2 Express - Can't login to Manager URL

I just installed Report Servicing addon (Advanced Services) to a local SQL Express 2008 R2 server. I have the configuration tool and setup the proper URLs but when I connect to them I get permissions ...
1
vote
2answers
229 views

Is this server core intallation possible: DC + SQL + Sharepoint 2010?

I would like to setup a test staging virtual server. If at all possible I'd like to use just one virtual machine. These are the software requirements: Windows Server 2008 R2 Domain controller Web ...
1
vote
1answer
428 views

Taking SQL Server database ownership after the original owner has left the company

I have inherited administration responsibility for a SQL 2008 R2 server at work. The previous database administrator has left the company, and can no longer be contacted. At this point I have: Full ...
1
vote
2answers
3k views

SQL Server 2008 R2 on Windows 7 Starter?

I tried installing SQL Server 2008 R2 on my machine running Windows 7 starter but got an error: An error occurred during the installation of assembly ...
1
vote
1answer
1k views

install SQL Server 2008 R2 on Chinese Vista fails: Checks if existing performance counter registry hive is consistent

PerfMonCounterNotCorruptedCheck Checks if existing performance counter registry hive is consistent. Failed The performance counter registry hive is corrupted. To continue, you ...
1
vote
1answer
170 views

Hourglass won't go away in SQL Server 2008 R2 Management Studio

... after I add a column to a table. I've just started using 2008 R2 Management Studio, but I have a few years experience with 2005 Management Studio. Also, I am connecting to a 2005 instance of a ...
1
vote
0answers
44 views

SQL Server 2008 R2 log shows backups (I/O suspend, resume) several times an hour

I am troubleshooting a server issue that may or may not be related... On my SQL Server 2008 R2 instance running on Windows Sever 2008 R2 (VMWare), the logs show: Each database is backed up every 6 to ...
1
vote
0answers
31 views

SQL Server 2008 R2 Express Edition (local) gone after reinstall [closed]

I ran into a problem with triggers wich stopped me from logging into my databases. I hoped that reinstalling the software would fix the problem but instead it created a diffrent problem, my sql server ...
1
vote
0answers
24 views

SQL Server 2012 licensing Downgrade [duplicate]

Our vendor is requiring us to upgrade existing accounting software db from sql 2000 to sql 2008 and my boss wants unlimited connection to db. Can i use sql 2012 per core instead of sql 2008? from my ...
1
vote
0answers
25 views

Should SQL Server backups be scheduled in SQL Server Agent or as a Scheduled Task?

I have inherited a system where a system where our database is backed up by identical scripts, one set up in SQL Server Agent and one set up as a Scheduled Task. Both are running at the same time, so ...
1
vote
0answers
133 views

SQL Server Replication - How to connect to a system via computer name rather than IP address in Amazon AWS?

In Amazon AWS, VPC, I am trying to setup replication in SQL Server, and have three servers setup with port 1433 RDP open (1 web, two SQL). I can RDC into each server. From the web server, I can ...
1
vote
0answers
285 views

Losing connection to SQL Server on the same machine?

I've installed our SQL Server driven software on a client's computer. This consists of SQL Server 2008 R2 Express, and using ADO/SQLOLEDB drivers on a brand new Windows 8 64bit machine. The problem ...
1
vote
0answers
80 views

SQL Server: Worse performance on a new server

We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on ...
1
vote
0answers
321 views

SQL Server distribution agent cleanup job causes blocking

I am using SQL Server transactional replication, and have noticed that on a daily basis all of the publications for a distributor are being blocked when the distribution agent cleanup job executes. I ...
1
vote
2answers
2k views

Unable to start sql service when TCP/IP is enabled under SSCM - SS Network Configuration

in the Console , SQL Server Configuration Manager I get error 10048 when start sql service and this in event history: The SQL server service terminated with server-specific error. Only one usage ...
1
vote
1answer
119 views

High CPU utilization on server

Server Configuration: Virtual Dedicated Windows Server 2008, Xeon Processor 1.6GHZ, 4GB RAM MS SQL Server R2 Express IIS 7.0 .NET Framework 4.0 Problem: Very slow response of the ...
1
vote
1answer
337 views

SQL Server 2008 R2 marked for unload due to memory pressure

I noticed the following error message on a development server that I'm working on. Can anyone tell me what this means? AppDomain 21 [mssqlsystemresource.sys[runtime].21] is marked for unload due to ...
1
vote
3answers
495 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 ...
1
vote
1answer
336 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 ...
1
vote
1answer
89 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, ...
1
vote
2answers
132 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 ...