SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Maintenance Plan - Backup with checksum?

  We are in the process of upgrading our SQL 2K to SQL 2K8. We would like to use Maintenance Plan to …

  beppe_30

  10 replies

  12 years ago

  By: calico-604598

• Querying a Registered Server Group

  Hi everyone! OK, my goal is to be able to collect baseline statistic data from across all instances…

  kevaburg

  2 replies

  12 years ago

  By: kevaburg

• changing sql server port no in 2008R2

  hi, 1. if i change sql server def port no, sql server will work or not? what is the steps 2. in cl…

  gaddamshiva

  1 replies

  12 years ago

  By: Elliott Whitlow

• msdb backup fails.

  Hello everyone. I have a maintenance plan on my 2008 R2 server that takes a full backup of all the …

  raviteja_dasari

  16 replies

  12 years ago

  By: jr dba

• cpu peaks and -1 spids

  Hi, I am viewing the activity monitor and I see every 10-20 seconds the cpu goes from 2% to 80-90%.…

  sql007

  1 replies

  12 years ago

  By: Sreekanth B

• SQL server 2005 get slow after rebuild index online on few tables

  We have an customized JD Edward Enterprise One Application runs on Windows SQL 2005 Enterprise serv…

  sunny yang

  5 replies

  12 years ago

  By: SumLasty

• How to capture DNS alias info

  Hi, Is there a way in Sql server to capture the "DNS alias" being used in the connection string? Ap…

  VIJAYRANGA KONDAPALLY

  3 replies

  12 years ago

  By: VIJAYRANGA KONDAPALLY

• Advice about how to educate non technical bosses on new job

  Say you're the new DBA and the non-technical management has the junior network administrator instal…

  pharmkittie

  10 replies

  12 years ago

  By: free_mascot

• How important are log and database backups in a production environment?

  First let me say that even though this question in part pertains to SQL Server 2000 I am posting it…

  hmbtx

  5 replies

  12 years ago

  By: free_mascot

• FileStream Replication

  Hi, I have enabled FILESTREAM on my server [ stores Documents and attachements ]. how we will repli…

  Pulivarthi Sasidhar

  1 replies

  12 years ago

  By: free_mascot

• Restore Issues - Database In use mode?

  HI. Generally MS SQL SERVER 2008 R2 Entrprise Editon allowed for online restore process.. my case i…

  SQL Galaxy

  3 replies

  12 years ago

  By: free_mascot

• Patching

  Hi Experts, We have windows patching on SQL Server and the process we follow here is check jobs,kil…

  VastSQL

  5 replies

  12 years ago

  By: Jeff Moden

• CPU is higher than ever.

  we recently moved from 4 to 8 cores on the SQL server 2008 db in a vm environment (at hosting.com)…

  Penserver

  3 replies

  12 years ago

  By: Jeff Moden

• Page Splits /Sec

  Hi all Regarding the Page Splits /Sec counter, this tracks the amount of page splits per second as …

  SQLSACT

  6 replies

  12 years ago

  By: David Benoit

• Troubleshoot Slowness in Many Updates & Inserts

  I have a process that does 15-20 Inserts & updates of various tables. pretty simple code, no v…

  homebrew01

  1 replies

  12 years ago

  By: Grant Fritchey