A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.
18
votes
8answers
50k 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 ...
16
votes
5answers
50k 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"?
14
votes
2answers
66k 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 ...
14
votes
3answers
2k 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 ...
13
votes
4answers
48k views
Adding an administrator user to SQL Server 2008
How do you add an administrator user to SQL Server 2008?
11
votes
7answers
9k 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 ...
10
votes
5answers
7k 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 ...
10
votes
6answers
16k 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 ...
9
votes
5answers
5k 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 ...
9
votes
2answers
2k 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 ...
9
votes
2answers
13k 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.
9
votes
1answer
243 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
1answer
7k 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? ...
8
votes
9answers
2k 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 ...
8
votes
2answers
10k 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 ...
8
votes
5answers
6k 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 ...
8
votes
2answers
3k 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
2answers
12k 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 ...
7
votes
1answer
9k 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?
7
votes
1answer
264 views
sys.dm_exec_query_stats interaction with recompilation
We use sys.dm_exec_query_stats to track down slow queries and queries that are IO offenders.
This works great, we get a lot of very insightful stats. It is clear this is not as accurate as running a ...
6
votes
5answers
2k 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 ...
6
votes
4answers
14k views
SQL Server 2Kx: How to move a database to a different partition in the local file system?
SQL Server creates its databases in the system program files directory structure.
I want to separate the database files away from the system partition.
Assuming the database is already created and ...
6
votes
3answers
2k 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
6
votes
5answers
469 views
Virtualizing Microsoft SQL Database server
My company is looking to virtualize our Microsoft SQL server. I read on another question that databases on VM's suffer from a IO bottleneck which is not very good for us. But I was wondering if ...
6
votes
2answers
967 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 ...
6
votes
1answer
45k 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. ...
6
votes
5answers
2k views
What is the best way to configure 6 disk raid for SQL Server + OS?
I'm setting up a SQL Server on Win 2k8 with following hardware:
6 x WD RE3 500G SATA
PERC H700
I've read some suggested that putting log file and OS on its own RAID1 while the rest of data is on ...
6
votes
4answers
3k 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 ...
6
votes
5answers
3k 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 ...
6
votes
2answers
325 views
Windows File Cache drops suddently
I have a 64-bit Windows 2003 server with 48 CPU cores and 128GB of RAM running a single application (SQL 2008 Analysis Services). SSAS is currently using about 50GB of memory.
SSAS relies to a ...
6
votes
1answer
248 views
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 ...
6
votes
5answers
4k views
Double hop problem with sql server 2008
I'm trying to set up the following scenario. I have 3 servers, they are all in same domain.
Server A has web application which runs under (domain) service account, dom\web.
Server B has instance of ...
6
votes
1answer
441 views
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 ...
5
votes
5answers
24k 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 ...
5
votes
5answers
4k 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 ...
5
votes
13answers
18k 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 ...
5
votes
3answers
2k views
SQL Server 2008 R2 Enterprise database has unexpected 4GB database size limit
I have SQL Server 2008 R2 Enterprise installed on a local Windows 7 x64 workstation. When I create a database on the server, it unexpectedly has a 4GB size limit (Database properties in SQL Server ...
5
votes
7answers
7k 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
...
5
votes
2answers
5k views
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 ...
5
votes
4answers
503 views
Upgrading Sql Server 2000 to 2008
At my place of employment we have been thinking about upgrading from SQL Server 2000 to the latest (2008). We know that the DTS packages will have to be dealt with since the newer server software no ...
5
votes
3answers
101 views
Storing SQL Server System Databases On A Seperate Drive
Is it worth moving the SQL Server system databases master, model and msdb from the default install path on the main OS hard drive over to their own drive?
I've already moved TempDB on to 2 separate ...
5
votes
2answers
7k 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?
5
votes
2answers
238 views
Under what circumstances is it a good idea to re-index tables every night?
I have inherited a number of SQL Server 2005 and 2008 systems (all running in Simple recovery mode) that each currently do the following things each night from an SQL Agent task:
Backup
Shrink
...
5
votes
1answer
2k views
Does SQL server log shipping require a 2nd SQL license [duplicate]
Possible Duplicate:
Can you help me with my software licensing question?
I'm currently working on a high availability solution for SQL Server 2008. I have 2 servers with 1 license of ...
5
votes
2answers
1k views
SQL Server 2008 Trace Flag 4135
Does anyone have any idea what this flag does? There is no reference to it on MSDN. It is not a part of the article that lists available trace flags in 2008.
There is a KB article that recommends ...
5
votes
13answers
4k views
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 ...
5
votes
5answers
8k views
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 ...
5
votes
2answers
370 views
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
5
votes
1answer
91 views
32-Bit SQL eating up RAM on 64-bit OS until SQL is brought to it's 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 ...
5
votes
1answer
837 views
TFS is wonky after server move
We did a server move a while back and ever since then we have been having a weird "error" happen repeatedly. In a nutshell, when you first request connection (via VS.NET, TFS Admin Console or Web ...
