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
4answers
413 views

Log Shipping multiple database SQLServer 2008 Standard

We currently use a fairly basic script we wrote to log ship our databases to our DR site (and back again) but want to move to a better solution. We initially discounted the inbuilt logshipping ...
2
votes
3answers
544 views

SQL 2008 - db mail issue

I have two instances of SQL Server 2008. One was upgraded from SQL Server 2000 and one was a clean, new install. The instances are running on different nodes of the same cluster, although I have ...
1
vote
3answers
3k 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
3answers
351 views

MSSQL Server is inaccessible from other domain users

I am unable to connect to other machines with the same domain and network. SQL Server 2008 is running, I can connect locally with MSSQL01\Administrator and password using Windows authentication. ...
1
vote
3answers
2k 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
3answers
645 views

SQL Server instance shuts down

I'm currently developing a new ASP.NET project hosted on a Windows Server 2008 RC2 with an SQL Server 2008 Express database. I have three SQL Server instances (for different purposes) running which ...
1
vote
3answers
393 views

2 Servers setup for redundency, backup

I presently have 1 dedicated virtual server running my website/blog/mail, etc. This is on Hyper-V with 512MB RAM. Windows Web2008. With the VM, I have these running within it: SmarterMail – for ...
0
votes
3answers
47 views

How do I update the SQL Server 2008 to include the studio?

How do I update the SQL Server 2008 to include the studio? Here is what I currently have on my machine: I assume I am supposed to clidk on "SQL Server Installation Center" From there I get this ...
0
votes
3answers
802 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
3answers
290 views

Unable to connect to local SQL Express (2008)

I'm trying to get an installation of SQL Express 2008 working, but no matter what I do I can't connect to it with management studio. I've enabled TCP/IP for the instance. I've tried connecting with ...
0
votes
3answers
2k views

Disable remote access for one user/database in SQL Server 2008

is this possible to disable remote access for one user or database in SQL Server 2008? Thanks
0
votes
3answers
101 views

SQL Server 2008 hosting (for development)

We are doing distributed development, working at home, office and sometimes at customers. We are using assembla for source-repository and we need a centralized-remote SQL Server 2008 database hosting ...
1
vote
2answers
174 views

SQL mirroring Error- SQL 2008

I am trying to configure SQL Server mirroring and I am getting the following error: The server network address "TCP://santosh-PC:5023" can not be reached or does not exist. Check the network address ...
1
vote
2answers
612 views

Diagnosing poor performance on IIS / ASP.NET / MSSQL app

I'm trying to diagnose the cause of poor performance from a third-party web application we've deployed; the environment is: ASP.NET on IIS, Windows 2003 Server SQL Server 2008 on a separate Windows ...
1
vote
2answers
294 views

not able to attach mdf file sql server 2008

I installed the sql server 2008 enterprise version that i got from mcts 433 prep kit. after installing i tried to attach the adventureworks mdf file and got the error below "the server principal ...
1
vote
2answers
171 views

SQL server availability issue: large query stops other connections from connecting

I've got a high-spec (multicore, RAID) server running MS SQL 2008, with several databases on it. I have a low throughput process that periodically needs a small amount of information from one of the ...
1
vote
2answers
3k views

Could not continue scan with NOLOCK due to data movement during installation

