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

learn more… | top users | synonyms

0
votes
1answer
262 views

Trouble with redirect alias name in SQL 2008 R2

I'm working with a team of developers who have SQL instances installed in different places. For the purposes of having one config file for our local machines (instead of having a config file for each ...
0
votes
1answer
48 views

Restore backup from SQL 2008 to 2008R2 with standby

We are looking to replicate our production database to another instance so that when reports are run, it doesn't slow down the application to the point of being barely usable. I had limited success ...
2
votes
3answers
609 views

Speeding up SQL Server temp table processing with a RAM Disk

A system we are developing consists of a Web app frontend, and a backend that does a lot of data processing using stored procedures in SQL Server 2008 R2 (please, don't ask why...). These stored ...
1
vote
1answer
64 views

SQL Server 2008 R2 Failover Clusters behaviour on multiple failures

I'm testing the resilience of one of our test systems. We have 2 x DB (SQL 2008 R2 on Server 2008 R2, running in ESXi VMs) arranged in a Failover Cluster. Shutting down the Active SQL Server service ...
2
votes
1answer
134 views

SCCM 2007 SP2 - Could not connect or execute sql query

I've run into SQL database connection issues while trying to install SCCM 2007 SP2. I have a VM setup that hosts SQL Server 2008 R2 SP2 installed using default settings and setting the services to ...
0
votes
0answers
154 views

SQL Server 2008r2 SP2 Manual Install Error

I am receiving an error I have never seen before, nor can I find any info on the net. When I try to install SP2 for SQL Server 2008r2 I receive the following error. Cannot find the value of the ...
1
vote
1answer
188 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 ...
2
votes
2answers
124 views

Moving SQL Server between domains

If a Windows Server machine hosting SQL Server 2008 R2 is changed to another domain, what steps definitely and might need to be done for SQL Server before and after the new domain is joined?
2
votes
1answer
177 views

How to improve poor SQL Server performance

We have a virtualized environment using VMware vSphere 5.0 U1 which hosts our Microsoft SQL Server and have very poor performance. the host server is a HP DL360 G5 with xeon X5450's, and the disk ...
1
vote
1answer
103 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
2k views

How to enable Ad Hoc Distributed Queries in SQL Server 2008 R2

When I run a query with OPENROWSET in SQL Server 2000 it works. But the same query in SQL Server 2008 generates the following error: SQL Server blocked access to STATEMENT ...
0
votes
1answer
73 views

Alter new and existing session Command Timeout value

My first post so please me... I’m a self-taught DBA in a manufacturing environment full of engineers who like to fiddle. Although I have not given them sysadmin or any explicit extra rights I have an ...
0
votes
1answer
98 views

Cannot see linked server properties in SQL Server 2008 R2

I configured a linked server in SQL Server 2008 R2; mirroring what currently exists in SQL Server 2000. When viewing the properties of an existing linked you, you cannot see (or edit) any ...
0
votes
1answer
105 views

Separate Database For SQL Server Reports

I have researched this on here (and other sites) quite a bit. I feel like I am missing something simple. So please direct me to another posting or help answer my question. Basically, we have out ...
0
votes
1answer
55 views

Install SQL Report Server on a separate server using remote instance for dbs

I have been googling a lot to find the installation guide on how to install Reporting Services on a application server, but couldn't find anything. I already have an SQL server on another machine and ...
0
votes
0answers
30 views

Instant File Initialization Turned on but file grows slower in sql server 2008r2

What are the reasons a data file (8 GB) could take a long time to grow even if Instant file initialization is turned on in sql server 2008r2? The sql service account has admin access to "Perform ...
0
votes
1answer
137 views

DateTime of data file autogrowth in sql server

How to determine the datetime of the last auto file growth of a data file in sql server 2008, if I dont have a trace file at the time of autogrowth. One of the online posts mentioned that the ...
0
votes
0answers
50 views

Installing active SQL server instance on passive node, no network settings field

I'm installing an active-active MSSQL server 2008r2 instance. While trying to install the second active node on the first passive node, I get to the network configuration page and there are no ...
0
votes
1answer
194 views

SQL Server extension fails with PHP, IIS

I am having difficulties getting the SQL Server extension to work with PHP on Windows Server. The installation went fine and I'm able to load phpinfo through the browser. However, when I enable ...
3
votes
2answers
144 views

Can I use a powershell script to install db/website when the database is separated from the webserver?

My boss is on vacation and I'm supposed to have this installation script done by the time he returns. Unfortunately, I've realized that the script I developed won't work on the target server setup and ...
1
vote
0answers
259 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
1answer
219 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 ...
0
votes
1answer
104 views

unable to connect to remote sql server from SHDSL router

Got a new leased line network to our office that came with a SHDSL router (Watson). Currently, we are unable to use Sql Server management studio to connect to remote Sql databases. It errors out ...
0
votes
1answer
44 views

cannot log in to sql server 2008

I'm trying to log in to SQL Server 2008, but the installation and the log_in user were done by my friend. Now I'm to trying to open the management studio but I get the error message "login failed" ...
0
votes
2answers
170 views

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 ...
0
votes
4answers
72 views

SQL 2008 vs. SQL 2008 R2 - which to choose? [closed]

We should change our SQL 2005 Server to SQL 2008. My bet was 2008 R2 SP1 but in this week we had several problems with it (related to CU7 and CU8) and as far I see, R2 has bugs - confirmed by ...
0
votes
1answer
166 views

How can i find what's 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 ...
0
votes
1answer
120 views

Things to consider when applying hot fix to production server

We are currently using Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) as our production data warehouse database. I ...
0
votes
2answers
809 views

