Server Fault Stack Exchange
Server Fault Stack Exchange

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
4
votes
3 answers

Does splitting out Data, Logs, and TempDB matter using a SAN with SQL 2008

I'm not a server admin. So be gentle. But I was just at a conference and in one of the training classes the Instructor explained some SQL DBA best practices. One of which was to separate out Mdf,Ldf, and TempDB onto different drives to increase…
MVCylon
  • 309
  • 2
  • 4
  • 13
4
votes
1 answer

Ram recommendations vs SQL DB size

we have a medium sized SQL db of around 40GB, and are about to move it to a new box with server 2008 r2 x64 an expensive contractor has just come in and said we need 72gb of ram so that the whole DB can live in RAM i guess.. , I find that ludicrous,…
nat
  • 163
  • 2
  • 7
4
votes
3 answers

adding additional disks to existing RAID 5

I have been handed the challenge of adding 4 additional drives to an IBM ThinkServer with a RAID 5 array on an MS Windows Server 2008 Std. living life as a SQL server. First question is "is it even possible to add additional drive to an existing…
Ward Duncan
  • 41
  • 1
  • 2
4
votes
2 answers

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 have a subscription that's safe to break, but I…
Samantha Branham
  • 221
  • 3
  • 11
4
votes
2 answers

SQL Server: How to shrink FileStream files?

For a project, I'm using a SQL Server 2008 R2. One table has a filestream column. I've made some load tests, and now the database has ~20GB used. I've empty tables, except several(configuration tables). But my database was still using a lot of…
J4N
  • 167
  • 1
  • 2
  • 8
4
votes
2 answers

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 way for me to reset the max server memory setting to…
Steven
  • 223
  • 1
  • 3
  • 5
4
votes
2 answers

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 databases. The dbcreator server role works quite…
Hubert Kario
  • 6,361
  • 6
  • 36
  • 65
4
votes
5 answers

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) represents a valuable source of temporal data which…
Cyber
4
votes
2 answers

Do I need to back up the SQL Server Encryption Password and Symmetric Key?

I'm trying to setup SQL Server to use Cell-Level Encryption on some sensitive data. It seems straightforward per this example on the MSDN: Create the Master Key with a strong password. Create a Certificate. Create a Symmetric Key with the…
John B
  • 171
  • 1
  • 11
4
votes
5 answers

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 appreciated. Also, the differences between…
Duncan
  • 325
  • 2
  • 6
  • 11
4
votes
3 answers

SQL Server 2008 Workgroup Edition on virtual server with no swapping

I have rented a virtual server with 4 GB memory from Hosteurope, including a license for SQL Server 2008 Workgroup Edition. It works alright and is plenty fast, but whenever I put some load on it, it will run out of memory and as a result, the…
Niels Brinch
  • 413
  • 5
  • 16
4
votes
1 answer

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. Leaving my websites central tables in the Primary…
bladefist
  • 355
  • 1
  • 3
  • 13
4
votes
6 answers

.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?
Pablo Fernandez
  • 7,438
  • 25
  • 71
  • 83
4
votes
2 answers

how to change sql server product key

my version of sql server 2008 Enterprise edition has expired and I have a new key how to change the old key without uninstall or any modification to the installed server or instances.
mario hoyek
  • 41
  • 1
  • 1
  • 3
4
votes
2 answers

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 Instance: DEFAULT UserID: homer Password:…
Brett Veenstra
  • 1,497
  • 5
  • 18
  • 27
1 2 3
…
99 100