Tagged Questions

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

learn more… | top users | synonyms

2
votes
1answer
90 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
124 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
420 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
518 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
154 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
128 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
288 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
116 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
575 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
282 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
68 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
238 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 ...
-2
votes
2answers
168 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 ...
-1
votes
2answers
332 views

SQL Server 2008 R2 installation hangs

On a freshly installed Windows Server 2008 R2 Standard SP1 I am installing SQL Server 2008 R2. After configuring setup, install starts, but then it will hang on: ...
4
votes
2answers
3k views

Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?

I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still ...
1
vote
2answers
681 views

Cannot install SQL Server 2008 R2 on Windows Server 2008 R2

We are attempting to install SQL Server 2008 R2 on a Windows 2008 R2 SP1 box. We keep running into errors at the end of the install - "the service did not respond to the start or control in a timely ...
2
votes
1answer
464 views

MS SQL Server is accessible locally but not over the internet

When I try to access a named instance of Microsoft SQL server 2008 R2 SP2 on the local network, I have no problem. But when access it outside office from the internet, I can not connect to the ...
0
votes
2answers
2k views

SQL Server 2008 R2 Replication log reader could not execute sp_replcmds

This log reader agent worked perfectly for several months until the user referenced in the error was removed from the domain. After that time the error 'The process could not execute 'sp_replcmds' on ...
1
vote
3answers
644 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 ...
0
votes
1answer
1k views

error when trying to load SQL server 2008 R2 native client x86

There's technically 2 problems interlinked with each other here... I'm currently working on connecting to a mssql database from a website and testing everything through Xampp on a VM. When running ...
0
votes
1answer
173 views

Can't install SSRS 2008 R2 default instance

I have a SQL Server 2008 R2 that had Reporting Services included and uninstalled. Default Instance. I now need to add Reporting Services to the installation and I am getting an "Instance Name in use" ...
4
votes
1answer
1k views

SQL Server Maintenance Plan: Rebuild Indexes and Transaction Log Backup File Size

In my nightly maintenance plan, I was doing everything - reorganising and rebuilding indexes, updating statistics, etc. There's an hourly maintenance plan that does a transaction log backup. I ...
1
vote
1answer
399 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 ...
0
votes
1answer
713 views

Enable remote access to SQL Server 2008

I've just built a virtual SQL Server 2 node cluster using VMWare workstation. The windows cluster has been created, SQL has been installed on both nodes and added to the cluster, all latest updates ...
7
votes
1answer
7k views

How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?

I'm managing about 90 SQL Server instances and need a query to determine how much memory has been allocated to each instance. Please note, I'm not asking how to set it, just to see what it's currently ...
3
votes
2answers
1k views

Attempting Unauthorized operation - SQL 2008 R2 install

I've been banging against this for a few days. Keep getting this unauthorized error when trying to install SQL 2008 R2 on a Windows 7 machine. I've changed permissions on the key, does not fix... ...
2
votes
1answer
290 views

Windows 2008 R2 Enterprise SQL Server Enterprise 2008 R2 only using half the memory

We have built a new 2 CPU, 6 core server, with 96GB of RAM. SQL server Enterprise Edition was configured with a maximum memory setting of 92GB. A few days after adding into the load balancer I have ...
1
vote
3answers
4k views

SQL 2008 R2 Named Instance Client Connectivity Issues?

We're upgrading our software from using SQL 2000 to 2008 R2. Our customers will be installing an update which uninstalls 2000 and installs 2008 R2 under the same instance. So if no instance existed, ...
-1
votes
1answer
56 views

SQL Server 2008 R2 remote connection

I am having problems making my ms sql server 2008 take remote connections, local workes fine. I have enabled the TCP/IP and the server browser server in the sql server config I have opened the ...
0
votes
1answer
69 views

ASP project and SQL Server 2008 database connection

I have a hosted Windows Server 2008 virtual machine. It is for my Internet sites. I installed IIS services on my Windows Server 2008. It is normal work. I installed SQL Server 2008 R2 on my Windows ...
0
votes
2answers
200 views

OLTP Sql Server RAID configuration with 10 disks, allocation Unit and disk stripe size

On a new db server I only have 10 disks to play with, The usage is about a booking every 3-5 seconds, so not high volume, I know compromises have to be made, but my initial thoughts are - DISK 1 ...
0
votes
1answer
116 views

