SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• SSMS Connection via IP issue

  Just installed new Instance INST02 on Sql server Cluster (2008 R2). For Test tried to connect (from…

  Yuri55

  3 replies

  11 years ago

  By: Perry Whittle

• How to Monitor the Job which is running out of max time

  Hi All, Thanks in Advance. How can we identify what ever the jobs are running out max time based on…

  New persopn

  3 replies

  11 years ago

  By: Grant Fritchey

• 2nd instance added should I have used different port

  I have added another instance to a stand-alone sql monster 2008r box that has a complete install (…

  tcronin 95651

  4 replies

  11 years ago

  By: tcronin 95651

• difference tail log backup vs point in time

  Hi, On what situation we will go for tail log backup & point in time restore Please clarify.

  jamessdba

  2 replies

  11 years ago

  By: Perry Whittle

• How to setup a new instance - SQL2008 R2

  Hi - I've been asked to setup a new instance for a single database that wil be used for reporting f…

  dax.latchford

  6 replies

  11 years ago

  By: Perry Whittle

• Sql server Mangement using 7.5 Gb out of 8 Gb

  Hi friend, This is subbareddy, i am working sql developer in healthcare domain, one of my client…

  ksubbareddy.sap

  2 replies

  11 years ago

  By: Eirikur Eiriksson

• Distributor To subscriber Error (Unable to to fix this)

  Hi, In Distributor to subscriber History: Initally we had a some error in sync that is target sche…

  Saravanan_tvr

  4 replies

  11 years ago

  By: Saravanan_tvr

• 2 unique indexes

  Maybe I am getting old or just can't see the obvious. I have a 3rd party db with a table called tr…

  tcronin 95651

  6 replies

  11 years ago

  By: tcronin 95651

• SQL server Agent Log on on issue...

  Hi All, when i installed the sql server for SQL Agent Server i have selected account as SYSTEM ,A…

  Chowdary's

  2 replies

  11 years ago

  By: arnipetursson

• Backup Size

  Hi All, I was told by my seniors that that the backup size will be more in compare to actual size o…

  rajeshdba83

  4 replies

  11 years ago

  By: arnipetursson

• Heap table fragmentation question

  On my database there are 9-10 Heap index type. some of them are 99% fragmented. I learned from onli…

  Dan121

  3 replies

  11 years ago

  By: Gail Shaw

• service pack question.

  I have right now SQL 2008r2 RTM. First, If I want to patch with SP3, should I apply SP1, SP2 first …

  Dan121

  5 replies

  11 years ago

  By: Dan121

• SQL Server Agent Job Issue..

  Hi All, http://www.sqlservercentral.com/Forums/Topic1629435-2799-1.aspx pls help me out.... Regards…

  Chowdary's

  2 replies

  11 years ago

  By: Chowdary's

• Erroneous results on last_execution_time, execution_count obtained from DMV sys.dm_exec_procedure_stats

  When I run the following query to get the last execution time and execution count of a stored proce…

  Marios Philippopoulos

  6 replies

  11 years ago

  By: klebert

• Restore Problem - connections to DB

  Okay - I am trying to restore a 'TEST' database using a copy of my ' LIVE' (ERP Databases) I am get…

  Bron Tamulis

  2 replies

  11 years ago

  By: arnipetursson