A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.
3
votes
6answers
986 views
attach/detach vs. backup/restore
I am using SQL Server 2008 Enterprise. I need to transfer the database (as a whole) to another server (to make a duplicate database to set up another test environment).
I have two choices, (1) making ...
3
votes
5answers
7k 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
6answers
20k 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, ...
3
votes
4answers
236 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
928 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
2answers
7k views
How can I create a read only Sql server 2008 account?
I want to be able to give read only access to my SQL Server 2008 database server. In particular two databases one called "live" and one called "stage".
Essentially the guys who receive this username ...
3
votes
3answers
161 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
7answers
32k 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
87 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
571 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
207 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
2answers
783 views
comparing SAN with NAS
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
1k 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
349 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
67 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
281 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
2answers
210 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
2answers
134 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
1answer
450 views
Store a table in a memory
Is there a way to make SQL Server to store a table with 10 attributes and 10 rows like this on memory?
a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
----------------------------------------
138 498 365 ...
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
699 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
221 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
4answers
815 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
6answers
2k 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
3answers
113 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
242 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?
3
votes
1answer
334 views
SQL Server 2008 R2 100% availability
Is there any way to provide 100% uptime on SQL Server 2008 R2?
From my experience, the downtimes for the different replication methods are:
Log Shipping: Lots (for DR only)
Mirroring w. NLB: ~ 45 ...
3
votes
1answer
2k views
Installing Team Foundation Server separate from SQL Server: error TF255040
I have SQL Server 2008 R2 Database, Reporting and Analysis Services installed on Server A. On Server B, I am trying to configure Team Foundation Server using the Advanced Configuration Wizard. Pretty ...
3
votes
3answers
1k 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
418 views
SQL Server 2005 to 2008 upgrade - are MDF files binary compatible?
I have 50 databases on a MS SQL Server 2005 system and want to upgrade to MS SQL Server 2008.
This is what I tried on some test machines:
1. copied the \DATA directory from the source (MSSQL 2005) to ...
3
votes
2answers
919 views
Hardware Requirements of SQL Server Clustering
My task is to do clustering in SQL Server 2008. What are the hardware requirements for windows clustering? Is either SCSI or SAN compulsory, or is shared disk enough? I can't understand the hardware ...
3
votes
2answers
103 views
Is hosting my websites and databases with different providers a bad idea?
I'm trying to find a home for three ASP.NET 3.5 websites using three respective SQL Server 2008 databases. I've found one possible solution where I host the websites on a "semi-dedicated" environment ...
3
votes
2answers
16k views
SQL Server 2008 / 2008R2 backup compatibility
I want to start using SQL Server 2008R2, but I need to also be able to deploy my apps with databases to SQL Server 2008. I just found that I cannot backup 2008R2 to restore 2008. Why? What are my ...
3
votes
2answers
3k views
How to install Microsoft SQL Server 2008 Management Studio Express
I have Microsoft SQL Server 2008 Express Edition already installed, and now I want to install SQL Server 2008 Management Studio Express.
I've tried with the only two options that look feasible:
...
3
votes
2answers
1k views
Unable to uninstall SQL Server express
When I try, I receive the following error message:
A computer restart is required. You
must restart this computer before
installing SQL Server.
Of course, I have restarted the computer :-) ...
3
votes
5answers
2k 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
1answer
597 views
On Amazon Web Services what is the difference between SQL Server Standard and SQL Server Web?
I noticed that SQL Server Web is vastly cheaper than SQL Server Standard on Amazon Web Services. Why is that? What am I missing if I use SQL Server Web instead of Standard?
3
votes
1answer
76 views
SQL Server 2008 - one table 24gb, deleted 95% of that data, whats the best way to regain space?
We were saving unnecessary logging data in our database. One table grew to 1 million records, 99% of that is now gone.
We have db size of 40gb and freespace of 24gb.
Whats the best way to regain ...
3
votes
1answer
362 views
Can I safely delete MS SQL Server Error Log?
I have some huge log files, which are taking up all the space on a PC's hard drive. Is ok to simply delete the log file: C:\Program Files\Microsoft SQL ...
3
votes
3answers
118 views
SQL Server 2008 Enterprise edition 64 bit scalability
I am currently running SQL Server 2008 64-bit Enterprise Edittion on a VM ware environment with 4 CPUs and 32GB RAM. I want to scale it up. Is there a limit on how many CPUs and RAM I can go up to?
I ...
3
votes
1answer
795 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 ...
3
votes
2answers
945 views
repair suspect database
My sql server 2008 told me that you database is suspect and I can't see my tables or my data or use it what should I do ?
3
votes
1answer
4k views
Why does sp_send_dbmail fail inside SQL Agent jobs?
I have a simple query that I run to send email notifications to our AD account administrators when accounts have been disabled for more than 30 days. It works perfectly fine when I run it on my own, ...
3
votes
3answers
942 views
SQL Server Backup retention policy
I need to backup database in full recovery mode with a condition as:
1. Backup database, only when space is available for backup operation and Backup retention policy must be like expect last two days ...
3
votes
2answers
1k views
SQL 2008 - Transaction log is full
We have some issues with the transaction log files
We have SQL Server 2008
Our situation:
Every night, we have many jobs that runs on the server by SQL Agent
Some jobs stop because the transaction ...
3
votes
6answers
1k views
SQL Clustering on Hyper V - is a cluster within a cluster a benefit
This is a re-hash of a question I asked a while back - after a consultant has come in firing ideas in to other teams in the department the whole issue has been raised again hence I'm looking for more ...
