Through WebsiteSpark, I've downloaded .iso installation files for Expression 3, Vis Studio 2008 and SQL Server Web 2008. I've copied the Expression 3...

TLD

01-05-2010 02:34 PM
Geoff N. Hiten

This worked. Thanks for sharing the experience. Jesse Munro wrote: Thank you 04-Feb-09 THIS IS THE SOLUTION

Bader Cheema

01-05-2010 10:46 AM
Bader Cheema

hello, physically I have 8GB RAM in a dell server running windows 2003 server R2 and SQL 2008 server. The OS only sees 4GB and SQL only uses 2 GB. ...

Leon McCalla

01-04-2010 08:59 PM
Jeffrey Williams

I have Windows 2003 R2 Standard SP2 Server running SQL 2000 SP4 Standard I want to upgrade to SQL 2005 Standard I only have One Database that is in...

Thomas R Grassi Jr

01-04-2010 03:53 PM
paulc

My Server Admin and I share some DBA roles in our company, they focus on Security and Backups, while I focus on BI, Database Development, etc. We...

greenmtnsun

01-01-2010 04:50 AM
Erland Sommarskog

My Server Admin and I share some DBA roles in our company, they focus on Security and Backups, while I focus on BI, Database Development, etc. We...

greenmtnsun

12-31-2009 05:35 PM
greenmtnsun

I confess that I'm not an SQL wiz. I want to create a maintenance plan to help me space management. Currently, I do a full backup on tape of my...

Andy Siegel

12-30-2009 05:27 PM
Erland Sommarskog

I used SQL developer edition in my pc. By accident, I deleted some files in installed folder. Now, I can not open management studio. I tried to...

aspfun via SQLMonster.com

12-30-2009 11:03 AM
Geoff N. Hiten

Hello Gurus I have been on the ms site for hours and cannot seem to get a good answer for the following question: Is a .bak file or a backup file...

Bill_Orova

12-30-2009 11:02 AM
Geoff N. Hiten

Hi I have a SQL Server 2005 cluster with 2 nodes. All SQL Service account are running in context of a domain account. Currently I have some issues...

MRWildiac

12-30-2009 10:35 AM
Geoff N. Hiten

This may be a stupid question but I couldn't get a definitive answer from MS literature. We've pretty much made the decision to move from SQL 2005...

Gunnertac

12-29-2009 05:32 PM
Erland Sommarskog

when i setup sql server 2005 x64 on windows 7 x64, I did not find the studio management, I only found configuration manager. what is my problem?

vblighteg

12-28-2009 12:24 PM
Erland Sommarskog

Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Home Edition Service Pack 3...

Richard

12-27-2009 10:50 PM
Richard

Hello: In SQL Server 2000 with service pack 4, I am running the script at the end of this posting to delete backup history. The reason that I am...

SQL Programmer

12-27-2009 06:11 PM
SQL Programmer

Hi, I reinstalled Windows XP Pro because I had to. I would like not to have to do it again. Before reinstalling SQL Server 2005, I installed EasyPHP...

Jac Tremblay

12-26-2009 05:15 PM
Erland Sommarskog

Hello All, I installed SQL Server 2008 Ent 64 bit TRAIL version on my test environment and it will expired soon. I need to convert the trail version...

Simon Liu

12-22-2009 06:06 PM
Erland Sommarskog

Environment: Win Svr 2008 SP2 x86 SQL Server Database Services 2008 Enterprise x86 Installation fails near the end with: Database Engine Services...

oradebug

12-22-2009 11:59 AM
cday

Hi all, I am in need of your help. One month ago I have upgraded my 2 node SQL 2005 x64 ENT cluster from SP2 CU1 to SP3 CU5. After this change I...

Adam Przestroga

12-21-2009 03:48 PM
Adam Przestroga

Hi, I'm installing a second SQL Server 2008 WG instance to the server. Why does'nt the setup let me choose the collation settings for the...

NetGear

12-21-2009 02:39 AM
NetGear

Hi, I downloaded and installed SQL Express Server 2008 (using the web installer) plus a few other things at the same time. I then decided I wanted...

Frank

12-20-2009 12:10 PM
Frank

Hello: I was told that it is a good practice to place the data and log files of system databases on separate drives. When installing SQL 2005,...

childofthe1980s

12-17-2009 03:31 PM
Andrew J. Kelly

I have a client that is on SQL Server 2000 Standard with service pack 4. Although they have very few SQL jobs, their msdb database is huge. It...

childofthe1980s

12-17-2009 02:13 PM
Aaron Bertrand

I am trying to install SQL Server 2008 Enterprise (x64) on a Windows Server 2003 Enterprise x64 development server. I am getting errors...

Dencom

12-17-2009 12:03 PM
Dencom

XP Pro, SP2, dual monitors. Install from either SQLEXPR.EXE or SQLEXPR32.EXE, apparently same results - upon system startup, the PC keeps booting...

(PeteCresswell)

12-16-2009 05:14 PM
(PeteCresswell)

We are trying to install SQL Server 2008 standard onto our server that is also running SharePoint 3.0 services. Before doing the install, as...

KCB

