Questions tagged [sql-server-2008]
A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.
1,806
questions
3
votes
4
answers
11k
views
How do I tell which version of SQL Server 2008 is running on a server?
I'm trying to square up licensing, and I'm looking at a few SQL 2008 boxes that are in a cluster and I can not see where it says Enterprise Edition anywhere, even though I know that's what it's ...
- 221
2
votes
2
answers
6k
views
Is there a way to reset SQL Server 2008 Express to default configuration and data?
Is there a way to reset a SQL Server Express 2008 to it's initial configuration? Maybe re-creating the instance?
- 10.8k
20
votes
4
answers
8k
views
How to exclude indexes from backups in SQL Server 2008
Our nightly full (and periodic differential) backups are becoming quite large, due mostly to the amount of indexes on our tables; roughly half the backup size is comprised of indexes.
We're using the ...
- 10.8k
1
vote
1
answer
707
views
Make SQL replicate over separate VLAN
I have two SQL Server 2008 machines, SQL1 and SQL2, doing replication between each other. Their main interfaces are on VLAN1 (10.1.1.0/24) and that's where clients reach them.
For performance, I ...
- 9,074
5
votes
4
answers
540
views
Upgrading Sql Server 2000 to 2008
At my place of employment we have been thinking about upgrading from SQL Server 2000 to the latest (2008). We know that the DTS packages will have to be dealt with since the newer server software no ...
- 10.8k
3
votes
4
answers
317
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 ...
- 283