SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• SQL Server 2008 R2 SP2 and KB2551254

  Hello, I'm in process of installing several servers with SQL Server 2008 R2 SP2. So far I've compl…

  Tony Fountain

  13 replies

  9 years, 10 months ago

  By: srinivas_anumula

• Error in job cdc_capture

  Hi, I would like to help to solve the problem in the change data capture messages as below: Execute…

  jordjcs

  9 replies

  9 years, 10 months ago

  By: abassitt

• Connectivity errors

  Hi All, We are seeing intermittent communication link failures for sql jobs and we have to re-run t…

  vsamantha35

  2 replies

  9 years, 10 months ago

  By: vsamantha35

• sql memory paging detection?

  Hi All, Is there any easy way to detect SQL Server memory is getting paged out? My SQL Server Vers…

  vsamantha35

  3 replies

  9 years, 10 months ago

  By: vsamantha35

• Replication Distribution History using up 125GB TempDB

  Hi, How can I reclaim the TempDB space and prevent sys.sp_MSadd_distribution_history from using up …

  DennisPost

  3 replies

  9 years, 10 months ago

  By: DennisPost

• Backup files location

  I am creating 3 maintenance plans to backup database 1) for full backup of all database 2) for Tran…

  SqlServerLover

  1 replies

  9 years, 10 months ago

  By: Michael L John

• Agent job schedules - next run date - how it gets updated?

  Hi All, I want to understand the behavior of a scheduled job. Here is the scenario: I have a slow r…

  vsamantha35

  6 replies

  9 years, 10 months ago

  By: vsamantha35

• Transactional replication issue

  Hello, I do have set up for Transaction replication from SQL Server 2008 R2 to SQL Server 2012. i.e…

  free_mascot

  2 replies

  9 years, 10 months ago

  By: Brandie Tarvin

• Deny create table in [dbo] schema

  Hi all, I've got database called [test].Every user in this database is allowed to create/drop tabl…

  markoz.job

  2 replies

  9 years, 10 months ago

  By: markoz.job

• CAN PLE take down a server

  Ok sitting at desk Idera sends me alert that it can't connect to cluster. Login and yet it has res…

  tcronin 95651

  8 replies

  9 years, 11 months ago

  By: tcronin 95651

• Splitting data of MDF file

  Hi Experts, Need your inputs on below request. Looking for suggestions/scripts on achieving it. W…

  vsamantha35

  6 replies

  9 years, 11 months ago

  By: jmilter

• SQL Browser issue

  Hi All, I have seen this issue first time in SQL server 2008 where my application suddenly started …

  phaneekommula

  1 replies

  9 years, 11 months ago

  By: mark.williams 37494

• Help needed SQL Agent job related queries

  Hi All, I need some help on below 2 queries. 1) List out all jobs which are scheduled for today a…

  vsamantha35

  8 replies

  9 years, 11 months ago

  By: Rich Mechaber

• best way to handle large delete with a table with 5 image fields

  I have a 3rd party database that has an interface table that has 5 image data fields in it. about …

  tcronin 95651

  2 replies

  9 years, 11 months ago

  By: lnardozi 61862

• need tsql help on sql job

  Hi All, Need some tsql coding help on below ask. How to calculate estimated completion time of a …

  vsamantha35

  4 replies

  9 years, 11 months ago

  By: homebrew01