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

learn more… | top users | synonyms

4
votes
2answers
909 views

MS SQL access to restored database without sysadmin role

I have databases from different projects on one server. I can't give all developers administrative (sysadmin) access to the databases. They have to have the permissions needed to create and restore ...
4
votes
1answer
508 views

Limitations in SQL Server merge replication - Publication to number of subs

I'm looking for a couple different things here. From what I can find, Workgroup edition supports up to 25 subscribers per publication. Does anyone know the limit, if there is one, to the number of ...
4
votes
4answers
3k views

SQL Server 2008 R2 Error 15401 when trying to add a domain user

I am trying to add a domain user. I am doing the following. Expand Security Right click on Logins Select New Login... Login name select search Click on location and select entire directory Type ...
4
votes
2answers
3k views

User Provisioning Tool for SQL Server 2008?

Yesterday I moved my machine from one domain to another - foolishly forgetting the implications for my local instance of SQL Server! Mixed Mode authentication is not enabled, and the only local ...
4
votes
1answer
674 views

How do you enable Remote Connection with SQL Server 2008 w/o Installing Management Studio?

I'm having a rather tough time finding information on this since almost everything I read requires Management Studio installed in the server which I prefer not to do. Also, to connect to it using SQL ...
4
votes
3answers
658 views

Copy database from SQL Server 2000 to SQL Server 2008

I'm trying to transfer a database from SQL server 2000 to SQL Server 2008 using the copy database wizard, but I keep getting an error that tells me to check my error logs. I go check the log and ...
4
votes
1answer
159 views

SQL Server Restore from Backup, Just primary File Group

Thankfully, this question is just a what-if, and I am not in an emergency right now. But I have created a file group in my database (sql server 2008), and moved some massive data tables over to it. ...
4
votes
1answer
7k views

Difference between “SQL server 2008 standard” and “SQL server 2008 standard for small business”?

There seems to be a big difference in price for these licenses, but after a lot of googling I can't find any info on how the two compare. The blurb for the "small business" version is: "This edition ...
4
votes
1answer
478 views

Best practice in deploying SQL Server 2008 failover cluster over VMware ESX

I am now in the process of building SQL Server 2008 Enterprise failover cluster for use with 3rd party server monitoring application (which also do some OLAP analysis for trends). Since this project ...
4
votes
3answers
3k views

Windows Server task manager displays much higher memory use than sum of all processes' working set size

I have a 16 GB Windows Server 2008 x64 machine mostly running SQL Server 2008. The free memory as seen in Task Manager is very low (128 MB at the moment), i.e. about 15.7 GB are used. So far, so good. ...
4
votes
4answers
1k views

Optimal SQL Server Reporting Services setup

I'd like to determine an optimal setup for SQL Server Reporting Services to use as the integrated reporting tool for SaaS web-based applications. All reports are pre-defined, so users pick a report ...
4
votes
6answers
800 views

.NET 3.5, IIS 7, SQL Server 2008 hosting

Any recomendations on what services are out there to host an ASP.NET MVC application using .NET 3.5, IIS 7, SQL Server 2008? Any recommendation on shared? VPS? Dedicated?
4
votes
1answer
159 views

What is the best way to replicate a large number of SQL 2008 DBs to a failover instance in Amazon Web Services

Our application creates a new sql database for every customer and we will be continually adding new customers and creating new databases every day. These databases can range in size from 3 megabytes ...
4
votes
2answers
342 views

Scripting an automated SQLServer 2008 DR move

We use the built in logshipping in SQLServer to logship to our DR site but once in a month do a DR test which requires us to move back and forth between our Live and BAckup servers. We run multiple ...
3
votes
4answers
249 views

Mistakenly ran an update statement on table

We have mistakenly ran an update statement on one of our Columns in a SQL table. We don't have a backup of the table nor the database. Can any one help us to retrieve the values of the Column before ...
3
votes
5answers
8k views

SQL Server 2008 Load-Balancing

