A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.
SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here
Questions tagged [sql-server-2008]
1806 questions
0
votes
1 answer
physical memory usage is high on production sql server
Possible Duplicate:
SQL 2008 Memory Usage
I'm going threw high physical memory usage in SQL Server.
It always around 90%.When i reboot the server, it will initially good but end of the day it will around 90to 95% physical memory usage.…
Daby
- 1
- 1
- 1
0
votes
1 answer
"could not find the database engine startup handle sql 2008 r2" error
I have hit a brick wall here... I am trying to install ssrs in one of my other VM. After installing sql server express and ssms(which installs successfully), I have tried to install ssrs(making another instance "MSSQLSERVER")... I always get this…
EagleFox
- 127
- 8
0
votes
3 answers
How do I resolve the error "The file exists" when restoring a cube backup?
I'm trying to restore a cube backup (a .abf file) using SQL Server Management Studio, but I'm getting the error message:
The following system error occurred: The file exists. . (Microsoft SQL Server 2005 Analysis Services)
(yes, there really are…
Ant
- 111
- 1
- 6
0
votes
2 answers
Installing a second instance of SQL Server 2008
I am trying to install second instance of SQL Server 2008 Enterprise Edition on my Windows 7 machine using a network server, local service, and my admin account.
However I keep getting the error shown below. Can somebody please let me know which…
user1159648
0
votes
1 answer
Unable to install SQL Server 2008 Express SP1
I am facing difficulties installing the MS SQL Server Express 2008 Service Pack 1. I already have MS SQL Server Express 2008 installed and all I want to do is to install the SP1 however I get following error message even though all features are…
Bat_Programmer
- 93
- 6
0
votes
1 answer
How to configure Reporting server on SQL Server 2008, Windows 7
I want to configure reporting server on sql server 2008.I m using Windows 7
Operating System . I configure reporting manager using Reporting Services Configuration Manager and provide Service Account , Web Service Url, Execution Account and…
Attri
0
votes
1 answer
What are the things to look out for when adding other domain user to your IIS?
I have a Windows Server 2008 R2 called Jack11 that joined a domain called Watson.org.
It has IIS 7 installed.
From my understanding, we need to add the following into the web.config file
Jack
- 107
- 1
- 3
0
votes
1 answer
SQL Server 2008 instance's listening on mulitple ports on a cluster
I have three SQL Server 2008 instances running on a cluster. SQLInstance1 is listening on default port 1433, SQLInstance2 is listening on port 39999 and SQLInstance3 is listening on port 49999. Can SQLInstance2 listen on port 39999 and 49999 when…
ClusteringSQL
- 3
- 1
0
votes
2 answers
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 the item "Active Tasks", selecting "Create a…
sammarcow
- 245
- 1
- 3
- 14
0
votes
1 answer
How can I uninstall SQL Server Express from Windows Server 2008?
I installed Windows Server 2008 as my OS, but I dislike the SQL Server Express which it provided by default, so I changed to SQL Sever 2008 Enterprise.
The problem is, I don't know how to remove the SQL Server Express edition. In Programs and…
Stallman
- 101
- 3
0
votes
1 answer
SQL Server 2005 connection to SQL Server 2008 R2
I having trouble with SQL Server 2008 R2 Express. I installed it and the service is running but SQLexpress, but without success. I even tired to uninstall SQL Server 2008 R2 and I could it said that I have cluster node failed.
Someone can help me…
Apocaliptica61
0
votes
1 answer
Difference between having two filegroups and having two databases
I have a thousand web servers writing their logs to a SQL Server 2008 database. The log information can be up to 100 GB per day, and we keep 1 month’s worth of logs.
Each day, we run queries on the log data and store the results of the queries in…
cm007
- 187
- 1
- 4
0
votes
1 answer
lost session after putting DB in single user mode
I have same problem as here: SQL2005 Stuck in Single Mode User
Only difference, I am using SQL Server 2008. Tried everything, nothing works. When I run my
ALTER DATABASE [CS_10.1] SET MULTI_USER
or
ALTER DATABASE [CS_10.1] SET MULTI_USER WITH…
tombom
- 105
- 7
0
votes
1 answer
SQL server 2008 are prevented form being installed on Windows 7 - error message "access is denied "
I have recently installed Windows 7 enterprise . When I try to Install Microsoft SQL server 2008 EXPRESS edition , I get an error message : "Access is denied" just right after the installation process begins . I looked and found workarounds in…
Michalis
- 1
0
votes
2 answers
Configuring SQL Server 2008 log shipping
I am trying to configure log shipping from a cluster of two Windows Server 2008 R2 x64 machines running SQL Server 2008 R2 to a single machine running the same OS and DB. Setup appears to go okay (no errors) but at the scheduled time I get the…
andyjohnson
- 131
- 2
- 11