SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• SP on cluster

  We have an Active-Passive SQL Server 2008 Failover Cluster installed. Front end is sharepoint. The…

  sqlfriend

  9 replies

  12 years, 7 months ago

  By: Andrew G

• Service SQLExpress does not start oall of the sudden.

  c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\SQLAGENT.EXE" -i SQLEXPRESS …

  peerless

  9 replies

  12 years, 7 months ago

  By: peerless

• dbmail problems on SQL 2008 /SBS 2008 64bit

  Hi, I'm neither a DBA nor a Sys Admin person, More a coder but I've been asked to move a database a…

  mike.harknett

  4 replies

  12 years, 7 months ago

  By: malleswarareddy_m

• SQL Server Setup failure

  I'm trying to install SQL Server 2008 R2 on Windows Server 2003 R2. As soon as I run the setup.exe…

  jds1207

  1 replies

  12 years, 7 months ago

  By: Loundy

• stored proc taking more time when executed thru a job

  I have a stored proc which collects the primary key values into temp table and delletes the rows f…

  Dhruva_51

  2 replies

  12 years, 7 months ago

  By: SQL Show

• Error: 17066, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

  Dear Sir, We are using sql server 2005 standard edition. Ram is 4GB. Today we got this below error.…

  Minto Minto(quendans)

  1 replies

  12 years, 7 months ago

  By: Joie Andrew

• Edition upgraded after Maintenance plan was failed?

  Hi, Recently upgraded done from standard edition to enterprise edition and SP3, after that Backup m…

  SQL Galaxy

  1 replies

  12 years, 7 months ago

  By: Andrew G

• restoring partial partitioned database

  Hi all, I'm rather inexperienced in the Data Warehouse side of SQL, but we have rather small sized …

  UserRR

  4 replies

  12 years, 7 months ago

  By: UserRR

• Added node to clustered sql prior to installing SQL on it, what to do :)

  Hi - I am suppose to setup an active/active clustered server (none of servers had any sql on it, th…

  lsalih

  3 replies

  12 years, 7 months ago

  By: Andrew G

• Moving everything on an SQL instance to new hardware

  We're setting up to move everything from a 32 bit machine to a 64 bit machine. I'm still researchi…

  Jeff Moden

  6 replies

  12 years, 7 months ago

  By: Summer90

• Business Analyst report tools

  I have a group of Business Analysts that I will soon be working closely with to further their repor…

  pharrell

  1 replies

  12 years, 7 months ago

  By: pharrell

• Multiple exec plans for same stored procedure

  We have vendor software that uses a lot of resources on our production server. As part of analysis …

  jhager

  10 replies

  12 years, 7 months ago

  By: Gail Shaw

• Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'.

  I'm setting up SCOM 2012 with the SQL Server Management Pack and I'm getting these errors: Could n…

  Julian Milano-440574

  10 replies

  12 years, 7 months ago

  By: Orlando Colamatteo

• client was unable to reuse a session?

  Hi. Error messages, The client was unable to reuse a session with SPID 246, which had been reset f…

  SQL Galaxy

  7 replies

  12 years, 7 months ago

  By: SQL Galaxy

• Memory and tempDB on SQL server

  Hello guys, notice : my boss finally went out and I can focus to optimalizing. 😀 So its his work. …

  tony28

  2 replies

  12 years, 7 months ago

  By: tony28