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
MS SQL - syncronising "a view" to another MS SQL server
Let me open by saying that I am no MSSQL expert. I'm a linux admin, so please forgive me if I should know this.
I've been asked to syncronise a view or a table from one MSSQL database to another. I've been told it's a bit like MySQL replication,…
Mister IT Guru
- 1,178
- 3
- 15
- 35
0
votes
1 answer
SQL Server reliance on Domain Controller
Just have had an interesting situation with a remote database server which I did not think happened.
The setup is server A is a domain controller in the main network, and server B is on a remote network connected back via VPN. Server B has SQL…
mike
- 103
- 3
0
votes
1 answer
How to un-install sql server 2008 analysis service only?
Initally I installed SQL server 2008 R2 Evaluation version. Then we bought licence key for SQL server 2008 R2 Web and wanted to update my licence, but unfortunately I installed analysis service when I was installing evaluation version which is not…
sumanmodi
- 3
- 1
0
votes
1 answer
opening firewall 1433 port to IP address that require a direct connection
We are upgrading from sql server 2005 to sql server 2008 and windows server 2008 R2.
New server is behind a firewall, we have 30 or so windows XP machines, that will require the port 1433 to be open, because they are old Windows applications that…
Max Marchevsky
- 11
- 2
0
votes
1 answer
DateTime of data file autogrowth in sql server
How to determine the datetime of the last auto file growth of a data file in sql server 2008, if I dont have a trace file at the time of autogrowth. One of the online posts mentioned that the "Modified Date" on the windows explorer is the last time…
user65649
- 3
- 1
0
votes
1 answer
SQL Server 2008 intermitent error 40 running parallel queries
Here's our setup :
We are using Red Gate SQL Multi-Script to run queries on our ~1000 databases which reside on a single SQL Server 2008. SQL Multi Script can be configured to run queries in parallel on multiple databases at the same time, which…
MaxiWheat
- 237
- 5
- 12
0
votes
3 answers
Cannot start SQL Server PowerShell
Have you guys had this problem where, when you start PowerShell from SQL Server, it throws an exception like the following?
Cannot resolve alias 'cd' because it
refers to term
'Microsoft.PowerShell.Manag
ement\Set-Location', which is not
…
dance2die
- 2,011
- 7
- 32
- 41
0
votes
1 answer
Dynamics AX 2009 Falls Over when SQL Cluster Rolls
We had an issue on one of our production database nodes which caused it to fail over to another. This caused a brief outage whilst the service rolled. This temporary glitch however was enough to cause some AOS servers to crash (i.e. the services…
JohnLBevan
- 1,214
- 7
- 22
- 46
0
votes
1 answer
Backing PDF files and SQL server DB
I have my own Windows Server an Asp.Net application hosted live. The application allows users to upload CV PDF files and I have the DB also on that server. Which steps should I take to ensure that all data is there all the time even in case of hard…
Tim Tom
- 681
- 2
- 7
- 8
0
votes
1 answer
HA Options for Windows Servers
We are looking at different options to allow us to stay up and running when our primary datacenter (DC1) goes down for any reason. What is the main difference in having a offsite server updated all the time using log shipping as a warm standby?…
Alex
- 259
- 1
- 9
0
votes
2 answers
Server failed, can I retrieve my database from the my hard disk?
I have an old server running Windows Server 2003 R2. Windows got corrupted due to an improper shutdown. I attempted to repair the Windows installation, but it made things worse (it gets to the desktop, but there is no start menu and most of the…
Alex
- 125
- 1
- 4
0
votes
2 answers
SQL Server 2008 Remote Access
I'm having problems connecting to my SQL Server 2008 database from my computer. I have enabled remote connections as described in this answer (How to enable remote connections for SQL Server 2008?). And I have added the ports listed on the microsoft…
Timothy Strimple
- 125
- 1
- 6
0
votes
1 answer
Can't enable 'sa' account in SQL Server 2008
I'm trying to enable 'sa' account in SQL Server 2008 through the MS SQL Server Management Studio Express. When I set the properties through the 'Properties' section of the login and click Ok, there are no error messages! But when I revisit the…
CRoshanLG
- 145
- 1
- 11
0
votes
1 answer
Package run on SQL Server Job Agent - Login failed for user
I created a package on my SQL Server (2012) through the import/export data wizard which exports data to another SQL Server (2008).
I set up a job which runs this package but I get an error:
Description: Failed to decrypt protected XML node…
Rivka
- 353
- 2
- 3
- 12
0
votes
1 answer
Which Website/User uses the Server resources on Windows Server 2008?
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 how I could figure out which website is using…
Ghasrfakhri
- 69
- 1
- 7