12-14-2009 05:56 PM
KCB

In order to properly condition my SQL Express 2008 installer/updater (Installshield), I need to know which Registry keys to check for SQL...

JBaker

12-14-2009 04:31 PM
JBaker

Hi, I have Sql Server 2005 SP3 installed on a development machine, Intel Core 2 Duo, 2GB RAM (XP) For the exactly same database, on a Win Server...

Melina

12-14-2009 04:49 AM
Melina

Well, I got this bright idea to remove SQLExpress 2005 from my Visual Studio 2008 installation, and replace it with SQLExpress 2008, even...

Fred Chateau

12-13-2009 03:51 PM
Fred Chateau

In T-SQL, I know how to add stored procs and tables if they do not already exist. I am trying to figure out the right query for a job but am not...

SnapDive

12-12-2009 01:50 AM
Will Alber

Hi all, I can't install SP3 on a 2005 Cluster node. Here is part of the Installation Log. Can you help me? <EndFunc Name='LaunchFunction'...

BOBO

12-11-2009 10:30 AM
BOBO

Hi; I'm not a DBA. I'm working with some people who are running Microsoft SqlServer 2005. Right now, when people log into management studio, they...

steve

12-11-2009 09:32 AM
steve

Hi, When trying to install SQL Server 2008 the Installion Rule "Previus releases of Microsoft Visual Studio 2008" fails with the failed message...

glen

12-10-2009 10:04 PM
invegat@ns.com

Hello, I'm running SQL Server 2005 and we have two databases setup. These databases are virtually identical, one we call Live is our...

Linn Kubler

12-10-2009 05:27 PM
Erland Sommarskog

Hi I cannot install SQL 2008 SP1 (slipstream installation) on Windows 2008 R2. When I click setup.exe it says "Microsoft .Net Framework 3.5 SP1...

Javier

12-10-2009 02:36 PM
Javier

Hello! I am just trying to confirm that 'lock pages in memory' has no effect on SQL Server 2008 64-bit Standard Edition unless I have SP1 CU2...

Igor Marchenko

12-09-2009 06:50 PM
Will Alber

Hi, With Active/Passive failover clustering, the base OS must be Windows Server 2008 Enterprise (for the clustering aspect). What about SQL Server...

John

12-09-2009 10:52 AM
Tom Moreau

Hi, I am encountering an installation issue during I am installing SQL Server 2008 Standard/Enterprise Edition on a Windows Server 2008 R2...

Rodney

12-09-2009 05:35 AM
Alex chevalry

Moving from Sql '05 Workgroup running on SBS 2K3 R2 (with exchange/ISA/ DC etc) to Sql '08 Standard on a separate server. It is going on a 2Yr old...

MM

12-04-2009 10:30 PM
MM

Trying to use a sql statement to backup 50 databases in a SQL instance. Want to create a backup device for each database to write the full and also...

John

12-04-2009 07:00 PM
John

I am trying to upgrade an existing installation of SQL Server 2008 Enterprise Edition to the latest SQL Server R2 November CTP and it fails. The...

Cgallelli

12-04-2009 05:42 PM
Erland Sommarskog

This is a setup issue of our application. The app gets installed into the ProgramFiles-Dir and creates a subdir database...

Bernd Maierhofer

12-04-2009 05:36 PM
Erland Sommarskog

I have set up a new server and the sqlservr.exe process is only using 200 meg of memory instead of the usual 1.5 gig on a 32 bit server with 2 gigs...

Greg

12-04-2009 04:30 PM
Andrew J. Kelly

Hi, I am newbie to SQL 2008 installation - I installed SQL 2008 on to my Windows 7 , but I am not able to register my local server when I...

PhilN

12-04-2009 11:17 AM
Rick Byham, MSFT

Hi, I am trying to install SQL Server 2008 Developer on my Vista Ultimate x32 laptop. There are no errors or warnings, everything works perfectly...

invegat@ns.com

12-03-2009 07:15 PM
invegat@ns.com

Setup: Application server running Windows Server 2003 R2 Std., with Windows Defender and Symantec Corporate Antivirus v10.2. Intent is to use...

Mike in Nebraska

12-03-2009 10:11 AM
Frede

I have cluster servers (Primary and Secondary) I checked all the services about clusters all are working fine. I successfully installed SQL 2005...

Shahul Hameed

12-01-2009 02:10 PM
Geoff N. Hiten

XP SP3 SQL Server 2008 Standard Edition This box is purely for local software development purposes, so I don't really see the need for dedicated...

John Grandy

11-30-2009 05:26 PM
Erland Sommarskog

Hi, I try to deploy an application using a SQL server Express 2008 database. I do not want the user bothered with the normal setup procedure. I am...

EntiusGJ

11-30-2009 11:19 AM
EntiusGJ

I'm planning on upgrading my SQL server from 2003 to R2. Will this affec t the database at all? Thanks

vivavilla86

11-27-2009 09:37 AM
Russell Fields

Hi All, after sysprep of an SQL 2005 the SQL Server Agent won't start as any other account but Local System. I did change the server's name to mach...

Zoran

11-25-2009 05:53 PM
Erland Sommarskog