SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Login Error

  An AD Account GroupA is created for a group of members I created a login GroupA for the AD account …

  clare.xia

  6 replies

  14 years ago

  By: clare.xia

• Log file shrinks itself

  I have a database where its log file seems to shrink itself. Our monitoring software (Idera) will …

  jbrown414

  6 replies

  14 years ago

  By: Evil Kraig F

• What is Schema Refresh in SQL SERVER ?

  hI Friends, Can someone explain what is Schema Refresh in SQL SERVER ?

  madhuu1905

  3 replies

  14 years ago

  By: Elliott Whitlow

• Affinity mask VS Resource Governor

  Hi, I'm working on the integration of a software which has it's own DB, uses a Sharepoint DB and a …

  FIJITechnologies

  4 replies

  14 years ago

  By: sqlblogi

• Transaction Log Issues After Upgrade to SP1

  We upgraded to 2008 R2 SP1 over the weekend. Since the upgrade, one of our instances of SQL has ha…

  Gerald Black

  3 replies

  14 years ago

  By: Gerald Black

• Problem in upgrading SQL SERVER 2008 Enterprise to R2

  Hii, I am working on the upgrade process of sql server enterprise 2008 to R2 version. I am having p…

  deep_kkumar

  3 replies

  14 years ago

  By: Devendrakumar

• Evaluating Index Usage for Index Maintenance Script

  Hello, I'm thinking of evaluating the index usage of my database to my Index maintenance script but…

  rodmeans

  4 replies

  14 years ago

  By: NickDBA

• Merging Data from different databases into one

  Could someone please assist, I need to combine 5 databases on seperate servers into one database on…

  SQL_Student

  8 replies

  14 years ago

  By: Pradyothana Shastry

• Database Maintenance Plan and log file size

  We have a database with many tables. We take hourly transaction log dumps and run a nightly mainte…

  Barkingdog

  9 replies

  14 years ago

  By: Gail Shaw

• Table Description

  I am having problem in generating the table description for a Single Database. I am trying to gener…

  DBA_Learner

  4 replies

  14 years ago

  By: DBA_Learner

• Graphical Query Plan

  Hi I am using SQL2008R2SP1. Is there a way I can view a graphical query plan from showplan xml? I …

  DataDave

  2 replies

  14 years ago

  By: DataDave

• Server communication failure SSPI LOGIN failed on the host WIN-Server

  Hi all, i have an error "Server communication failure SSPI LOGIN failed on the host WIN-Server" whi…

  vkr.karthick

  1 replies

  14 years ago

  By: deep_kkumar

• SQL 2008 Reporting Service in Sharepoint Integration mode

  Hi folks, Does any body setup the SSRS in Sharepoint integration mode ? We are getting the followin…

  ALAKIRAN

  1 replies

  14 years ago

  By: ssora-dba07

• Backup strategy for point in time recovery

  Hi, We have a SQL Server 2008 database which currently has a once a day full backup and a once a da…

  Paula-196779

  5 replies

  14 years ago

  By: Paula-196779

• Restoring a TL that returns error "logical consistency-based I/O error" ?

  Please help or guide in this problem, never had this before. While restoring all teh trasnaction l…

  imtiazm

  7 replies

  14 years ago

  By: Devendrakumar