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
2 answers

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 Powershell? I am using this code: $dir_source =…
peterk411
  • 178
  • 1
  • 8
4
votes
1 answer

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). I knew that the size would be big, I split my…
Pure.Krome
  • 6,508
  • 18
  • 73
  • 87
4
votes
1 answer

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.1 ?
John
  • 53
  • 1
  • 4
4
votes
9 answers

SQL Server 2008 failover strategy - Log shipping or replication?

We just moved from SQL Server 2000 to SQL Server 2008. We were using our own log shipping on 2000 for failover. For 2008, we need to decide to use our own log shipping, built in log shipping, or replication. We have many databases on our server…
Peter
  • 43
  • 1
  • 1
  • 4
4
votes
1 answer

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 of SQL Server is an entry level edition that is…
Stringent Software
  • 163
  • 1
  • 8
4
votes
3 answers

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 instances installed at the same time. During the…
Drew
  • 275
  • 2
  • 3
  • 7
4
votes
1 answer

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 have the MDF file of the PRIMARY filegroup. I also…
ytoledano
  • 173
  • 1
  • 2
  • 8
4
votes
1 answer

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 configuration (for optimum SQL performance)? I am reading…
EkoostikMartin
  • 208
  • 2
  • 7
4
votes
1 answer

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 will be using SQL Server 2008 Enterprise over…
Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62
4
votes
1 answer

Kill a SPID on SQL Server 2008

We have a rogue SPID on a MS SQL Server 2008. Is there a way to kill it without restarting the server?
Shiraz Bhaiji
  • 2,229
  • 9
  • 34
  • 47
4
votes
3 answers

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 and min server setting of 1024MB. SQL2 has a max…
db7
  • 135
  • 4
4
votes
3 answers

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 my current windows logon and the password field…
Vortex
4
votes
1 answer

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 subs per pub in both Enterprise and Standard…
DanBig
  • 11,423
  • 1
  • 29
  • 53
4
votes
2 answers

How to make SQL Server 2008 redundant?

At the moment I'd like to combine my departmental SQL Server into one big SQL Server 2008 instances spread across two servers (for redundancy reason). How/what is the best way to approach this ? is it through clustering or Log shipping or VMware…
Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62
4
votes
3 answers

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 with a good enough high availability solution for…
Marcus
  • 400
  • 2
  • 5
  • 16
1 2 3
…
99 100