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
5answers
25k 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?
4
votes
3answers
7k views

How does SQL Server handle simulataneous read/write requests?

Background: We have an application which uses an SQL Server 2008 database heavily. We are trying to optimize this application. It was single threaded, and we noticed through logging/ profiling of the ...
4
votes
2answers
4k views

Why does the .NET Folder.CopyHere Method not allow dialog suppression for .ZIP files when run within a SQL Server Agent PowerShell job step?

I am using PowerShell in a SQL Server Agent job step to automate the extraction of .ZIP file contents to a directory. Based upon highest-voted answer on this question: How to zip/unzip files in ...
4
votes
2answers
11k views

How can I copy a SQL Server 2008 instance to another server?

What is the best way to create an exact copy of an entire SQL Server 2008 instance to another server? I want to copy everything: user accounts, logins, permissions, databases and all database objects, ...
4
votes
1answer
908 views

SQL Server Developer Edition versus SQL Server Standard

not sure I understand this but I am going to throw my assumption out there: SQL Server 2008 Standard & Enterprises editions are for running full database services on server (not just but for ...
4
votes
1answer
1k 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 ...
4
votes
3answers
6k 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 ...
4
votes
2answers
5k views

sql server: losing identity column on export/import

Recently I started dealing with SQL Server, my previous experience was in MS-Access. When I'm doing an import/export of a db, from the server to my computer or even in the server, all column with ...
4
votes
1answer
3k 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 Server\MSQQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG....
4
votes
1answer
388 views

SAN device storage config for SQL 2008 cluster

Windows Server 2008 R2 (clustered active/passive) - SQL Server 2008 Enterprise - Dell MD3200i PowerVault SAN 8 x 450GB 15k SAS drives (RAID 10) What is the best stripe unit size for this ...
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
1answer
552 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 ...
4
votes
3answers
4k 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 ...
4
votes
3answers
7k views

How safe is SQL Server's encryption of stored procedures?

Background I am using SQL Server 2008 Enterprise on Windows Server 2003 Enterprise. I developed some stored procedures for SQL Server and the machine installed with SQL Server may not be fully under ...
4
votes
2answers
540 views

What “Log On” should I use on SQL Server Express 2008?

What "Log On" should I use on a SQL Server Express 2008 running in my workstation for the purpose of development if I want my local windows user to be just recognized? The options I see are "Built-in ...
4
votes
1answer
2k views

SQL Server PowerShell cannot find path error

I cannot use Set-Location to change to a database. I have loaded the SQL Server snapins. I can use Set-Location to get to SQL\Localhost\SQLEXPRESS\, and I can show the paths under the server node with ...
4
votes
1answer
348 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
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
3answers
4k views

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 ...
4
votes
2answers
294 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
3answers
461 views

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 ...
4
votes
1answer
2k 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
947 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
3k 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
193 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
2answers
2k 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
939 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
1k 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
673 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
358 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
533 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
4k 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
807 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
440 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 (...
4
votes
9answers
18k views

How do I solve MSSQL 2008 install error, “The MOF compiler could not connect with the WMI server”?

Possibly related to: SQL Server 2008 Install fails error reading etwcls.mof After manually removing MSSQL 2008 from my system (uninstall failed to remove two instances), I receive the following ...
3
votes
4answers
269 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
262 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
11k 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 http:...
3
votes
3answers
173 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
5answers
3k 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
3answers
10k views

MS SQL Server 2008 sa account locked out and Windows Authentication login is greyed out

The sa account got locked out and even though mixed mode authentication is enabled. When I select "Windows Authentication" the Username and Password fields are greyed out. The username field contains ...
3
votes
3answers
17k 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
5answers
10k views

Automate SQL Server 2008 backup script failing to run

I have created a maintenance plan but when I try to execute I get the error: Message [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'XX\Administrator', error ...
3
votes
7answers
36k 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
103 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
1k 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' ...