Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008]

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

1806 questions
0
votes
0 answers

I must have done something wrong installing sample database

I downloaded file SQLEXPRADV_x86_ENU.exe (version 10.00.1600.22), and used it to install SQL Server 2008 Express with Advanced Services, which I think has capabilities comparable to SQL Server 2008 Enterprise. Upon install, all Prerequisite…
Frank Bruno
  • 1
0
votes
1 answer

Where can I get Windows2003 SP2 FileStream HOTFIX?

When I was installing SqlFailover Cluster, at one stage before installing SQL Server it shows: Windows2003 FileStream HOTFIX failed. So I think this is not installed. Where can I get it?
Cute
  • 130
  • 1
  • 7
0
votes
3 answers

Increasing vCPUs for Server 2003?

I have a VM running Server 2003 and SQL Server 2008 on VMware ESXi. Can I safely assume this configuration can cope with a change to the number of vCPUs? Are there better solutions to address the demands of the guest? More info below... After an…
Liam
  • 123
  • 1
  • 9
0
votes
0 answers

Identical tables, different sizes?

I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express). I need to add another subscriber, and come to discover that my database has outgrown the 10GB…
happydba
  • 1
0
votes
1 answer

How to allow a SQL Login to see only ONE database

i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases. thank you
Pritesh
  • 1
0
votes
3 answers

How to connect to ms sql express?

I have sql express on my local network computer, I created new account, I enabled server auth, and when I am trying to connect to this account from local machine, everything works fine. But when I try to log in from a network pc, it says that login…
ojek
  • 127
  • 1
  • 1
  • 8
0
votes
0 answers

SQL failover cluster on single ESXi host

I'm setting up a virtual environment consisting of 10 VM's with 2 primary SQL databases required. The infrastructure allocates two pairs of SQL 2008 R2 Enterprise edition (VM's). The pairs are recommended in order to achieve redundancy, however…
alex9183
  • 105
  • 7
0
votes
2 answers

SQL Server Hosting

I am looking for a SQL Server Hosting Provider that meets the below requirements: Using SQL Server 2008 Standard or Enterprise Edition (No EXPRESS) Allows directly connecting from SQL Management Studio Around $5 to $10 a month Don't need to store…
McGovernTheory
  • 113
  • 5
0
votes
1 answer

Restore backup from SQL 2008 to 2008R2 with standby

We are looking to replicate our production database to another instance so that when reports are run, it doesn't slow down the application to the point of being barely usable. I had limited success with SQL Server Replication, but as the…
Aaron Mason
  • 703
  • 6
  • 20
0
votes
0 answers

Download SQL 2008 R2 and install remotely with key

I have the media and product key for a copy of SQL Server 2008R2, however, I can not get my CD to the server at my data center. Is there a downloadable version (or can the trial be downloaded) of the application that I can install and apply my key…
HumanBacon
  • 311
  • 1
  • 3
  • 5
0
votes
1 answer

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 installed SSMS on Sharepoint server and tried to…
Jigar
  • 1
  • 1
  • 1
0
votes
1 answer

SQL 2008 R2 Clustering AND DB Mirroring (Async)

I've got a MS SQL 2008 R2 Fail-Over Clustered Instance running between two Windows 2008 R2 servers using the inbuilt Windows Clustering features, that is working with a DTC and Quorum with a disk based Witness. This has been working fine for months…
Ben Bowman
  • 113
  • 2
  • 3
  • 13
0
votes
1 answer

Can I move all DB files on SQL server 2008 to a different logical drive and then change the drive letter?

I've got a SQL Server 2008 (std) with 19 DBs. Because I'm replacing my SAN, I need to move all the DB files to a different volume. I've moved individual DBs before using MS's recommended method: detach DB, move files, reattach. But I really…
1.618
  • 669
  • 1
  • 4
  • 17
0
votes
1 answer

How to best move system DBs from SQL 2005 to SQL 2008 R2?

I'm in the process of moving from SQL 2005 to SQL 2008 R2. Moving the production DBs and logs is straightforward, through either detach/attach or backup/restore. (new hardware, so I have the old system running in parallel with the new one during the…
RickNZ
  • 150
  • 6
0
votes
2 answers

Sql Server 2005 Express & Sql Server 2008 side by side

I have a Win2003 system that serves CAD drawings thru an SQL SERVER 2005 Express. I need another installation of SQL SERVER 2008 for an ERP on the same server. There are any known problems or issues about this configuration ? Thank you.
PeterMmm
  • 895
  • 16
  • 28
1 2 3
…
99 100