SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• WS2008 R2 in place upgrade and SQL Server 2008 R2 gotchas?

  Hi, We have a server that needs more memory but we've hit the 32GB limit imposed by Windows Server …

  Ginga

  9 replies

  11 years, 11 months ago

  By: Perry Whittle

• Applications installed

  Hi Experts, Is there any way we can find the list of applications installed in a SQL Server box usi…

  VastSQL

  5 replies

  11 years, 11 months ago

  By: Bill (DBAOnTheGo)

• understanding with Replace option in restoring database

  I was unable to restore database because of missing backup file and got LSN error then I tried to r…

  sej2008

  1 replies

  11 years, 11 months ago

  By: Gail Shaw

• Trace File Rollover & EndTime

  I have a server side trace running, and curious how long running jobs are logged. If the trace star…

  homebrew01

  6 replies

  11 years, 11 months ago

  By: Grant Fritchey

• Stop/Start SQL Server Agent

  Is there anyway to stop and start the agent, if you are not a local/network admin? As a DBA IT will…

  dwilliscp

  10 replies

  11 years, 11 months ago

  By: EdVassie

• Which is Best, CDC or DDL Trigger for Auditing !!

  Hi, Could someone, suggest me which would be the best to Implement for tracking the DML Activites a…

  prabhu.st

  5 replies

  11 years, 11 months ago

  By: prabhu.st

• Full backup Internals

  Hi folks, I need some clarification related on FULL Backup. Scenario - Some one exec SP which conta…

  anil702

  9 replies

  11 years, 11 months ago

  By: Ravid_ds

• Logins per Second is over the threshold

  Hello. I got this problem in my Production Environment. SQL Server Instance Logins per Second is 4 …

  Andy CP

  7 replies

  11 years, 11 months ago

  By: Gail Shaw

• I can't attach my database to SQL Server 2008 Instance

  I was attaching database named 'Books' on SQL Server 2012 instance , and when I detach 'Books' data…

  MohamedDBA

  8 replies

  11 years, 12 months ago

  By: free_mascot

• Bi-Transcational replication Via script

  Hello All, Will you please provide me the good link to replication on two servers? help

  smer

  2 replies

  11 years, 12 months ago

  By: MysteryJimbo

• A fatal error occurred input error: 64?

  Hi, Server OS - win 2008 R2 enterprise edition 64 bit Database - SQL server 2008 R2 enterprise edti…

  SQL Galaxy

  2 replies

  11 years, 12 months ago

  By: SQL Galaxy

• Script to Delete Reports Older than a Certain Number of Days

  Hello Everyone! I am a novist in T-SQL programming. I have an urgent task, as part of the maintenan…

  Simbo_mk

  16 replies

  11 years, 12 months ago

  By: Jeff Moden

• Maintance plan -- full backup error

  Hi, We do run a maintenance plan full backup job for all db's in the server. The job is able to ta…

  sita.yeleswarapu

  12 replies

  12 years ago

  By: HanShi

• What to look for in Execution plans when a query is slow ?

  Hi Pals, Assuming the query execution is slow , I have collected the actual execution plan. What sh…

  Oracle_91

  9 replies

  12 years ago

  By: Grant Fritchey

• will shrink log file or database file cause log file\backup chain to break??

  Hi Experts, Can anyone please let me know whether shrinking log file or database file cause log fil…

  VastSQL

  3 replies

  12 years ago

  By: VastSQL