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

learn more… | top users | synonyms

2
votes
3answers
3k views

Database Mirroring Properties Page Missing

I am having a problem with one database on my SQL Server 2005 production server. A number of databases are already set up for mirroring, however when I right click and go to properties in SSMS, on ...
1
vote
1answer
29 views

How to handle replication post SQL Server 2000/2008 migration?

I have two servers; server A host SQL Server 2000 and server B ( a remote server) host SQL Server 2005. I replicate data between these two servers using transactional replication. I recently migrated (...
3
votes
0answers
215 views

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete ...
1
vote
2answers
105 views

How to free up disk space on a drive which has BiztalkMsgBoxDB_log file in it

I have been asked to analyze a issue regarding one of the biztalk servers. I was asked to free up space on a particular drive, where I found the only file BiztalkMsgBoxDB_log.bak is taking up close 90%...
3
votes
2answers
32k views

how to change sql server product key

my version of sql server 2008 Enterprise edition has expired and I have a new key how to change the old key without uninstall or any modification to the installed server or instances.
0
votes
1answer
682 views

SQL service log on account

I installed SQLServer 2008 Express and pretty much took all the defaults. After about a week of running an app that hits this database I changed the administrator password for the server. About a day ...
1
vote
0answers
53 views

Repeatedly prompted to restart the computer when installing SQL Server 2008 R2 on a x64 Win 8.1 machine

I am trying to install SQL Server 2008 R2 on a Win 8.1 x64 bit machine. When running the installer, I get the Reboot Required check failing the install. I have tried rebooting, no difference. I ...
8
votes
6answers
14k 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
33 views

Running SQL Server based Program Via VPN

I have recently set up a site-to-site VPN. Location A has a PC running windows 7 (we'll call it Computer1) that acts as a server for a point of sale program. The program uses SQL Server 2008 to store ...
10
votes
2answers
78k 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. ...
8
votes
5answers
9k views

SQL Server Timeout on first attempt

I'm having a strange issue where I try to attach to SQL Server 2008 running on a second computer (both machines running Win7 64-bit), either through the Data Sources in Visual Studio or via the SQL ...
20
votes
8answers
63k views

SQL Server 2008 Express - “Best” backup solution?

What backup solutions would you recommend when using SQL Server 2008 Express? I'm pretty new to SQL Server, but as I'm coming from an MySQL background I thought of setting up replication on another ...
0
votes
0answers
1k views

Error in install sql server 2008 rn [closed]

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 'H:\...
2
votes
0answers
1k views

SSMS stuck scripting database objects

SQL Server Management Studio sits stuck, after scripting all objects in a database. Except it didn't script all objects in a database. i scripted all the objects in an SQL Server 2008 database from ...
3
votes
5answers
3k views

Enable row level compression on all tables and indexes

One of the (optional) requirements for the Works With SQL Server 2008 test is that row level compression is enabled on all tables and indexes. We have an existing database with a lot of tables and ...
3
votes
3answers
10k views

MS SQL Server 2008 sa account locked out and Windows Authentication login is greyed out

The sa account got locked out and even though mixed mode authentication is enabled. When I select "Windows Authentication" the Username and Password fields are greyed out. The username field contains ...
3
votes
2answers
7k views

Does splitting out Data, Logs, and TempDB matter using a SAN with SQL 2008

I'm not a server admin. So be gentle. But I was just at a conference and in one of the training classes the Instructor explained some SQL DBA best practices. One of which was to separate out Mdf,...
-1
votes
2answers
66 views

Database sql server Mirroring or replication

I have SQL server 2008 R1 with standard edition. I have a large database i.e. 500GB that i.e. growing rapidly 10GB a month .It is a cloud based solution. We have another data center where the ...
0
votes
5answers
6k 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
6answers
6k views

cannot connect to sqlserver 2008 express on windows 2008 server r2

windows 2008 server r2 installed sql server 2008 express sp1. also installed sql server management studio. how ever am not able to connect to sql server thru the management studio. error message show ...
1
vote
1answer
61 views

How do I see processes from all users in SSMS2008?

I only see my own connections/processes in the new activity monitor... whereas in the earlier versions of SSMS you could see everyone's. Do I need to change a setting or something?
0
votes
2answers
826 views

Is an ms-sql/excel connection two way?

When I connect to an external data source on my MS-SQL server using Excel, is it solely an import, or can I edit the data residing on the MS-SQL server right from Excel? I have a user (the DBA, funny ...
2
votes
1answer
116 views

Is there any gain from using multiple files in SQL server for raid-5 configuration?

We are setting up a server with five 240GB ssd as raid-5 configuration into one logical drive. We're planning to partition the logical drive into four drives on windows server. In SQL server, would ...
0
votes
1answer
2k views

Cannot Connect to SQL Server 2008 R2 from Sharepoint Server

I have installed SQL Server 2008 R2 on dbserver and Sharepoint 2010 on webserver. When trying to configure Sharepoint to use the database installed on dbserver, it says it cannot connect. Then I ...
1
vote
1answer
68 views

Using Linked SQL Servers from a different server

I have 3 machines that are involved in running a SQL script: JumpBox - A machine that serves as a stable point for automation to run. ReportBox - A machine that holds reporting databases and logic. ...
0
votes
0answers
13 views

schema specific object access in sql server is not happening after restoring backup

I have an application which is accessing sql objects(stored procs/tables) etc which are defined under a schema 'A' for example A.my_stored_proc. This application is working fine as intended when I ...
1
vote
2answers
7k views

Error creating ODBC connection to SQL Server 2008 Express

When creating a System DSN, I get the error: Connection failed: SQLState: '08001' SQL Server Error: 2 [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a ...
2
votes
1answer
121 views

MSSQLServer2008\Instance, Why?

I'm aware of the possibility to create instances but i don't know a real good reason to do it. This way one has per definition at least two sqlserver services running, but what for should this be good?...
0
votes
1answer
3k views

How do I uninstall an instance of SQL Server 2008 from my computer?

I've just set up SQL Server 2008 Express on my computer, kind of as a learning tool. Unfortunately I've seem to installed a number of instances to get it working. I would like to uninstall all but one ...
0
votes
1answer
18 views

sql server 2008 cant insertproduct key

I am trying to install SQL Server 2008 in a Windows Server 2008, but when i have to enter the product key, all option are blocked, and I can´t put the key or select a evaluation version.
0
votes
2answers
6k views

Can't access Windows Internal Database in SQL Server 2008 - login fails

Trying to recover some disk space by shrinking the size of our WSUS database, or at least figure out why it's so big, I tried to connect to the Windows Internal Database in SQL Server Management ...
2
votes
5answers
7k views

Cannot add witness to my mirroring setup

I'm trying to set up mirroring with a witness using my 3 dedicated servers running SQL Server 2008 R2. I've set up everything as described at this blog post Mirroring seems to work fine between the ...
0
votes
0answers
62 views

Event 1033 in Windows Event Viewer for SQL Server 2008

Every single morning I come in to find that SQL Server has logged another 3 or 4 of the following events on one of our servers: Log Name: Application Source: MsiInstaller Date: ...
10
votes
2answers
24k views

How to enable remote connections for SQL Server 2008?

How do I enable remote connections on an SQL Server 2008 installation? I have created a rule in the windows firewall to allow traffic through port 1433, but that does not seem to be enough.
11
votes
10answers
60k views

Can't remotely connect through SQL Server Management Studio

I have setup a SQL Server 2008 Express instance on a dedicated Windows 2008 Server hosted by 1and1.com. I cannot connect remotely to the server through management studio. I have taken the following ...
3
votes
2answers
820 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
4
votes
1answer
2k views

SQL Server PowerShell cannot find path error

I cannot use Set-Location to change to a database. I have loaded the SQL Server snapins. I can use Set-Location to get to SQL\Localhost\SQLEXPRESS\, and I can show the paths under the server node with ...
0
votes
0answers
13 views

Website's users hits load balancing issue [duplicate]

We have one customer's server, one website is working in IIS, we are facing one issue in this that when customer is testing by "https://loader.io" and it gives the load test result that when 1000 user'...
1
vote
2answers
175 views

Unable to connect to remote MS SQL Server 2008 Express SP3 instance by name

I am trying to connect to a remote MS SQL Server 2008 SP3 x86 Instance using it's name. At the first glance all seems to work well (e.g. it is possible to connect to the server locally and ...
3
votes
1answer
4k views

Ram recommendations vs SQL DB size

we have a medium sized SQL db of around 40GB, and are about to move it to a new box with server 2008 r2 x64 an expensive contractor has just come in and said we need 72gb of ram so that the whole DB ...
0
votes
0answers
8 views

Mail Queued Never Sent [closed]

I am running this command, which will return results if I run it straight in a new query window in SSMS, but when I run this exact syntax it just shows a message of Mail queued The mail is ...
1
vote
1answer
67 views

Altering policies in policy based management to look at even which happened only in last 24 hours

I am using SQL server 2008 Standard edition. I am using Policy based management with policies which come with SQL server during installation. I want the policies to only look at events that happened ...
0
votes
0answers
53 views

SQL witness not monitored in SCOM

SCOM 2012 SQL Server 2008 R2 principal and mirror with SQL Express witness I've imported the SQL Server MP into SCOM and it is detecting and displaying my principal and witness in the mirroring ...
7
votes
2answers
26k 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
1answer
23k views

Installing SQL Server 2008 R2 32bit on 64bit : WoW64 error

It looks like it's possible for 2008 SP1: previous question. But what about current newer 2008 R2 version? We plan to use single 32bit Express edition package to install on every machine. However, ...
0
votes
0answers
148 views

What does the sqldumper_errorlog file contain?

The SQL Server error logs are continually showing (along with many more messages) BEGIN STACK DUMP. * User initiated stack dump. This is not a server exception dump. Followed by External dump process ...
2
votes
1answer
68 views

Deactivating Cores option in SQL Server 2008

What is actually the difference between deactivating 2 of the cores as in this screenshot and having a dual core machine I guess is not the same as having a dual core machine, right? Do you know ...
0
votes
0answers
55 views

MSSQL - Can Maintenance Plan wait for Agent Job Task to be completed?

I did start a Maintenance Plan project with Execute SQL Server Agent Job Task box. I added another task on success event. I realized that I was wrong. The second task is executed in parallel, because ...
-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 ...