The info I've found on the web so far indicate that SQL Server 2008 does not support true load-balancing. Is this true? I'm not able to find decent documentation on MS' site, so any links would be ...
3
votes
4answers
249 views

What is considered more secure for sql server security

When setting up security on SQL Server 2005 / 2008. What is the more secure option? Windows Authentication Mode Only Mixed Authentication Does it matter if the server will be accessed by many ...
3
votes
5answers
2k 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 ...
3
votes
3answers
168 views

Memory needed for a SQlServer

I have a project with a 2TB database (450,000,000 rows). What is the recommend memory? There will be about 200 users at the same time using the info.
3
votes
2answers
1k views

Locked out of SQL Server 2008

I've got an SQL server 2008 server which appears to have had all it's windows users removed from the logins and is set to windows authentication only. I can't login with any of my AD/Doman accounts or ...
3
votes
4answers
2k views

Enable row level compression on all tables and indexes

One of the (optional) requirements for the Works With SQL Server 2008 test is that row level compression is enabled on all tables and indexes. We have an existing database with a lot of tables and ...
3
votes
4answers
5k views

SQL Server 2008 R2 vs. SQL Server 2008 R2 Express

What differences exist between the pay and free version of MSSQL2008R2? Microsoft SQL Server 2008 R2 http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx and Microsoft SQL Server 2008 R2 Express ...
3
votes
7answers
33k views

Cannot connect to SQL Server

I'm having a problem connecting to my SQL Server Express instance. I can connect to the sa account from the local machine but as soon as I try to connect from a separate workstation, the connection ...
3
votes
3answers
98 views

What is the standard method to keep track of the latest Cumulative updates for SQL Server?

What resources are good for keeping track of cumulative updates for SQL Server? I noticed that Windows update does provide a service for SQL Server.
3
votes
2answers
728 views

SQL 2008 Memory Usage

I have a SQL Server 2008 (ver 10.0.1600) running on a Windows Server 2008 R2 Enterprise server with 8 GB of physical ram. If I open Task Manager I can see on 'Physical Memory' section of 'Performance' ...
3
votes
2answers
216 views

Should SQL Server 2008 only be run on Server 2008 R2 (64 bit)?

Today I was told that SQL Server 2008 is supposed to be run on Server 2008 R2 (64 bit). Is this true? And if so, can anyone explain why? Our development instances are running on 32-bit systems. I ...
3
votes
4answers
4k 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?
3
votes
2answers
828 views

comparing SAN with NAS [duplicate]

I am using Windows Server 2008 Enterprise with SQL Server 2008 Enterprise. I am considering whether using SAN or using NAS is better to store database data files. Are there any industry readings to ...
3
votes
2answers
2k views

Is 1GB RAM enough for a Windows Server 2008 web server with SQL Express 2008?

So I'm pricing out virtual dedicated servers. I'm looking to support about 500 to 1,000 (peak) visits a day spread across 5 different web sites. And 2 of those sites will have SQL databases with a ...
3
votes
2answers
1k views

Setting Up Login for ASP.NET Application on SQL Server 2008

I have 2 Windows 2008 Servers. One is a web server (IIS7). The other is a database server (SQL Server 2008). The instance of sql server 2008 is configured to use mixed mode authentication. Neither are ...
3
votes
2answers
2k views

How to login with SQL Authentication using PowerShell

I'm trying to connect via SQL Server Powershell Cmdlet (read not ADO.NET) using SQL-based Authentication, not Windows Integrated security. Anyone know the format to use for this? Server: foo ...
3
votes
2answers
487 views

How to change max server memory in SQL Server

I was trying to change the max server memory for my database server, and I accidentally saved it as "4" instead of the number I wanted to enter. Now I can't even connect to the server. Is there a ...
3
votes
2answers
69 views

Can I create SQL v10.0 databases in SQL R2 server?