I am running Windows Server 2008 Standard Edition R2 x64 and I installed SQL Server 2008 Developer Edition. All of the preliminary checks run fine (Apart from a warning about Windows Firewall and ...
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
2answers
261 views

Cannot open SQL 2005 database in SQL server Management Studio 2008 R2 on Windows 7

I have Windows 7 64bit as my OS + SQL Server 2008 R2 installed. I can connect to SQL Databases (2008), but cannot connect to a SQL 2005 database. I can, however, connect to the 2005 SQL Database on ...
0
votes
2answers
40 views

using multiple schemes in a clustered sql server 2008 Database

I have a SQL server 2008 R2 database with 2 schemas, i need to enhance the performance of the server so we plan to cluster the DB, we will have 2 nodes . is it possible to separate each scheme so each ...
0
votes
2answers
314 views

Unable to shrink the transaction log file in Sql Server 2008

Am using the below to script shrink the transaction log *USE AVPC GO BACKUP DATABASE AVPC TO DISK = 'H:\DBBackup\AVPC\FullBackUp\AVPC.bak' USE AVPC GO BACKUP LOG AVPC TO DISK = ...
0
votes
2answers
658 views

Installing SQL Server 2008 SP2 fails in 2003 cluster setup

When I try to install SP2 (or simply "repair" the SQL Server installation), the dependency check finds the following problem: Rule "Not clustered or the cluster service is up and online." failed. ...
0
votes
2answers
142 views

Install SQL Server 2005 on computer with an existing SQL Server 2008 installation

I have a Windows XP 64 bit workstation. I installed SQL Server 2008 R2 Standard x64. After that, I installed SQL Server 2005 Standard x64. Installation completed with no issues, but no instance was ...
0
votes
2answers
212 views

Trouble installing SQL Server 2008

Greetings, As a developer I want to have SQL Server 2008 installed on my laptop. However when trying to install the management tools (basic and complete) it keeps whining about Another version ...
0
votes
2answers
105 views

Sql Server Database Backup

How Can I backup An Sql Server Database To My Local Drive From Remote Server
0
votes
2answers
263 views

MVC2 Application Performance on Windows Server 2008 R2 with IIS7.5

I originally posted this on StackOverflow but I feel as though the problem lies with the hardware / OS configuration. I'm hoping that someone here has had a similar experience and can offer some ...
0
votes
2answers
63 views

WIll DAC allow me to run queries on a pegged SQL Server instance?

Background: We have a SQL Server instance that has pegged out a few times in the last few weeks. No one has been able to figure out how to get on and kill processes so they have just been rebooting ...
0
votes
2answers
186 views

setting MAXDOP server default value

Hi I've a server with 2 physical processors with 8 cores each. Looking through Management Studio Shows me a tree with NUMA 0 and NUMA 1 and inside 8 childs. The current maxdop is on 0, should I set ...
0
votes
2answers
1k views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
0
votes
2answers
276 views

Custom word breakers in SQL Server 2008

We're implementing a tagging system for our site, where tags are delimited by a comma (",") and using fulltext-search in sql server to search for items tagged with something. The problem is, whe're ...
0
votes
2answers
105 views

Web Hosting Company that Allows custom SMTP servers, multi domains, .NET 4.0 and mixed hosting

I am in search of a new Hosting company. I currently use GoDaddy, but I've had enough with their service so i'm looking for a hosting company that can meet my criteria. Currently I have 10+ Websites ...
0
votes
2answers
337 views

SQL Server Snapshot Replication Subscriber (Editable or Read-Only)

I need to create a copy of my SQL 2008 R2 Enterprise database and have it located on the same server as the original. I will be using this second copy of the database as the target of a mostly ...
0
votes
2answers
126 views

Why is it recommended that SQL Server not be run on the domain contoller in an SBS 2008 system?

We are building up our SBS 2008 R2 server and had in mind to put an SQL Server on the same box, same system. First uses of the system are a local file server, VPN for the same purpose, and a central ...
0
votes
2answers
535 views

Problem with installing SQL Server 2008 SP2 on Win XP

I'm not much of an IT person but I've been struggling with this issue for hours and I hope maybe someone here will know how to assist me. I've just installed SQL Server 2008 Developer, I've chosen the ...
0
votes
2answers
431 views

Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine

At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not. I have SQL Server 2000 and SQL Server 2008 R2 installed on the ...
0
votes
2answers
283 views

Copy SQL Server data from one location to another over the internet

How can I copy certain SQL server data from one server to another without opening direct access to SQL server in the firewall? I thought of things like integration services in combination with an ...
0
votes
2answers
528 views

What is causing intermittent connections problems from web server to sql server 2008 r2?

We have 4 API servers and 2 web servers that connect to a SQL 2008 R2 server. Recently we've noticed that the web servers sometimes can't find the SQL server. This doesn't happen for every connection, ...
0
votes
2answers
340 views

Running sql server 2000 backup file on sql server 2008

I restored sql server 2000 .bak file to sql server 2008 by --RESTORE FILELISTONLY --FROM DISK = 'D:\DBHarshal\full backup august 6.BAK' --ALTER DATABASE EPICSms --SET SINGLE_USER WITH --ROLLBACK ...
0
votes
2answers
182 views

How to install SQL Server 2008 32 bit to Windows 2003 Server 64 bit?

How to install SQL Server 2008 32 bit to Windows 2003 Server 64 bit?
0
votes
2answers
545 views

Is it possible to determine the top users of SqlServer analysis services?

We're trying to figure out how many licenses we need of a desktop data analysis package which connects directly to our SSAS instance. I'd like know if it's possible to query the history of connection ...
-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.