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
3answers
56 views

Restore MS SQL 2008 Database from files

is it possible to restore a MSSQL server by copying its directory/data files? I have a damaged hard disk and was able to salvage the C:\Program Files (x86)\SQL Server 2008\MSSQL\MSSQL10.MYDATABASE ...
1
vote
6answers
4k views

Restore Database User to Server Login on SQL Server 2008

We have a database backup we need to restore on a server that doesn't have the logins for the database... all the users are in the database though so we are hoping we can restore it this way? I've ...
5
votes
1answer
115 views

32-bit SQL eating up RAM on 64-bit OS until SQL is brought to its knees

This may be related to other threads I've seen, but I need a solution to this specific situation. The SQL instance continuously consumes more and more RAM until after about a week it's grabbed over ...
2
votes
1answer
84 views

SQL Named Pipes across Site to Site VPN

Running into SQL issues and I can find the exact problem already posted here on SF. I have a SQL server running on a 192.168.16.x subnet on one side of a site to site VPN. I have a workstation on a ...
0
votes
1answer
41 views

SSIS Execute from Job on server - Show Colors on package

We are running SSIS on SQL Server 2008 R2 I have a SSIS package that gets executed from a job on the server ever morning and it can take a few hours to complete. When you execute the package from ...
1
vote
3answers
101 views

SQL Backup Is Taking All My Hard Drive Space

I have a job that I run every day to backup my SQL database. I just bought a band new server and was going to transfer the database backup over to the new serer and restore it. Our database isn't as ...
0
votes
2answers
73 views

why I dont have Audit option in SQL server 2008?

I am using SQL server 2008 but still in my sql server management studio I dont have audit option under the Security menu though login, Server Rols, Credentials are there.Why?
1
vote
1answer
2k views

Unable to start SQL Server Instance 2008 R2 - DB file corrupt

I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is " The log scan number passed to log scan in database ‘master’ is not valid. This ...
3
votes
3answers
717 views

Remote SQL server connection failure

I am trying to connect to my MSSQL server 2008 web instance and im failing horribly... i get the error 26 and before you jump on me i have done these Check the spelling of the SQL Server instance ...
0
votes
1answer
97 views

How to create a new sql server instance without installation media

I'm relatively new to SQL Server installations ( however I use extensively the Management Studio), the situation is that I have a server (machine) where the SQL Server has been installed ( not by me ...
2
votes
3answers
4k views

What would be the optimal disk config for SQL Server 2008 R2?

We have a new Dell R710 server that came with the following storage configuration: 8 x 146GB SAS 10k 6Gbps disks 1 x Perc H700 Integrated Controller (2 x 4 disks - 2 ports each supporting 4 disks) ...
2
votes
3answers
1k views

Performance differences between SQL Server 2008 Standard and Enterprise

Aside from features like partioning, indexed views and parallel indexing, are there any actual performance differences between the Standard and Enterprise editions of SQL Server 2008? Also, is the ...
0
votes
0answers
39 views

SQL DTC Failover Scenario

We had an interesting scenario in our clustered production environment last week. SQL 2008/R2 two boxes clustered on Win 2008/R2 in Active/Passive mode. On the active node A, the clustered MS/DTC ...
10
votes
6answers
16k views

Diagnosing Microsoft SQL Server error 9001: The log for the database is not available

Over the weekend a website I run stopped functioning, recording the following error in the Event Viewer each time a request is made to the website: Event ID: 9001 The log for database ...
0
votes
2answers
76 views

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
1
vote
3answers
569 views

Change tracking in SQL 2008

What edition of SQL Server 2008 does change tracking require? Change Data Capture requires Enterprise from what I've read, I'm hoping change tracking will run on standard. TIA Dave
0
votes
0answers
71 views

SRSS Client Print Module must be downloaded every use

I am currently having an issue with SQL Server Reporting Services. Everytime a user clicks the print button for the report, the user must install the ActiveX client print module. The issue is that our ...
0
votes
3answers
54 views

SQL Server 2005 features in comparing DB schema /tables

Is it possible to create or do it from SSMS to compare two different schema ? I need to compare database table in my current production DB to see which one is different in order to generate delta ...
1
vote
1answer
273 views

SQL Server 2008 R2 error: 18456, state 1: login failed for “domain\username”

I can't seem to authenticate to my SQL server using the following command: sqlcmd -S myserver -d mydatabase -U user -P password It always says, error: 18456, state 1: login failed for ...
1
vote
3answers
821 views

Could SQL Server 2008 replication be used with NLB to allow unlimited scaling of reporting servers?

We are currently using transactional replication in SQL Server 2008 to keep a secondary reporting server synchronized with a primary database server. This has been working weel and keeps some of the ...
0
votes
0answers
421 views

SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component

I have a huge 200MB .SQL file. When I try to open this in SQL server management studio 2008, I get the error -Error HRESULT E_FAIL has been returned from a call to a COM component. What could the ...
1
vote
1answer
65 views

SQL Server does not enforce encryption rules

I am forcing encryption on my MS SQL server. My intention is to reject any client connection that does not use SSL to connect. Here are my detailed steps : makecert -r -pe -n ...
1
vote
1answer
89 views

Cannot Connect to MsSql2008 R2 Database Engine, While Connecting to Other Services

I have installed MsSQL 2008 R2 on my computer as I have installed always before. But unfortunately this time, I cannot connect to Database Engine while I can easily connect to the other services like ...
-2
votes
2answers
81 views

