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
6
votes
6 answers

How to recover the database which is accidently deleted using sql server 2008

How to recover the database which is accidently deleted using sql server 2008?
laxman
6
votes
1 answer

Can't restore backup from SQL Server 2008 R2 to SQL Server 2005 or 2008

I'm trying to get a backup from SQL Server 2008 R2 restored to SQL Server 2008, but when we try to do the restore we get this: The database was backed up on a server running version 10.50.1092. That version is incompatible with this server, which is…
Erick
  • 193
  • 1
  • 4
6
votes
9 answers

How do I solve MSSQL 2008 install error, "The MOF compiler could not connect with the WMI server"?

Possibly related to: SQL Server 2008 Install fails error reading etwcls.mof After manually removing MSSQL 2008 from my system (uninstall failed to remove two instances), I receive the following error when trying to re-install: The MOF compiler…
Nick Bolton
  • 5,126
  • 12
  • 54
  • 62
6
votes
1 answer

User for MSSQL 2008 Service Accounts

I want to create a Domain User that runs the SQL Service Accounts. The reason for this is that I have setup mirroring and MS recommends having the same user (a domain user account) running the services across all the the computers in the…
Campo
  • 1,609
  • 17
  • 33
6
votes
1 answer

Undo Database Restore in SQL Server 2008

I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version? -Vivek
Vivek
  • 175
  • 6
6
votes
12 answers

Move SQL-Server Database with zero downtime

Is it possible to move a sql server 2005 db to a different server running sql server 2008 without any downtime? The system is 24/7 and has to be moved to a different server with different storage. We tried copying the database, but that does not…
kcode
  • 1,825
  • 4
  • 19
  • 21
6
votes
1 answer

How can I generate a certificate request on Windows Server 2008 for SqlServer 2008 w/o IIS installed

I'm trying to generate a CSR for an SSL certificate to encrypt connections to my SqlServer 2008 instance located on a Windows Server 2008 server. Most of the documentation I've read mentions using the CSR wizard in IIS. This is a dedicated db server…
tblank
  • 73
  • 2
  • 2
  • 4
6
votes
1 answer

SQL Server Management Studio 2008 Express installation

Is it possible to install SQL Server Management Studio 2008 Express without installing the SQL Server 2008? I have now the SQL Server 2005 and SQL Server Management Studio 2005 Express on my computer.
user34110
  • 63
  • 3
5
votes
7 answers

Best way to index this very large table

I have the following table CREATE TABLE DiaryEntries ( [userId] [uniqueidentifier] NOT NULL, [setOn] [datetime] NOT NULL, -- always set to GETDATE(). [entry] [nvarchar](255) NULL ) Each user will insert around 3 entries per day. There will be…
niaher
  • 135
  • 1
  • 1
  • 9
5
votes
2 answers

Using SQL Server 2008 Management studio to connect to SQL Server 2005 databases

I have a shared hosted SQL Server 2005 at an ISP, that I can connect to from SQL Server 2005 Management Studio. However, I cannot connect from SQL Server 2008 Management Studio. I log on with SQL Server authentication (username+password). When I…
Kjensen
  • 1,039
  • 10
  • 28
  • 39
5
votes
5 answers

Would the database compatibility level affect performance?

We just migrated our Microsoft SQL Server from 2005 enterprise to 2008 standard on the same specification hardware. The databases were backed up and then restored to a clean sql 2008 install. The compatibility level is currently at 90 (2005). None…
duckworth
  • 700
  • 3
  • 10
  • 12
5
votes
2 answers

Running SQL server 2005 and 2008 on same machine?

Running SQL server 2005 and 2008 on same machine ? Is this possible/practicable ? It's only for developers and not very resource intensive - is there anyone out there who's done it ? Would be interested to hear of experiences or known gotchas. (I…
shearichard
  • 153
  • 1
  • 5
5
votes
5 answers

Don’t have permission to access SQL Server Express 2008?

I have a remote PC with SQL Server 2008 setup and allowing remote connections. I am an Admin user on the PC and have remotely connected to the SQL Server and I am trying to restore a database from backup but getting permissions denied for anything I…
Jan Zelezny
  • 153
  • 1
  • 1
  • 3
5
votes
1 answer

32-bit SQL eating up RAM on 64-bit OS until SQL is brought to its knees

This may be related to other threads I've seen, but I need a solution to this specific situation. The SQL instance continuously consumes more and more RAM until after about a week it's grabbed over 3.5 GB of RAM (remember it's a 32-bit instance, and…
scubabeme
  • 51
  • 1
5
votes
2 answers

Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?

I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still waiting to hear back on whether it's a full edition…
link470
  • 75
  • 3
  • 7
1 2 3
…
99 100