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

learn more… | top users | synonyms

0
votes
1answer
34 views

Transferring 3 SQL databases from both SQL Express 2005 and Standard to a new physical server

I am trying to figure out the best method for transferring SQL 2005 databases from 2 different physical servers to a new server running windows server 2008 64bit. I own a fully registered copy of ...
1
vote
1answer
716 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 ...
2
votes
3answers
12k views

Does Windows Server 2008 R2 standard edition support cluster?

I want to install sql server 2008 r2 edition in a cluster environment. Can I use Windows Server 2008 R2 Standard edition? Thanks.
2
votes
3answers
5k views

How do I find the root cause of Memory pressure failure on an SQL server 2008?

One of the servers I have been performance monitoring started throwing the following warnings from the Resource-Exhaustion-Detector: Windows successfully diagnosed a low virtual memory condition. ...
1
vote
1answer
27 views

Does the SQL Server 2008 Recovery Model and Log Size Impact Memory Usage for sqlservr.exe process?

Problem We have a SQL Server instance (2008) running our software with what we consider a small number of users (about 30 concurrent connected to the server at any given time) As a vendor, we're not ...
1
vote
3answers
1k views

Connect to remote SQL Server instance using Windows Authentication

How can I connect to a remote instance of SQL Server (on my VPS) from my local machine using Windows Authentication? By default, if I try to connect using this method, the username is my computer ...
1
vote
4answers
2k views

Should Tempdb's Log file be on a different drive than the data files for best performance?

We have tempdb on its own drive array split into several files for performance. We have DB logs files on non-data drives. We question if we should put the tempDB log file on the log drive for all DB's ...
2
votes
1answer
4k views

How can we recover/restore lost/overwritten data in our MSSQL 2008 table?

I am in serious trouble and I am seeking professional advices here. We are using MSSQL server 2008. We removed primary key, replaced exiting data with new data resulted losing our critical business ...
0
votes
1answer
42 views

SP with xp_cmdshell gives an error in the MessageQueue, but executes successfully in Management Studio

I have a SP, which calls xp_cmdshell in it. This SP is being used in a MessageQueue. The SQL server and Agent services are configured using a Domain service account, and this service account has a ...
1
vote
2answers
3k 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 ...
8
votes
9answers
4k views

What should I do about someone trying to brute force attempt to login to our SQL Server 'sa' account?

Looks like someone or something is trying a brute force attempt at logging into our production SQL Server instance with the 'sa' account. They haven't been successful because our 'sa' account is ...
9
votes
1answer
67k views

What is a SQL Server instance?

When I install SQL Server 2008 Express in prompts me to create an instance and aborts if I don't. Then I see that information in an entry in Sql Server Configuration Manager on SQL Server Services. ...
2
votes
1answer
214 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
1answer
40 views

Automatic log truncation when scripting from SQL 2008 to 2005

I have to convert a sql server 2008 database to a sql server 2005 database. As far as I understand it, the only reliable way to do this is by scripting the database to an earlier server version. Now, ...
-1
votes
1answer
2k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
-1
votes
1answer
67 views

Using multiple IPs on one machine for web and game server

We are looking to host a game server. The game we are going to be setting up a server for is subject to DDoS from other servers, players, etc. Many other server and administrators have pointed out ...
0
votes
0answers
67 views

Upgrading SQL Server from 2008 to 2012 doesn't respect existing install paths

Basic Information : Running Microsoft Windows Server 2008 with MS SQL Server 2008 (version 10.0.5869), trying to upgrade to SQL Server 2012. Currently working in a cloned VM of our production server ...
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
0
votes
0answers
32 views

How To Open/Edit Existing Report Server in Business Intelligence Development Studio

Hi we have a reporting server running in one of our server. I have been tasked to edit one report. I am new to reporting services and the one who made it is no longer part of the company. I have ...
0
votes
1answer
64 views

Which Website/User uses the Server resources on Windows Server 2008? [closed]

I have a shared webhosting server based on Windows 2008/IIS 7/Plesk 11.0 .Most of the time Server's CPU usage is over 80% and MS SQL Server process uses most of the CPU/RAM resources. I want to know ...
0
votes
2answers
510 views

F5 LTM 10.2 and MSSQL 08R2

We have a mirrored SQL server setup with a pair of LTM's holding the mirror VIP. We're trying to setup a health monitor that runs a query against both servers in the mirror and directs traffic to the ...
0
votes
2answers
2k views

Run PowerShell script within a maintenance plan

I have an SQL Server 2008 database, run on a 64-bit Windows Server 2008. I created a pretty simple PowerShell script that automates a bunch of tasks. I would like this script to run as part of our ...
0
votes
1answer
26 views

Linked MySQL Server Hanging on Insert

I'm running a task every 5 minutes on MS SQL Server 2008 that links to MySQL on another server in the network. It works probably 80% of the time. The remaining 20% results in MySQL hanging, and a ...
0
votes
0answers
16 views

