SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• SQL Memory usage is high

  Hello, One of our production SQL cluster is eating up more memory on server. Here are the server sp…

  Robin35

  2 replies

  11 years ago

  By: virgo

• Only send DBMail when query results are present

  I have a job in SQL Server Agent that sends the results of a query to my email twice daily, however…

  sqlrd22

  16 replies

  11 years ago

  By: Rudyx - the Doctor

• Large mdf

  I have a production db with 3 file groups, mdf is approaching 1TB and I don't want it to grow beyon…

  SqlScared

  4 replies

  11 years ago

  By: Jeff Moden

• Trace Flag for execution plan with lot of memory?

  Hi Please correct me if I am wrong. The execution plan created for any query will also depend on th…

  wannabe1

  3 replies

  11 years ago

  By: dba-631539

• LogReader not starting after installing a new instance of 2K8 R2

  Hi there, My server is running with SQL Server 2008 and i had to do an installation of a parallel …

  kudz

  3 replies

  11 years ago

  By: SoHelpMeCodd

• Having issues with setting new location for tempdb.mdf & log files

  Hello all, I have a situation where the drive where my tempdb and templog files used to be hou…

  BC-36233

  8 replies

  11 years ago

  By: spaghettidba

• Please Verify - New Drive For Installation Folder and DB Migration

  We have a SQL Server 2008 R2 instance with the following features: C:\ - Installation folder D:\ -…

  Like2SQL

  4 replies

  11 years ago

  By: spaghettidba

• How to restore model database.

  How to restore model database. My Instance was down i deleted model database file. I have .bak file…

  rajeshjaiswalraj

  4 replies

  11 years ago

  By: Perry Whittle

• Utility Control Point random No Data Availble

  I have a Utility Control Point setup with a dozen servers/instances. When the UCP works, I can see…

  Kavic62

  3 replies

  11 years ago

  By: spaghettidba

• Looking For third party Tools.....

  Hi Experts i need some suggestion from your side.. We are planning to take third party tools for 1&…

  Chowdary's

  20 replies

  11 years ago

  By: barsuk

• "Error code 0x851B0001"

  I received an error message "Error code 0x851B0001" . SQL Server has encountered the following erro…

  akosinick13

  2 replies

  11 years ago

  By: akosinick13

• Backup strategy

  Hello all We currently take a log backup once an hour, a differential once a day and a full backup …

  Daniel Sempere

  4 replies

  11 years ago

  By: Clive Strong

• what is the difference between database refresh & Restore

  Hi please clarify . Please explain what is the difference between database refresh (when we go f…

  jamessdba

  8 replies

  11 years ago

  By: Clive Strong

• SQL2008R2: Standard edition vs. Developer edition

  Hello, My current SQL2k8R2 is Standard, I am looking for tracking changes in my database and came a…

  halifaxdal

  4 replies

  11 years ago

  By: halifaxdal

• Logshipping out of sync

  Hi, My Logshipping is showing out of sync (sqlserver 2008R2) Please provided the steps to analysis …

  jamessdba

  2 replies

  11 years ago

  By: Perry Whittle