Is there a way to create non-R2 databases in an R2 database server? I was hoping to do this in the compatibility options during the database creation, but only options are available for 2005 and 2000. ...
3
votes
2answers
6k 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 ...
3
votes
8answers
6k views

How to stop Log file from growing in SQL Server 2008?

In my application right after restore I perform many(>100,000,000) updates to the newly created database. Thus, LOG files grows significantly. How can I stop it from growing? NOTE: Setting recovery ...
3
votes
3answers
294 views

SQL Server 2008 R2 Developer Editon

I have a basic question. Is the SQL Server 2008 R2 Developer Edition same as SQL Server 2008 Developer Edition? Why does the Microsoft sites return 2008 pages while browsing when looking for R2 ...
3
votes
4answers
1k views

Log Shipping to an Existing Database

We have a few huge databases we would like to log ship on SQL Server 2008. Unfortunately the link between primary and secondary servers is fast enough to handle log shipping but the initial ...
3
votes
3answers
13k views

SQL 2008 Mirroring, how to failover from the mirror database?

I have configured a database mirroring setup in SQL 2008 using the High-safety, Synchronous mode, without automatic failover. I don't have a Witness instance. Regarding high availability, I ...
3
votes
2answers
260 views

Windows Failover and Load Balancing confusion

In the next couple months we are looking to add Failover and Load Balancing to our environment. We will have 2 servers that are Hyper V Hosts. We are looking to have an IIS App server and SQL ...
3
votes
3answers
5k views

Registry Keys error when installing SQL Server 2008 R2

I am trying to install SQL Server 2008 R2 Management Studio Express on a Windows XP machine that already has SQL Server Management Studio 2005 installed on it. I would like to have both of these ...
3
votes
2answers
156 views

SQL Server Delete - Ran out of disk space

I am deleting 257 million rows out of a table in SQL Server 2008. I can't truncate it. I probably could have done it smarter though. 2 hours into the delete, the log file grew and I am out of disk ...
3
votes
2answers
2k views

Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and SQL performance problems?

Related Perfmon: which counter identifies that threads are waiting? but sadly abandoned by the asker Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and ...
3
votes
3answers
1k views

SQL Server 2008 Underperforming - extreme slowness after migrating to new server

Last weekend we moved our production database to a new server. It's a Windows Server 2008 R2 Datacenter. On it is a brand new installation of SQL Server 2008 Enterprise Edition 64-bit. On Sunday, ...
3
votes
1answer
252 views

Fixing a typo in machine name

When i installed windows i had a typo in the machine name that i corrected from the system's 'Computer Name/Domain Changes' - the workstation is a member of a workgroup not a domain. From everything i ...
3
votes
3answers
3k views

how do I configure IIS to post logs to sql server?

how do I configure IIS to post logs to sql server? How want to save ANY log to my site. the site has a lot of views and the data can be big in a very small time. In addition, I want to show analytics ...
3
votes
6answers
3k views

1 logical drive vs 2 logical drivers on 1 raid controller to separate data from log files?

I'm configuring a new server: it has 1 raid controller with 8x 146 Gb disks. The system is currently configured in Raid 1+0 but has only 1 logical drive, which is not that optimal as data and ...
3
votes
5answers
3k views

Replaying SQL Server transaction logs on changed db schema

We have a big transaction log (1.3 GB) for a relatively simple SQL Server 2008 database (30 MB). It (log) contains all updates since first time when db was put into production and (now we see it) ...
3
votes
3answers
406 views

How to see when stored procedures have last run

I want to see a listing of all the stored procs for each database on a server along with when the last time that store proc was run. I'm pretty good with SQL but I don't know about looking at stats ...
3
votes
2answers
172 views

vCenter database selection

I am in the planning process of building a new vCenter 5 server. Currently, as a SMB, my host requirements are within range of using the SQL Express install, but my VM count has grown into the lower ...
3
votes
2answers
302 views

Best practices - Is it better to delete unused SQL accounts or just disabled them?

In an enterprise environment, is it better to delete limited access SQL accounts, or simply disable them?