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

learn more… | top users | synonyms

3
votes
1answer
200 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
2
votes
1answer
655 views

Tables in the SQL Server “master” database, will they cause problems?

Folks, please be kind on me... I'm just an 'accidental' DBA due to our DBA resigned, so I'm totally a newbie in DBA... You see, I have this application, "ESET Remote Administration Server" (ERAS) ...
1
vote
1answer
341 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 ...
0
votes
1answer
76 views

Performance issues with windows server, sql-server and apache

I am running into some performance issues on my server, which runs Windows server 2008, SQL Server 2008 R2, and apache. This is a purely internal website, and is accessed by a total of about 6 ...
1
vote
1answer
32 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
3k views

SQL Server linked server: “Cannot start more transactions on this session.”

i am trying to perform an INSERT operation against a linked server: DBCC TRACEON (3604, 7300) BEGIN TRANSACTION INSERT INTO LIVE.Contoso.dbo.Events (EventGUID, EventDate, LoginGUID, UserGUID, ...
0
votes
1answer
1k views

TCP/IP connection to SQL Express works on HALF of the clients in a WORKGROUP

So far I have learned the following facts about Microsoft SQL Server Express, including version 2012, and earlier versions like 2008R2, and 2008, and for the most part all the way back to SQL Server ...
0
votes
0answers
205 views

SQL Server Cannot see tables in Object Browser where Login = db_owner

A colleague is trying access a particular SQL Server over a remote link. He can login to the server (via SSMS) with the SQL Server credentials I supplied, but although he can view tables/etc in the ...
1
vote
1answer
513 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 - ...
0
votes
1answer
509 views

Different versions of SQL Native Client in SQL Server 2008 R2

I have this error when I try to connect from a Server called: AplicationServer1 to another server in the same domain Kobl, called DatabaseServer1 SQLSTATE[28000]: [Microsoft][SQL Server Native Client ...
-3
votes
2answers
640 views

SQL Server 2008 r2 SP2 IA64 Vs x64 Vs x86 [closed]

I want to install SQL server 2008 r2 on a windows server 2008 64x inside a VM . but I currently have three different files inside the SQL server 2008 ISO image the files ends with IA64 , x64 , x86 ; ...
0
votes
1answer
388 views

Error in trying to delete a local publication for DB replication

I logged in in db ad sa (super admin). I want to remove a publication made using management studio wizard (right click on Replication/Local Publications/ New publication) After trying to delete I ...
1
vote
0answers
82 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 ...
2
votes
1answer
389 views

SQL Server cannot be reached by name only by IP

I have several computers (XP) connected to domain controller (2008R2). Last time I had to change IP address of the SQL Server 2008 R2 (simple instance, no clustering or replication). DNS has been ...
0
votes
1answer
685 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
74 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 ...
3
votes
3answers
2k 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 ...
2
votes
1answer
190 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
226 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
373 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
421 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
407 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
221 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
139 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
5k 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
87 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
140 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
197 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
150 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
33 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
184 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
51 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
313 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
172 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
496 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
503 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
121 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
48 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
376 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
79 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
268 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
129 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
2k 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
193 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
4k 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
542 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
608 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
124 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
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 ...