Questions tagged [sql-server-2008]

A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

Filter by
Sorted by
Tagged with
40
votes
4answers
47k views

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? ...
36
votes
6answers
69k views

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 ...
34
votes
3answers
48k views

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 ...
34
votes
1answer
74k views

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?
28
votes
5answers
143k views

Adding an administrator user to SQL Server 2008

How do you add an administrator user to SQL Server 2008?
28
votes
6answers
81k views

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"?
25
votes
3answers
220k views

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 ...
21
votes
2answers
68k views

“'' 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 ...
20
votes
8answers
68k views

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 ...
20
votes
11answers
73k views

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' ...
20
votes
4answers
6k views

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 ...
18
votes
2answers
150k views

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 ...
17
votes
1answer
9k views

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 ...
16
votes
5answers
34k views

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 ...
15
votes
2answers
149k views

What is a SQL Server instance?

When I install SQL Server 2008 Express in prompts me to create an instance and aborts if I don't. Then I see that information in an entry in Sql Server Configuration Manager on SQL Server Services. ...
15
votes
7answers
17k views

SQL Server Files Local or NAS or SAN?

I have to install a new Server with SQL Server 2008, What do you recommend, One server with Raid 10 or the Files in a NAS? What about iSCSI should I use it? What about SAN? The server has 4Gb of ...
15
votes
2answers
29k views

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 ...
14
votes
6answers
8k views

SQL Server Express for Production Databases?

We are about to roll out a dual web/internal transactional application where each client has their own database. Each database is very small - under 50MB each, so we were wondering if it would make ...
13
votes
8answers
56k views

Activity monitor is unable to execute queries against server

Is there any fix to get SSMS activity monitor working? Problem: SQL Server Activity Monitor fails with an error dialog: TITLE: Microsoft SQL Server Management Studio The Activity Monitor is ...
13
votes
10answers
83k views

Can't remotely connect through SQL Server Management Studio

I have setup a SQL Server 2008 Express instance on a dedicated Windows 2008 Server hosted by 1and1.com. I cannot connect remotely to the server through management studio. I have taken the following ...
12
votes
4answers
16k views

Microsoft SQL Server Management Studio 2008 deleting multiple user tables

Is there an easy way to delete multiple tables in the database without dropping the database and recreating it? In this case we have over 100 to remove. I am happy enough to remove all user tables ...
12
votes
4answers
102k views

How can I see who is connected to my db?

I was trying to rename a database and it said that it needed to be exclusively locked to perform this operation ... How can I check who is connected to it?
12
votes
4answers
29k views

How do I restore a batch of transaction logs rather than one by one

I have a SQL Server database that backs up the transaction logs every 10 minutes, with an overnight full backup. Using SQL 2008 Management studio we seem to have to select each transaction log one ...
12
votes
2answers
57k views

Difference between “NT AUTHORITY\NETWORK SERVICE” and “NT AUTHORITY\SYSTEM”

I am installing MS SQL Server 2008 R2 and I got to the window where I have to set the service accounts. I want to know the difference between NT AUTHORITY\SYSTEM" and "NT AUTHORITY\NETWORK SERVICE". I ...
11
votes
6answers
19k views

How can I have SQL Server Management Studio 2008 connect to my instances automatically?

I'm running a server with 3 database instances. Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else). Would ...
11
votes
4answers
23k views

Is there a way I can use SQL Server management studio to find all columns that have column names that contain a certain substring?

I'm using SQL server management studio 2008. I have a huge legacy database with thousands of columns. It would be nice if I could search for all columns whose names contain a certain substring. Does ...
11
votes
2answers
13k views

SQL Server 2005 / 2008 - multiple files / filegroups - how many? Why?

I'm a developer at heart - but every now and then, a customer doesn't have a decent DBA to deal with these issues, so I'm called in to decide.... What are your strategies / best practices when it ...
11
votes
2answers
31k views

How to enable remote connections for SQL Server 2008?

How do I enable remote connections on an SQL Server 2008 installation? I have created a rule in the windows firewall to allow traffic through port 1433, but that does not seem to be enough.
10
votes
6answers
18k views

How to migrate from SQL Server 2005 to 2008

How do you migrate SQL Server 2005 databases to SQL Server 2008? Is it as easy as backing up 2005 databases and simply restore in 2008? Are there any compatibility issues? Is SQL Server Reporting ...
10
votes
6answers
56k views

cannot add a user to sysadmin role in SQL Server

I am using SQL Server 2008 Management Studio. The current logon account belongs to machine local administrator group. I am using Windows Integrated Security mode in SQL Server 2008. My issue is, ...
10
votes
5answers
926 views

