SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Need a Query to Capture all the information In SQL

  Hi All, We are in the process of creating inventory, for that I need a query to capture the below i…

  New persopn

  4 replies

  9 years, 11 months ago

  By: Lowell

• Database in Suspect Mode

  Experts, Database went into suspect mode because of disk offline,bring is disk online and the DB st…

  VastSQL

  7 replies

  9 years, 11 months ago

  By: Perry Whittle

• Retrieving DDL & other object changes from DMVs

  Hello everyone, I have a server that has 8 user databases. This is a DEV/QA database with several u…

  SQLCurious

  6 replies

  9 years, 11 months ago

  By: Grant Fritchey

• Full Backups failed

  Hello -- We are running 2008R2 64-bit server on a Windows 2012 R2 Standard 64-bit distribution. Our…

  kaplan71

  4 replies

  9 years, 11 months ago

  By: HappyGeek

• Development Environment for Linux Developers accessing SQL Server

  Hi I wanted to ask what do 'other' organizations do from an infrastructure and workstation setup lo…

  sqlsurfing

  3 replies

  9 years, 12 months ago

  By: sqlsurfing

• NT SERVICE\SQLSERVERAGENT

  I just setup a new SQL server 2008 R2 server on a windows R2. I noticed in the logins menu, I see t…

  sqlfriend

  16 replies

  10 years ago

  By: fundpc

• Table partitioning automatic procs

  Hi, I am in the process of partitioning a very large database and using the sliding window techniqu…

  jaiki987

  4 replies

  10 years ago

  By: JakDBA

• Can't shrink huge log file (.ldf) on MSDB database

  On one of our SQL Server 2008R2 instances the MSDB log file (MSDBLog.ldf) has grown to 400GB+. The…

  Wayne Erfling

  5 replies

  10 years ago

  By: Wayne Erfling

• Full Backup Report

  Hi, according to envionemnet .we are planning to genrate the weekly full backups report of all the …

  Arjun SreeVastsva

  2 replies

  10 years ago

  By: Arjun SreeVastsva

• "lock pages in memory" not enabling on 2008 R2

  I'm trying to enable "lock pages in memory" on this server: Microsoft SQL Server 2008 R2 (SP3) - 1…

  Larry Leonard-399461

  2 replies

  10 years ago

  By: SoHelpMeCodd

• how to restart or take db in single user mode by hounering all requests.

  hi, some times i need to take db in single user mode , which can be done using following use ma…

  rajemessage 14195

  2 replies

  10 years ago

  By: Lowell

• SQL Instance not taking min memory

  Hi, I have an which complains about memory relates issues like PLE & Procedure Cache Hit Ratio…

  Vets5

  2 replies

  10 years ago

  By: Eric M Russell

• Agent job slow on first run

  I have a SQL Server agent job that runs in 2 minutes on average. This job is scheduled to run from …

  tindog

  6 replies

  10 years ago

  By: tindog

• Why so some suggest converting to SIMPLE prior to shrinking LOG file

  I've been looking for techniques to shrink a logfile (a database was set to FULL for quite awhile w…

  chuck.forbes

  12 replies

  10 years ago

  By: Gail Shaw

• Manual UnInstall for SQL Server 2008 R2 standard edition

  Hi, I have installed sql server 2008 R2 standard edition twice, default and another named, both of …

  ALIF-662928

  7 replies

  10 years ago

  By: MudLuck