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

How to check progress of DBCC SHRINKFILE?

Is there a way to find out the progress of DBCC SHRINKFILE statement? Here is how I was running it dbcc shrinkfile('main_data', 250000) I am running above statement on both SQL Server 2005 and 2008. [UPDATE] Here is the query I ran to check the…
dance2die
  • 1,961
  • 7
  • 31
  • 40
42
votes
4 answers

How do I remove a specific bad plan from the SQL Server query cache?

We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan. This query normally runs in a few milliseconds, but with this bad query plan, it…
Jeff Atwood
  • 12,994
  • 20
  • 74
  • 92
41
votes
5 answers

Remove Setup Bootstrap folder on SQL Server 2008 to free space

Is it "safe" to delete any of the subfolders in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\ from my drive to free up space? Or is it needed for upgrade/uninstall and other patches? Right now the Update Cache folder contains KB968369…
Mikael Svenson
  • 545
  • 1
  • 5
  • 9
37
votes
1 answer

What can user do with VIEW SERVER STATE permissions?

In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
29
votes
5 answers

Adding an administrator user to SQL Server 2008

How do you add an administrator user to SQL Server 2008?
kokos
  • 399
  • 1
  • 5
  • 6
28
votes
6 answers

How to rename a SQL Server 2008 instance?

How can I rename a SQL Server 2008 instance without reinstalling? For example, if the db is referenced as "MySQLServer\MSSQL2008", how can I rename to "MySQLServer\SQL2008"?
Scott Marlowe
  • 423
  • 3
  • 6
  • 9
25
votes
4 answers

Install SQL CLR types & Report Viewer 2012 on Sql 2008 server

I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008. The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the message "CLR Types for Sql Server 2012" were…
Ted
  • 353
  • 1
  • 3
  • 8
22
votes
2 answers

"'' is not a valid login or you do not have permission" on sql server installation

I have tried installing SQL Server 2008 multiple times on my machine, and I always receive this error about 3/4 of the way through: '' is not a valid login or you do not have permission. I use SYSTEM user for install, when i try to use my admin…
Alex
20
votes
8 answers

SQL Server 2008 Express - "Best" backup solution?

What backup solutions would you recommend when using SQL Server 2008 Express? I'm pretty new to SQL Server, but as I'm coming from an MySQL background I thought of setting up replication on another computer and just take Xcopy backups of that…
alexn
  • 375
  • 1
  • 4
  • 10
20
votes
11 answers

Diagnosing Microsoft SQL Server error 9001: The log for the database is not available

Over the weekend a website I run stopped functioning, recording the following error in the Event Viewer each time a request is made to the website: Event ID: 9001 The log for database 'database name' is not available. Check the event log for…
Scott Mitchell
  • 473
  • 2
  • 6
  • 13
20
votes
4 answers

How to exclude indexes from backups in SQL Server 2008

Our nightly full (and periodic differential) backups are becoming quite large, due mostly to the amount of indexes on our tables; roughly half the backup size is comprised of indexes. We're using the Simple recovery model for our backups. Is there…
Jarrod Dixon
  • 685
  • 2
  • 13
  • 23
18
votes
1 answer

Alias to SQLEXPRESS

I have developer edition from SQL Server 2008, but now I have a piece of software with a hardcoded connection string: Data Source=.\SQLEXPRESS;Initial Catalog=db;User Id=sa;Password=1234; Now I tried adding an Alias in the configuration tool to…
Roger Far
  • 341
  • 5
  • 17
18
votes
2 answers

I cannot connect to my local SQL Server 2008?

I've just installed SQL Server 2008 and I cannot connect to it with SQL Server Management Studio. My intention is to just let my local windows user be authenticated but I am not totally sure how to do that. In the connect dialog I'm writing: Server…
Pablo
  • 7,249
  • 25
  • 68
  • 83
16
votes
2 answers

Microsoft SQL Server login using Active Directory Credentials

Our Microsoft SQL Servers are running on Windows Servers which are part of an Active Directory domain. For easy user management, our SQL authorization is set up by using the Active Directory User Groups as explained in this post. Now this works fine…
16
votes
5 answers

Should I install 32-bit database or 64-bit database?

(I've read a lot about 64-bit versus 32-bit OS/Apps, but this question is specifically in regards to databases.) I'm trying to understand the pros and cons of 32-bit versus 64-bit databases, and namely, under what conditions that it starts to make…
JohnB
  • 497
  • 2
  • 6
  • 12
1
2 3
99 100