SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Restore in different files

  Hi, I did a backup of a database on SQL2008R2, databasename.bak and need to restore it to another s…

  sqlblue

  5 replies

  11 years ago

  By: Steve Jones - SSC Editor

• How to apply service pack2 on production server

  Hi experts currently we have below setup on windows server box windows server 2008R2 Enterpise ed…

  jamessdba

  3 replies

  11 years ago

  By: spaghettidba

• Limiting User Connection From A Specific Server

  Hi, We are running SQL Server 2008r2 SP2 Standard Edition. Connections into an instance came in fro…

  rick_buchan

  1 replies

  11 years ago

  By: spaghettidba

• database initial size changed

  Hello, I have a simple, most likely not very simple answer. I have a database which log grew prett…

  HildaJ

  1 replies

  11 years ago

  By: Jack Corbett

• CHECKTABLE

  Hi Experts, What exactly happens when we run a CHECKTABLE? What happens if we stop the same in betw…

  VastSQL

  9 replies

  11 years ago

  By: VastSQL

• Very Large Transaction Log File

  Hi - I'm currently investigating performance issues for an application running on a sql2008 back en…

  dax.latchford

  10 replies

  11 years ago

  By: Gail Shaw

• Where to find debugging symbols for SQL2008R2 SP2

  Hello all, I have a problem with one of the SQL Server installations running SQL2008R2 SP2. Users c…

  Arthur Baan

  1 replies

  11 years ago

  By: Gail Shaw

• CDC polling mechanism

  Can anyone explicitly explain how SQL Server conducts polling for CDC, the documentation states tha…

  chambers_sh

  4 replies

  11 years ago

  By: MMartin1

• High CPU Usage for hours

  Hi Experts, High CPU usage of above 95% for hours will bring SQL Server down?

  Rechana Rajan

  4 replies

  11 years ago

  By: Igor Micev

• Database Timeout Because of Profiler

  Is it possible to have database timeout because of running SQL Profiler. Thanks Rechana

  Rechana Rajan

  7 replies

  11 years ago

  By: SQLRNNR

• Does number of indexes affect log space required for REINDEX ?

  Hi All, Does number of indexes affect log space required for REINDEX ? Thanks in advance. Smith.

  Joy Smith San

  7 replies

  11 years ago

  By: SQLRNNR

• Opinions on 2008 R2 SP3

  I have a clustered server (nodes A & B). The server is experiencing a problem that Microsoft s…

  robin.pryor

  2 replies

  11 years, 1 months ago

  By: robin.pryor

• Unable to view SQL Server Agent while logged in as user

  Hi All, I have granted SQLAgentUserRole permission to one of the user and using enterprise edition …

  kumarjohnt

  3 replies

  11 years, 1 months ago

  By: Cath Trimble

• How Do I Extract Few Months/Weeks of Data

  We have a database which is becoming too big (lots of historical data). We want to extract a few we…

  Like2SQL

  5 replies

  11 years, 1 months ago

  By: Ed Wagner

• CXPACKET wait percentage 47% - always?

  One of the production server CXPACKET wait percentage continuously using 47.89 % on today, yesterda…

  SQL Galaxy

  4 replies

  11 years, 1 months ago

  By: Gail Shaw