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

How can I backup / restore my Sql Server 2008 Database?

I have a database that is around .. 20ish Gig. I need to (manually*) back up this database, 7zip the backup and then DOWNLOAD this backup from my server to my desktop. (Rinse, repeat sorta often). ...
4
votes
1answer
2k views

how to whitelist IPs connecting to MS SQL Server with firewall

What are some good links.articles on how to white list, with flexibility, IPs connecting to MS SQL server. (using win server 2008 r2, if it matters) Thnkas EDIT: I want to be able to whitelist IPs ...
4
votes
2answers
3k views

SQL Server 2008 R2 Express + Wildcard SSL Certificate

Wildcard certificates (for example, *.example.com) simply did not work in SQL Server 2008 or lower. But Encrypting Connections to SQL Server on MSDN states, plain as day, that SQL Server 2008 R2 ...
4
votes
2answers
228 views

What's the cleanest way to reversibly break SQL Server replication?

I'm playing around with SQL Server Agent alerts, hoping that I can get some reliable error notifications sent out when our transactional replication breaks. To test it however, I need to break it. I ...
4
votes
1answer
1k views

How do I attach a SQL Server DB with a missing NDF file?

I had a server running that had a disk crash. The server had 2 filegroups: PRIMARY and SECONDARY. SECONDARY was stored in a different NDF file. I lost SECONDARY + the installation of the server, I ...
4
votes
3answers
814 views

Max and Min Memory Setting

One failover cluster has 2 nodes with 64GB RAM each: - Node A and Node B. Node A run 2 SQL instances (SQL1 and SQL2). Node B runs 1 SQL instance (SQL3). SQL1 has a max server setting of 30,720MB ...
4
votes
3answers
2k views

How to: Hot Standby SQL Server in another datacenter?

For our SaaS app, I want to have a system in place for a datacenter wide failure. In the main datacentre, we have two servers set up with MSSQL Database Mirroring (synchronised). This provides us ...
4
votes
1answer
154 views

Queries passed to SQL Server are getting corrupted

We are experiencing a bizarre error with our application at a customer site. We have managed to narrow it down to the point where we can replicate the behaviour using just Management Studio and SQL ...
4
votes
3answers
3k views

Tracking SQL Server 2008 Timeout Errors

we got some connections timeouts running a stored procedure in a SQL Server 2008 instance. after a while, the DB started to work as usual, and there weren't any additional timeout errors. So I'm ...
4
votes
1answer
11k views

How can I generate a certificate request on Windows Server 2008 for SqlServer 2008 w/o IIS installed

I'm trying to generate a CSR for an SSL certificate to encrypt connections to my SqlServer 2008 instance located on a Windows Server 2008 server. Most of the documentation I've read mentions using the ...
4
votes
2answers
1k 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
687 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
2answers
4k 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
961 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
664 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
215 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
8k 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
505 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
2answers
369 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
253 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
4answers
253 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
171 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
7k 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
3answers
14k 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
7answers
34k 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
886 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
9k views

SQL Server Trial Edition to Full Edition

I installed SQL Server 2008 R2 for the 180 day trial. We tested the system and it's working fine, and I wanted to convert it to full version. The problem is, I have a volume key licence to SQL ...
3
votes
8answers
7k 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
2answers
219 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
10k 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
850 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
3answers
4k 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
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
754 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
71 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
3answers
297 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
2k 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
6k 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 ...
3
votes
2answers
277 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
8k 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
162 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 ...