SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Moving data file from to a new location

  Hi All, Need some suggestion from experts. We are using Microsoft SQL Server 2012 (SP1) . Databas…

  vsamantha35

  2 replies

  9 years, 10 months ago

  By: Y.B.

• Memory Grants Pending

  Hi all, I have problem with Memory Grants Pending value on one of the prod. servers. Usually it is …

  rbednarek

  6 replies

  9 years, 10 months ago

  By: feersum_endjinn

• CHECKDB can't create snapshot because of file extension used

  I'm running SQL Server 2008 R2 on Windows Server 2008 R2, and I'm having trouble using CHECKDB in o…

  greg.wolford

  6 replies

  9 years, 10 months ago

  By: greg.wolford

• Report Services Fails to Start, and fails installation

  I wanted to post this so it would be out there on the Web for anyone else searching for a solution …

  SQLBalls

  4 replies

  9 years, 10 months ago

  By: kommamadhu

• Methods to copy a standby database

  Hi All, I've searched SSC and have asked Google and the answer to my question seems more of a hack …

  feersum_endjinn

  9 replies

  9 years, 10 months ago

  By: feersum_endjinn

• using SP_WhoIsActive trying to track down the job step

  I am getting, for Program Name, SQLAgent - TSQL JobStep (Job 0xBEB303926F0CE848BA3F9858417DB773 : S…

  dwilliscp

  3 replies

  9 years, 10 months ago

  By: Y.B.

• Troubleshooting Linked Server creation using Windows authentication

  I have a feeling the response is going to be "google 'sql server' and 'double hop'" but for my own …

  RP_DBA

  2 replies

  9 years, 10 months ago

  By: Ant-Green

• sqlserver.exe and SSMS show incorrect version but reports show differently

  I have recently installed SP3 onto SQL 2008 R2 - in the bootstrap summary file all of the product f…

  glosboy

  1 replies

  9 years, 10 months ago

  By: SoHelpMeCodd

• Help with If statement in SQL job

  Preface: sorry in advance for the nubness of my question. I am sure this is trivial to 95% of you.…

  respawn

  3 replies

  9 years, 10 months ago

  By: SoHelpMeCodd

• Tempdb configuration advice

  Hi All, Seeking for your guidance on Tempdb We have tried to optimize Tempdb is out env. Below are …

  vsamantha35

  11 replies

  9 years, 10 months ago

  By: Gail Shaw

• Send email when application user login to SSMS

  Hello, I need to create some trigger or some other mechanism so that I can get email when developer…

  dallas13

  13 replies

  9 years, 10 months ago

  By: dallas13

• Log shipping, Orphaned User, and Read-only Issue

  Forgive my greenness.. but would appreciate some help on this... We are doing development work on a…

  kenny 40254

  1 replies

  9 years, 10 months ago

  By: Perry Whittle

• Service Won't Start under NT AUTHORITY\NETWORKSERVICE

  Hi, I have a client running SQL Server Express 2008 R2 for a couple of years now. As of last Frida…

  Frank Cazabon

  4 replies

  9 years, 10 months ago

  By: Frank Cazabon

• Event errors

  Hi All, I unable trouble shooting following events in my error logs where databses are set to SQL D…

  cmc123

  1 replies

  9 years, 10 months ago

  By: cmc123

• Backup procedures for server

  I have setup a maintenance plan that runs a full backup of a TDE enables database nightly. but befo…

  Yakko_Warner

  2 replies

  9 years, 10 months ago

  By: Gail Shaw