Windows Server Datacenter license case [duplicate]

Case like this: I have Windows Server Datacenter 2008 R2 (with CALs). I want to deploy Windows Server 2008 R2 Standard as VOSE. Then i want to deploy MS SQL Server 2008 STD on that VOSE Windows ...
2
votes
5answers
5k views

SQL Server 2008 - 2005 Compatibility

I want to use SQL Server 2008, but I'd also like to maintain a fall back position of switching back to SQL Server 2005. I know I cannot backup 2008 to restore 2005 and detach/attach won't work - what ...
1
vote
1answer
10k views

MSSQLSERVER Exception occurred while enqueueing a message in the target queue. Error 15404, State 19

I am getting a bunch of messages in the Windows Application Event Log. Here is exact text from Event Viewer: An exception occurred while enqueueing a message in the target queue. Error: 15404, State: ...
1
vote
2answers
154 views

Many huge files in Sharepoint… Any “stubbing” or “shortcutting” software exist?

I'm in an industry that uses a lot of scanned documents and large attachments (100MB), and I see our Sharepoint database growing quickly. What options do I have for managing this rapid growth? Can ...
2
votes
4answers
583 views

What should I do to scale OUT a Sql2008 database?

I'm about to scale UP our sql2008 database. Simple. But I might need to scale OUT our sql databases. For a simple scale out situation (ie distributing the processing load), are there some good ...
1
vote
1answer
211 views

SQL Server moving to new file

I am trying to do a shrink on my data file, after large delete. It is failing and I am unable to get it working. I am probably going to have to move to new data file. I am trying to find out if doing ...
0
votes
2answers
4k views

Enable anonymous access to report builder in reporting services 2008

I have a 2008 reporting services server installed on windows 2003 server. I am trying to allow anonymous access to the report builder folder so that my users do not have to select the remember ...
1
vote
4answers
4k views

Backup SQL Server DB to a remote drive

I am trying to backup a SQL Server database to another drive letter located on another network on another domain. The location has already been mapped to Z:\ and corresponds to \\10.98.76.6\Backups\. ...
0
votes
1answer
51 views

Sql server 2008 - server name changed

I have changed the computer name of the server where sql server 2008 r2 is installed. Old name is WIN-OUJEKRMGXXX and new server name is KASURDYYY When i configure replication following error occurs: ...
0
votes
4answers
1k views

syspolicy_purge_history generates failed logins

I have a development server with 3 instances: Default, A and B. It is a physical server, non clustered. Whenever the syspolicy_purge_history job runs at 2 am, I get failed login alerts. Looking ...
0
votes
0answers
87 views

Application logs an INSERT into database but data is not there. Where to look for debug info?

I have a PHP shell application which essentially moves data from a MySQL table to a REMOTE MS SQL Server (2008 R2) server based on a number of business rules. This routine has been working flawlessly ...
0
votes
2answers
634 views

SQL 2008 R2 express: Server Cannot open database requested in login 'xx'. Login fails. Login failed for user 'NT AUTHORITY\SYSTEM'

I have SQL Server 2000 installed on the server. I installed SQL Server 2008 R2 express edition as required for new application. The application runs on the same server which is Windows Server 2003 ...
-1
votes
2answers
739 views

INSTALLING SQL SERVER 2008 in Windows XP

Hello this is my first time in Server Fault so I wish people are as accommodating here as in Stack Overflow. So.. Heres the thing. I need to install SQL Server 2008 Express 32 Bit on a Windows XP ...
2
votes
1answer
44 views

What are the downsides of running all SQL Servers under same domain account?

I am running two SQL Servers 2012 (for Always On) under the same domain account and would like to know what are the downsides in doing so. Few articles that I have read prior setting up the servers ...
0
votes
2answers
259 views

Create Report in Microsoft Excel - Permissions Issue in Team Foundation Server 2010

I am trying to use the feature "Create a Report in Microsoft Excel" for Visual Studio TFS 2010. I am being prompted for a username and password in Excel for any given Team Project when right clicking ...
0
votes
0answers
24 views

How to solve Merge Replication Conflicts that seemingly keep coming back?

I have two servers that are set up with MSSQL 2008 R2 and are replicating to each other with merge replication. I have 52 conflicts on my replication if I right-click the publication on the parent ...
2
votes
5answers
2k views

Backing up a SQL Server 2008 R2 Database without stored procedures

Is it possible to back up a SQL Server database, but only back up the Table structures and content (i.e. not include the stored procedures, views etc?) The scenario: We have a data centre hosted ...
2
votes
3answers
3k views

Error when trying to open SQL Maintenance Plan - SSMS 2008

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not ...
1
vote
1answer
111 views

SQL Server 2008 Optimization

I've learned today, if you append to your query OPTION (MAXDOP 0) your query will run on multiple processors and if it's huge query, query will perform faster. I know general guidelines on query ...
1
vote
1answer
217 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
59 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
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
170 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
2k 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
59 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 ...
-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 ...