Can a network failure cause a user to be removed from SQL as an authorized user?

We are trying to get to the bottom of our issue. We have a service that connects as MyDomain\ServiceAdmin to a SQL 2008 database. I believe we have just setup database mirroring too in case the ...
1
vote
1answer
2k views

Quorum Disk size for Windows 2008R2 failover

I am setting up a two node failover cluster for SQL Server 2008 R2 on Windows Server 2008 R2. Microsoft recommends minimum 512MB size LUN for the quorum disk and don't have a recommendation for the ...
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, ...
0
votes
1answer
564 views

Lync using SQL 2008 R2 SP1 - Publish Topology error

Error that shows in the web page opened by the Topology builder: Error: An error occurred: "Microsoft.Rtc.Common.Data.SqlConnectionException" "A network-related or instance-specific error ...
2
votes
1answer
65 views

How do I troubleshoot a server I can't get logged into?

This morning I am unable to log into SQL Server because it appears to be busy doing something, so much so that CPU usage is constantly at 98%-99%. I am guessing that something has gone wrong with the ...
2
votes
1answer
207 views

Electricity gone off while shrinking database, how can I recover my database?

While executing a shrink on a 25GB database, the electricity has gone down, and I can't access my database. It shows as "In Recovery". How can I recover it?
0
votes
2answers
60 views

Can not create a linked server between SQL Server 2008 on a desktop and my laptop

I'm having an issue getting the linked server to connect between a desktop and my laptop. Both have SQL server 2008 and the link is coming from the desktop to my laptop. Also, both computers have ...
0
votes
1answer
80 views

Parallel Processing in SQL Server 2008 R2

I want to run my 2(two) SQL Server 2008 R2 Enterprise Edition as if one server. If one server is too busy, system should direct the requests to other server. How can I do this? Thanks..
1
vote
2answers
133 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 ...
1
vote
1answer
471 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 ...
2
votes
4answers
2k views

Do I really need a 128GB pagefile

I'm running out of space on one of my servers and the only space that I can free in the immediate is re-sizing the enormous pagefile. The server has 128GB of memory and is currnetly set to ...
0
votes
1answer
74 views

Updating SQL Server 2008 R2 using slipstreamed source

I have a requirement to create a SQL Server 2008 R2 SP1 setup media. I have done this using slipstream method as recommended by Microsoft. I can only use this to create new installation. But is there ...
1
vote
1answer
748 views

SQL Server 2008 R2 GHOST CLEANUP hanging processes

2008 R2(SP1) - 10.50.2500.0 (X64) Hi, I am having the following problem intermittently on my development machine. I am running some T-SQL in a FOR loop. During each loop iteration, first we delete ...
-1
votes
1answer
197 views

Difference between SQL Server 2008 Express and Workgroup in regards to CAL's

I am currently using SQL Server Express edition, and am thinking of upgrading to SQL Server Web or Workgroup edition. My question is what restrictions will I experience with the introduction of CAL ...
3
votes
2answers
567 views

How to change max server memory in SQL Server

I was trying to change the max server memory for my database server, and I accidentally saved it as "4" instead of the number I wanted to enter. Now I can't even connect to the server. Is there a ...
0
votes
1answer
2k views

Can I downgrade SQL Server 2008 R2 Standard To Web Edition?

We are running a SQL Server 2008 R2 Standard Evaluation version. The client has decided they don't want to pay for full SQL Server standard and feel the Web edition is suitable. Can I downgrade SQL ...
0
votes
1answer
236 views

SQL Server 2008 R2 tempdb files configuration

On sql server 2008 r2 how do I check that tempdb files are configured for one data file per physical processor core? I have been looking on SQL Server Studio screens, but I haven't been able to find ...
0
votes
2answers
194 views

what is a good frequency for setting up snapshot replication in sql server 2008

My requirements: I have a publisher database from which I intend to replicate to a subscriber. Not all tables need to be replicated. Amount of data could be ~20-30GB. Given the above: is ...
2
votes
2answers
254 views

SQL Server 2008 R2 Cluster with HOSTS file entries to active node on the application servers

I questioned the decision of a colleague concerning the use of a HOSTS file entry on an application server (standard SQL database backed .NET solution), which I think would cause connections to the ...