A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

learn more… | top users | synonyms

1
vote
1answer
214 views

SQL SERVER 2008 R2 INSTANCESHAREWOWDIR Issue

I am trying to install SQL SERVER R2 Express Advanced Services on my VServer (Windows 2008 SP2 64bit). The server has also a sql server 2005 express instance for plesk... I am running in the strange ...
0
votes
0answers
35 views

Linked Server Mysql to SQL Server 2008 32-Bit

I have an SQL Server 2008 64 Bit and a Mysql-Server, and would like to use a Linked Server. However I need the 32-BIT Mysql ODBC Connector for an extern Application. When I would like to connect to ...
1
vote
1answer
603 views

Trouble Publishing an MVC4 site on HostGator

I have been working on a C# MVC4 website and trying to publish it to a Host Gator shared Windows hosting account. They are running both MSSQL 2008 and mySql. We have run into some trouble when trying ...
1
vote
5answers
1k views

SQL Server 2008 Log-shipping: Without a UNC drive: how? [closed]

My real question here is... is there a tool I can use? (E.g. I have a lot to do, and would prefer not to script it all up myself!) Anyone using the redgate (hmmm, they had a tool for this, but I do ...
-2
votes
1answer
77 views

How many databases can i create per sql server license? [duplicate]

I have an enterprise edition license for my Sql Server 2008R2 and want to know how many databases can I create on it without additional licensing costs My question is not about number of databases ...
0
votes
2answers
995 views

Alias a linked Server in SQL server management studio?

Hoping someone can help - is there a way in SQL server management studio 2008 R2 that I can alias a linked SQL server? I have a server, added by IP address, to which I do not have the login ...
-1
votes
1answer
37 views

Unable to backup SQL database due to insufficient permissions

We are attempting to do an internal SQL backup of our databases, however it appears when the databases were configured the SA user account had been disabled. For whatever reason the BUILTIN\Users only ...
8
votes
5answers
8k views

How can I have SQL Server Management Studio 2008 connect to my instances automatically?

I'm running a server with 3 database instances. Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else). Would ...
-1
votes
1answer
2k views

SQL Server 2008 setup error Attempted to perform an unauthorized operation

I am trying to install SQL Server 2008 Standard Edition on windows 7 and during installation it give error: Attempted to perform an unauthorized operation
0
votes
4answers
2k views

Backup single table MS SQL SERVER

How to take a back up of single table and restore it back when I required. I mean,I need back of single table with all the indexes,constraints and data associated with that table. because I want to ...
5
votes
3answers
827 views

Does resizing a column lock the table?

What happens if I change a column from nvarchar(2) to nvarchar(10) or a column from char(2) to nvarchar(10). Does this lock, reorganize the table or does this work without any impact or downtime? I ...
0
votes
0answers
29 views

EMC AVAMAR Compatibility with SQL Server 2008 R2 in Active/Passive Clustered Mode

We are currently using EMC AVAMAR as part of our backup policy for backing up all our servers. We also have a SQL Server 2008 R2 active/passive setup. Does anyone know if EMC AVAMAR is compatible in ...
-6
votes
2answers
190 views

replacing 3 drives out of 8 in a server [closed]

We have a Dell R510 server running SQL 2008 R2 with 8 x 300GB drives running Raid 5. We (just noticed) we had three bad drives with blinking lights so we powered down the server and replaced them ...
3
votes
1answer
1k views

How To Tell If a MSSQL 2008 Database Has Transparent Data Encryption (TDE) Enabled

Does anyone happen to know if there is a way via WMI to tell whether a MSSQL 2008 database has TDE enabled? We have a large SQL estate that I'd like to survey and find out where we have TDE enabled. ...
3
votes
1answer
149 views

SQL Server 2008 R2 Temporary Login Issue

We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling. Last night, all web applications lost the ability to login to the database for 6 ...
0
votes
0answers
50 views

Clients Unable To Connect To Server Or Database

We recently moved several of our servers and VMs from one location to another. We have already go through and set up DNS and given all the correct IPs for all the machines we needed but we have one ...
1
vote
2answers
208 views

Backup microsoft SQL server 2008 to OneDrive

Is there an option to automate a backup to Microsoft Onedrive every night? The machine is a Windows server 2008 R2. I would like to to able to automatically upload my backups to OneDrive. I was ...
1
vote
4answers
4k views

Connect over WiFi to SQL Server from another computer

I tried to connect over WiFi to SQL Server with SQL Server Management Studio from another computer, but it failed. I have a computer with Windows 7 & SQL Server 2008 (lets say the server ...
1
vote
2answers
7k views

CREATE DATABASE permission denied in database 'master' … A database with the same name exists, or specified file

Background: I'm trying to get the Live Demos of Telerik's Rad Controls for ASP.NET AJAX working on my local machine in IIS 7. I'm getting an error when I view the ComboBox demo. Error I get: ...
0
votes
1answer
61 views

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other ...
1
vote
2answers
412 views

SQL Server 2008 Timeout Expired

I asked the question below on Stackoverflow without any answers, however, someone suggested I ask the question on serverfault also. Hopefully someone can help. I recently publish my ASP.Net MVC 3 web ...
0
votes
1answer
130 views

Perfomance of SQL Server on Hyper-V VM

I decided to try server virtualization and I have not had such an experience before. I installed Hyper-V Core 2012, created a virtual machine and installed Windows Server 2008. On this VM I should ...
1
vote
5answers
7k views

Remote connection sql server not working but if firewall disabled it does?

I have setup sql server express 2008 on a windows 2008 server. And i have done all the standard stuff in sql to allow remote connections. The strange thing is if i disable the windows 2008 server ...
1
vote
1answer
2k views

How can I get SeSecurityPrivilege enabled?

I'm trying to install a hotfix for SQL Server 2008 and failing on the Rule Check with "Setup account privileges" failed. I am running SQL Server 2008 Standard on Windows Server 2008 R2. Searching on ...
0
votes
0answers
46 views

Is dbcc FREEPROCCACHE safe to run freely?

I processed an administrative task in Blackboard that hits the database and its taking an extremely log time. I checked the logs and saw Caused by: java.sql.SQLTimeoutException: Query Timeout expired. ...
1
vote
1answer
5k views

SQL Server 2008 R2 database stuck in single user mode

We tried to restore a database, and it failed for some reason. Now it is stuck in single user mode. Here is what I tried: select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame ...
1
vote
0answers
28 views

SQL 2008 over the internet replication

Please excuse me for the (probably) stupid question, but SQL Server is not my main proficiency here... I have 2 SQL Server 2008 R2 servers, one in an AzureVM and another one in my local datacenter. ...
0
votes
0answers
49 views

Cannot add Domain Users to SQLServer security

I installed a win2008 server (WSQL) Its has successfully joined another Win2008 server which is the domain controller. Now back to WSQL machine, I connect it to the domain... And I install ...
4
votes
2answers
12k views

SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain

A few months ago we installed SQL Server 2012 in Windows 2008 R2 under the virtual account "NT Service\MSSQLSERVER", all good. A few days ago, one of the admins of the IT dept installed Full Text ...
0
votes
0answers
22 views

Unable to view SQL Server Agent while logged in as user

I apologize for asking with insufficient information. I have granted SQLAgentUserRole permission to one of the user in SQL server on msdb database, but when user login in to SSMS using his ...
1
vote
0answers
72 views

MSSQL Server 2008R2 Replication stall, no latency, no errors, missing data on subscriber

This morning after performing a routine database deployment of two new tables I noticed that transactional replication had stopped for more than 3 hours. When replication resumed it picked up 3+ hours ...
0
votes
1answer
364 views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
1
vote
0answers
749 views

Why does RDP freeze on Windows Server 2008 R2 in a virtual machine during high load?

We have noticed a problem where remote desktop sessions to a server will freeze when the server has high CPU load. Environment: VMWare ESX 4.0u1. Guest OS is Windows Server 2008 R2 (this is the ...
2
votes
1answer
563 views

Error on CMDEXEC job step even with proxy account defined

I’m not yet used to managing permissions on SQL Server 2008. I’m currently trying to create a SQL Server job directly from SQL with a user that isn’t sysadmin (but has the role SQLAgentUserRole). ...
-1
votes
2answers
2k views

High memory usage, where is it coming from?

I have a virtual machine (Windows 2008 Server R2 64 bit running on vmware esxi 4) with 6 GB of installed RAM. It's reporting 95% memory usage and close to 0% CPU. This server hosts some WCF services ...
1
vote
0answers
102 views

Unable to apply CU 13 to SQL Server 2008 R2

I am running version 10.50.4033 and would like to apply cumulative update 14. However, I get an error that basically says I'm not at the correct version to apply this patch. I assume I have to ...
0
votes
1answer
136 views

Taking a disk image with Windows Server Backup while SQL Server is running

I'm using Microsoft's Windows Server Backup tool on a Windows 2008 R2 Server running SQL Server 2008. I want to take a disk image of a drive on which SQL Server is running (databases are on the drive ...
1
vote
2answers
2k views

Install & Configure PHP to MS SQL Server on Windows 7 (64bit)

I have been striggling to set up the following scenario: Apache 2 (64bit) running on Windows 7 (64bit) PHP (64bit) MS SQL Express 2008 as (local) I have managed to install and configure both ...
-1
votes
2answers
36 views

SQL Mirroring on Live System? [closed]

My project has a SQL 2008 database with production data on it in use at all times. We need to move our entire production network from one hosting environment to another. We've already stood up the ...
0
votes
1answer
337 views

Manipulate SBSMonitoring Database

Our SBSMonitoring database has reached its limit (10GB). I've worked with databases in a previous job and I'm familiar writing SQL queries. Is it safe to delete entries from tables in that database? ...
0
votes
0answers
39 views

SQL 2008 R2 says access denied when logging in remotely

I have an SQL 2008 R2 server and a monitoring server both on the same physical network (but different VLANs). The monitoring server is always connecting to the SQL server to run a query and check the ...
0
votes
1answer
539 views

Backup and restore vCenter 5.5 in a Lab.

I need to take a copy of our production vCenter and run it in a lab for testing purposes. This part isn't my strong point.How do I go about this and is there any official documentation pertaining to ...
0
votes
0answers
93 views

Why is MSSQL 2008 saying @filter_clause is invalid and that articles do not exist when creating a new publication from a script?

I have a snapshot publication on a test server with a pull subscription set up on another test server (both SQL Server 2008 R2). This publication takes a snapshot of a few columns in a few tables for ...
3
votes
2answers
2k views

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database ...
3
votes
2answers
2k views

Why is my database not available?

I have one database on my server that constantly becomes unavailable. To fix, I take it offline, then back online. Looking at the event viewer there are three errors in quick succession: FCB::Open ...
0
votes
4answers
793 views

Monitor SQL Server

I am managing a very important SQL Server 2008 R2 database. I need a solution that notifies me through email if the performance of the database server is getting bad. I am imagining the following ...
-2
votes
1answer
50 views

0.5 TB SQL Server Database, is it possible to store in a standalone server? [closed]

We are facing the task of storing of 0.5 TB of data in a SQL Server 2008 Server. Is it possible to do it in a standalone server? Later we also want to query for generating statistics of the data (a ...
0
votes
1answer
108 views

How to locate the cause of a excessive memory in ms sql

We are experiencing memory issues with MS Sql 2008 R2. There appears to be a memory leak that is consistently increasing in memory usage until it gets to about 1.5 gb and then stops. We have used ...
0
votes
0answers
49 views

SqlServer 2008/2014 different Collation on column names and data?

We're trying to migrate an third party application from DB2 to SqlServer. DB2 seems to be case insensitive when it comes to column names. The problem is that the application for some reason uses ...
0
votes
1answer
74 views

How do I know which node in a cluster answers?

I have set up an NLB with two servers (nodes) which are running the same service. The filtering is single host, because I don’t want them to run at the same time, because there is data in the cache ...