Looking for robocopy ipg number

I have a robocopy job that creates a problem every time it runs. It saturates the bandwidth in such a way that no other traffic can get through. I read about the /IPG flag but am going in circles ...
0
votes
2answers
162 views

What is the correct authentication mechanism when there are users inside and outside the domain?

We have a Windows 7 enterprise desktop data entry app for mobile (laptop) users with local SQL Express 2008 R2 Express db that syncs data with an SQL Server 2008 R2 Server db. Users may go off ...
1
vote
1answer
2k 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 ...
0
votes
3answers
152 views

Connecting to database without instance name

When I'm trying to connect to my database, I need to provide the instance name like so: 192.168.10.10\SQLEXPRESS I'd like to be able to just connect to my database without having to type the ...
0
votes
2answers
457 views

Advised auditing method for MS SQL to track changes made to a specific table by a specific user?

What is the best method for tracking changes or logging the queries done to a table by a specific user when the person is using Management Studio? I'm using 2008 R2 Express Edition and want to ...
0
votes
2answers
2k views

What's the difference between shrinking files or database in SQL Server?

I need more space in my development environment and need to shrink my database (or files) in SQL Server. Should I chose "shrink files" or "shrink database" to free most disk space?
1
vote
1answer
114 views

Will more memory help my CPU-peaking SQL Server 2008 R2

I'm supporting a system running against a SQL Server 2008 R2. The server is a single-CPU box with 8 GB of memory. As traffic has increased, the server has started saturating, peaking to 100% CPU ever ...
1
vote
2answers
1k 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 ...
2
votes
1answer
69 views

SQL Server Report Services Not Configuring

This is kind of Frustrating as I know I am doing everything right, however SQL Server Reporting Services are not configured: To Configure I did these following steps Opened Reporting Services ...
1
vote
1answer
113 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
306 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 ...
0
votes
1answer
318 views

cannot connect to sql server express from sql server standard

... like my title says... I cannot connect to my instance on sql server express from sql server standard... I have tried disabling firing wall and checked sqlbrowser is started but for some reason I ...
0
votes
2answers
123 views

Differential backup of new sql database fails until full backup is made

I have setup a job that runs every night and makes a full backup of all databases on the server. During the day, another job makes differential backups every few hours. The problem comes when a new ...
0
votes
1answer
97 views

Database Engine Services Required to install ssrs?

I have already installed sql server 2008 express and ssms on my vm... now I am trying to install ssrs on the same machine and keep getting "database engine error". Should I skip this (click here ...
0
votes
1answer
221 views

Sql Server database logs “missing”

Here's the problem we're having: In the applications that are using the databases we get errors like: The log for database 'redactedDatabaseName' is not available. Check the event log for related ...
-3
votes
1answer
99 views

Which is easier to configure Replication for: MySql 5.5 CE vs SQL Server 2008r2 Express? [closed]

As the question states, which server is easiest to setup replication for? My needs are: A local master and a remote (VPN connected) slave. I am no where near expert in either database so which ...
0
votes
1answer
328 views

Error in install sql server 2008 rn

When running the SQL Server 2008 setup, I receive the following error message: TITLE: Microsoft SQL Server 2008 R2 Setup The following error has occurred: Unable to open Windows Installer file ...
2
votes
1answer
220 views

Powershell (sqlps) lastbackupdate not changing despite having run a sqlserver backup

I'm using Powershell to check last backup times across all our sqlserver databases. This seems to work really well, but I've got a question If I run this (a cut-down version of the actual script): ...
2
votes
1answer
59 views

Maximum number of articles allowed in SQL 2008 R2 for merge replication

Does anyone know of a Microsoft documented limit for the maximum number of articles in merge replication for SQL Server 2008 R2? I have THIS link that specifies the max for SQL 2012 (i think), which ...
0
votes
1answer
119 views

In place upgrade from SQL Server 2005 to 2008

Situation - Server running windows server 2003 and SQL Server 2005. About 18 various databases on the server. We need to upgrade to Windows Server 2008R2 and SQL Server 2008. We can't afford to ...
0
votes
0answers
452 views

Automate Sql Server 2008 R2 Express install - silently and pre-configured

I want to create a .MSI installation of my app. One of the things that should be installed it's the SQL Server 2008 R2 Express, but i want it to be installed silently, pre-configured for all client ...
-2
votes
2answers
156 views

What replication should I use for my Sql Server

We have a dedicated server that will host our client's database for a web portal. To connect to this database, you need an ip address. I figured I'd try Merge Replication since I already have the ...