What's the lowest cost, legal, Microsoft server stack you can assemble? [closed]

Assuming that you have an app infrastructure that generally only requires: ASP.NET MVC / C# / .NET Database or NoSQL data store (must be accessible from C#) Here's the challenge to you server gods: ...
9
votes
9answers
12k views

What should I do about someone trying to brute force attempt to login to our SQL Server 'sa' account?

Looks like someone or something is trying a brute force attempt at logging into our production SQL Server instance with the 'sa' account. They haven't been successful because our 'sa' account is ...
9
votes
2answers
26k views

Alias a linked Server in SQL server management studio?

Hoping someone can help - is there a way in SQL server management studio 2008 R2 that I can alias a linked SQL server? I have a server, added by IP address, to which I do not have the login ...
9
votes
13answers
37k views

HP Proliant DL380 G4 - Can this server still perform in 2011?

Can the HP Proliant DL380 G4 series server still perform at high a quality in the 2011 IT world? This may sound like a weird question but we are a very small company whose primary business is NOT IT ...
9
votes
5answers
15k views

SQL Server Timeout on first attempt

I'm having a strange issue where I try to attach to SQL Server 2008 running on a second computer (both machines running Win7 64-bit), either through the Data Sources in Visual Studio or via the SQL ...
9
votes
1answer
1k views

Ballooning occuring on SQL server

From what I understand ballooning should occur only when the host begins to run out of physical memory, somewhere above 90% usage. I have an SQL server running in a three node cluster (64 GB RAM in ...
9
votes
3answers
19k views

How to restore a SQL Server database and shrink its files at the same time?

Let's say I have a SQL Server database whose data files have been created with an initial size of 100 GB, but it only contains 10 GB of data. A database backup will then be only 10 GB in size. I want ...
9
votes
2answers
6k views

DB auto failover in c# does not work when the principal server physically goes offline

I'm setting up DB auto failover in C# with SQL Server 2008 and I have a 'high safety with automatic failover mirror' using a witness setup and my connection string looks like "Server=tcp:DC01; ...
8
votes
2answers
3k views

SQL Server memory constantly going up, from 1GB RAM used to 7GB in a week

I have a ~45GB database that increases rapidly (~1GB every week). So it's doing a lot of inserts; the web app doesn't have many users so reads are low right now. But I'm noticing that the RAM sql ...
8
votes
3answers
48k views

SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain

A few months ago we installed SQL Server 2012 in Windows 2008 R2 under the virtual account "NT Service\MSSQLSERVER", all good. A few days ago, one of the admins of the IT dept installed Full Text ...
8
votes
4answers
12k views

Does MSSQL Server have the equivalent of MySQL's query logs?

I have used MySQL for a long time and have found the general query log and the slow query log to be very useful in finding out what is happening on the server, and in identifying bottlenecks. Now I ...
8
votes
2answers
7k views

How to Link an SQL Server 2008 Server to an SQLite Server?

I want to "Link" an SQLite server with an SQL Server 2008 server. E.g. using the sp_addlinkedserver command. How do I do this? I have searched far and wide, but found no solution for this problem. ...
7
votes
5answers
3k views

Why is CPU use so asymmetric on our 8-cpu SQL Server box?

I've noticed that the CPU usage on our 8-CPU database server, running SQL Server 2008, is not balanced at all. Here are the 1 day averages for a random day a while back, which is typical and ...
7
votes
3answers
3k views

MS SQL 2008 all on RAM?

Anyone with experience of using SQL 2008, but all in RAM? Trying to make certain things faster, and might pursue this, thanks
7
votes
5answers
46k views

SQL Server Issue: Login failed for user 'username'

I am running a copy of SQL Server 2008 Standard and trying to setup a new user login for access to a DB through a web app. I am using Security -> Logins -> Add login to create the user. Login name ...
7
votes
5answers
14k views

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some ...
7
votes
5answers
29k views

Bad Performance when SQL Server hits 99% Memory Usage

I've got a server that reports 8 GB of ram used up at 99%. When restart Sql Server, it drops down to about 5% usage, but gradually builds back up to 99% over about 2 hours. When I look at the ...
7
votes
5answers
4k views

Using SAN Replication/Snapshots for SQL Server disaster recovery?

We have a web application that utilizes SQL Server 2008 on a single database server. All storage is local. For the past year we have been trying to get any form of SQL Server Replication to work ...
7
votes
6answers
67k views

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?
7
votes
4answers
5k views

Ghost Cleanup

my understanding of the ghost cleanup process is that every five seconds it will look to removed ghosted records in an index. and so it will not overload the system, it will only "clean" roughly ten ...

1
2 3 4 5
37