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

learn more… | top users | synonyms

-3
votes
1answer
29 views

System databases are in standby…how can I make them editable?

My System Databases are stuck in a standby/read-only state. RESTORE DATABASE msdb WITH RECOVERY does not seem to have had any affect. How can I get them out of the standby state?
2
votes
1answer
441 views

Windows Essential Business - limitations/experience?

Our company is mid-size, and we are considering the purchase of both Exchange server and SQL server. Buying all the software products and CAL's seperately seems kind of expensive, so I'm wondering if ...
2
votes
2answers
3k views

Problem in restoring differential backup

I tried to restore differential backup but i got a following error: Restore failed for server .(Microsoft.Sqlserver.smoextended) Additional Information: system.data.sqlclient.sqlerror:The file '...
2
votes
2answers
3k views

Hide database from other users in SQL Server 2008

I have created a database in SQL Server 2008 and it shows in server object explorer to all users that can login to SQL. I want to hide it from those users, I want it to be viewable by me only. How ...
1
vote
2answers
4k views

Disabled SSLv3 to combat Poodle now cannot connect to SQL “Connection forcibly closed by remote host”

I have disabled SSL3 on my web server to combat the Poodle Vulnerability and now I am unable to connect to my SQL server using SQL Authentication. I just get "Connection forcibly closed by remote ...
2
votes
1answer
1k views

SQl server 2008 permission and encryption

i have made columns in some of the tables encrypted in sql server 2008. Now as i am a db owner i have the access to encode and decode the data using the symmetric key and certificate. But some other ...
20
votes
3answers
28k views

How to check progress of DBCC SHRINKFILE?

Is there a way to find out the progress of DBCC SHRINKFILE statement? Here is how I was running it dbcc shrinkfile('main_data', 250000) I am running above statement on both SQL Server 2005 and ...
1
vote
0answers
100 views

What are the limitations of using a scheduled Windows Server Backup instead of SQL Server backups?

We've taken over development and server admin for an e-commerce site, and the client has opted for a well-specced dedicated server, including a second drive for daily Windows Server Backups. However ...
3
votes
5answers
11k views

SQL Server 2008 R2 vs. SQL Server 2008 R2 Express

What differences exist between the pay and free version of MSSQL2008R2? Microsoft SQL Server 2008 R2 http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx and Microsoft SQL Server 2008 R2 Express http:...
1
vote
3answers
433 views

attach / detach mssql 2008 sql server manager

An external consult wrote a guide on how to copy a database. Step two was detach the database using Sql Server Manager. After the detach the database was not visible in the SQL Server Manager... Not ...
0
votes
1answer
43 views

How to handle a large table on SQLServer

There is a database on our server that has a 120GB backupfile. The server has limited diskspace and I cant even restore a second copy of that database. There are mainly 2 tables in the databse that ...
0
votes
1answer
376 views

PHP Trouble Configuring SQLSRV

I am working on learning PHP, and one of my goals is to be able to connect to an SQL Server database. I am on a virtual Windows 2008 Server and have 32-bit PHP 5.6.0 installed. I have downloaded the ...
1
vote
1answer
53 views

Single row user security in MS SQL 2008 R2

I have a SQL Server 2008R2 question regarding making a single row in an odd way. situation: I have a student records database in which ~ 100 students might in-process in a given day. They enter a ...
-1
votes
1answer
54 views

Use reporting service configuration to configure the database source name

So im upgrading to R2. When i get to the Reporting Services Authentication step i get the error: There are validation errors on this page. Click ok to close this dialog box. Review errors at the ...
0
votes
1answer
132 views

SQL Server 2008: Delete database while Rollback is in progress

I am trying to remove a test database in which a database modification failed. The resources being consumed by the rollback action in SQL are affecting production databases (users reporting slow ...
4
votes
1answer
3k views

Can I safely delete MS SQL Server Error Log?

I have some huge log files, which are taking up all the space on a PC's hard drive. Is ok to simply delete the log file: C:\Program Files\Microsoft SQL Server\MSQQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG....
1
vote
2answers
59 views

SQL Server file size

There is something I don't understand with the MSSQLServer mdf files. I have been asked to replace a file with its previous version (the database has been modified between the two versions), but when ...
0
votes
1answer
39 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
919 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
13k 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.
3
votes
3answers
8k 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
106 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
2k 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
3k 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
64 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
5k 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 ...
2
votes
1answer
217 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
41 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
106 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 ...
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
1answer
73 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
592 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
3k 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
85 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 ...
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
12k 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
160 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
614 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
254 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
5k 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
85 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
201 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
707 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
5k 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 ...
3
votes
1answer
56 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
397 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 ...