SQL Server: Network pauses after installing cheap SATA card: Is there a solution?

At the risk of being assigned to the "bad DBA" club... I did something desperate, and may have to undo it. Problem: After installing a low cost eSATA board, my SQL Server is intermittently ...
0
votes
1answer
202 views

Login failed for user 'sa'. … [CLIENT: 59.48.47.215]

I have an Amazon EC2 instance and i don't have anything running on it yet but my event log is full of below error "Login failed for user 'sa'. Reason: An attempt to login using SQL authentication ...
1
vote
0answers
2k views

SQL Server services not showing up in SQL Configuration Manager

I have SQL Server 2008 R2 (RTM) running on a Windows Server 2008 R2 (SP1) box. This instance exists primarily to run SSRS in SharePoint integrated mode. When I open SQL Server Configuration Manager, ...
4
votes
2answers
906 views

MS SQL access to restored database without sysadmin role

I have databases from different projects on one server. I can't give all developers administrative (sysadmin) access to the databases. They have to have the permissions needed to create and restore ...
1
vote
4answers
212 views

Sql Server Backup Compatibility - 2008 with 2005

I'm hoping to restore a backup from SQL Server 2008 into a Sql Server 2005 instance. Is there a way to have Sql 2008 back up in a format that 2005 will understand?
0
votes
4answers
2k views

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some ...
0
votes
1answer
93 views

The timeout period elapsed prior to obtaining a connection from the pool

I have a WPF application which I want to use on multiple machines. I can connect to it on the same machine but I can't connect from another machine. I know I have to enaple TCP/IP connection and I ...
0
votes
1answer
44 views

Restore From Database not showing database I want to pick

In Management Studio I want to restore to a point in time from an existing database. However, the databases that I can choose from in the drop down list don't include the one I want to choose. And ...
2
votes
4answers
11k views

The database myDb is not accessible. (ObjectExplorer)

I'm developing an ASP.NET MVC3 web app, which connects to a SQL Server 2008 R2 database. Everything was working fine, until I started getting this error: The database myDb is not accessible. ...
0
votes
1answer
133 views

SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers

We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters. We started getting alerts two to three times ...
2
votes
4answers
10k views

Error when restoring database (Windows 7 test environment)

I have a windows 7 operating system as a test environment. I have SQL Server EE installed with two instances, named as test and production. I took a full backup from AdventureWorks database from test ...
0
votes
1answer
519 views

Error when connecting to Named Instance as a Linked Server

I have a MS SQL2008 server running a root instance and a named instances. SQL001\. SQL001\Pilgrim When I connected to SQL001\Pilgrim I can set-up a link to the default instance SQL001\. no ...
1
vote
1answer
167 views

single application multiple users through thin client

I am having one application built in C# winforms. In the backend I am using SQLSERVER 2008 Express. The application is used remotely through thin clients. My problem is that when one user is using my ...
0
votes
1answer
63 views

sa account not working anymore on SQLServer2008

I have been running SQLServer 2008 for some years now on my laptop. At a certain point I cannot login anymore with my sa account (mixed authentication turned on). I get the error message 233. This ...
2
votes
1answer
350 views

SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created

I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
0
votes
0answers
34 views

Dummy transaction to check if a system is up

We want to send a dummy transaction through our system (Application - DB) to ensure it is still up every minute. If the transaction fails we are alerted - Thereby knowing within a minute if there is ...
-1
votes
2answers
471 views

Can there be two machines with the same server name (SQL SERVER) in the same network? [closed]

I have a program in excel that connects to several sql servers using servername and instance. My question is, what would happen if there are two servers (machines) with the same servername in the same ...
1
vote
1answer
480 views

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot ...
0
votes
2answers
28 views

SQL 2008 Failure after compressing HDD

I've absent-mindedly let Windows Server 2003 compress a HDD to try and save some space. That same drive contains an instance of SQL Server 2008. Since compressing, all the Databases have taken ...
0
votes
0answers
26 views

Merge_Replication_Tables_Not_In_Sync

We've merge replication configured in our environment(1 Publisher, 3 Subscribers) and We know by default merge replication is bi-directional. Its working fine in case of inserts i.e, if a row is ...
-2
votes
1answer
49 views

Is is safe to upgrade SQL server 2008

I have a windows vps with sql2008 express r2 (with tools) installed, one of my clients require full-text search feature. Sql 2008 with advance services has that feature. So my question is, is it ...
6
votes
5answers
6k 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 ...
0
votes
0answers
59 views

First login fails on hglab administrative console

I've set up a Server with Windows 2008R2 and Hglab 0.3.10, which is supposed to be a mercurial server. I've followed the instructions where at the end they say I should head to the website and start ...
-2
votes
2answers
70 views

Uninstall SQL Server

how do I uninstall SQL Server 2008 manually? Add/remove programs does not uninstall everything. Thanks in advance.
0
votes
0answers
176 views

Website display of character encoding does not match up with config files

I have a language problem which I couldn't solve, no matter what I did, I request your help with this. I do web-publishing using Xampp on Windows 2008 Server R2 Enterprise (Language: English, ...
3
votes
4answers
4k views

How to recover the database which is accidently deleted using sql server 2008

How to recover the database which is accidently deleted using sql server 2008?
0
votes
1answer
94 views

SQL Port 1433 needed in SQL Server2008 IP Field for remote connection

I just installed SQL Server 2008 on my server. I do it often enough to forget what to do so I read through a couple of MS installation instructions. I installed with no issues. I tried to remote ...