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
1 answer

SQL server 2008 database

i am getting following error in all my websites when i am trying to access the database from websites. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not…
ankit jain
  • 1
0
votes
1 answer

Is it possible to batch restore backups and remove users from databases in MSSQL 2008?

We're having to do an emergency migration of all of our MSSQL databases from a dying box to a new shiny instance of SQL2008. Unfortunately, we're having to do it by restoring from nightly backups (.bak files). Is there a way of: Automating the…
poolski
  • 124
  • 1
  • 3
  • 10
0
votes
1 answer

Enable remote access to SQL Server 2008

I've just built a virtual SQL Server 2 node cluster using VMWare workstation. The windows cluster has been created, SQL has been installed on both nodes and added to the cluster, all latest updates have been applied, but I'm trying to connect to…
Jeremy
  • 913
  • 2
  • 10
  • 19
0
votes
1 answer

Upgrading SQL Server 2008 to 2012

I have SQL Server 2008 running on my development machine that I wish to upgrade to the 2012 release. In your experience, is it better to use the upgrade wizard or to remove the SQL Server 2008 and do a clean install?
Dr. Greenthumb
  • 113
  • 2
0
votes
1 answer

Problems Installing SQL Server 2008 on Windows Server 2008 R2 Standard SP1

I'm attempting to install SQL Server 2008 on Windows Server 2008 R2 Standard with SP1, and am failing the "Operating system supported for edition" operation in the Installation Rules portion of the install. Can anyone shed some insight into why I'm…
Tim S
  • 111
  • 3
0
votes
3 answers

SQL Server Setup failure

i uninstall sql server 2008 r2 and then install it but now i receive an error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code =…
Mohsen Sarmast
0
votes
1 answer

How to detach a sql server 2008 database that is not in database list?

I installed SQL Server 2008 on Windows 7. Then I created a database. After 2 days I reinstalled Windows and SQL Server. Now I am trying to attach my database file, but I have encountered the error below. I think that the files are like an…
Amir
  • 1
  • 1
0
votes
1 answer

Steps to recreate SQL Server Instance

I'm writing a disaster recovery protocol at work - a protocol that describes how to create a SQL Server instance from scratch in case that the PROD server will be unavailable. We have SQL Server 2008 Enterprise. We have a valid backup procedure but…
Roni Vered
  • 101
0
votes
2 answers

Scaling web application with SQL Server 2008 database

I have a database which has 90% of read only tables. 10% of the tables has writable data. We need to scale the ASP.NET application.We need to add more users who will not be writing to the database. We are thinking of adding another server and…
John
  • 1
0
votes
1 answer

Azure SQL database says it's full, but contains nothing

Got a database in azure called Logging, which contains a table Log. Select count(*) from log returns 0 The database is empty. Attempting to insert says it's full. Azure control panel reports it as being full (more than full, actually), but I don't…
NibblyPig
  • 328
  • 1
  • 4
  • 14
0
votes
1 answer

Can a network failure cause a user to be removed from SQL as an authorized user?

We are trying to get to the bottom of our issue. We have a service that connects as MyDomain\ServiceAdmin to a SQL 2008 database. I believe we have just setup database mirroring too in case the DB/network goes down and we lose connectivity, but we…
Alex K
  • 103
  • 6
0
votes
2 answers

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 node will have one schema
Amr Monjid
  • 1
0
votes
1 answer

SCCM cannot connect to SQL

I'm trying to install SCCM on my machine, but for some reason, I get this error: I think I've tried everything listed in the tutorials... I restarted my SQL-service My account is a sysadmin I'm not using Dynamic ports I've changed the default…
Michiel
  • 101
  • 3
0
votes
3 answers

Unable to locate any server in SQL Server 2008

I am a newbie. I recently installed SQL Server 2008 on my server. When I try to login, it does not show me any server when in Browse (see below) What could be wrong? Please let me know.
meetpd
  • 115
  • 4
0
votes
2 answers

Moving database to new server

I'm restoring a backup of a production database to a new server. The new server also hosts the application which makes use of the database. As such I'd like to use the same user/pass combination to connect to the database. The user is also included…
Ropstah
  • 205
  • 5
  • 11
1 2 3
…
99 100