SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Running SQL Services with a domain account from a different domain

  If the proper trusts are in place - are there any pitfalls to doing this? Parent company wants us t…

  kingrudedog

  1 replies

  11 years, 5 months ago

  By: sql-lover

• Reloading agent settings

  Hi, every two minutes SQL Server adds a log entry "Reloading agent settings". Does anyone know why?…

  PHXHoward

  2 replies

  11 years, 5 months ago

  By: The Happy DBA

• all permissions of a user

  By using management studio, I grant a user database reader and db writer. And also execute on datab…

  sqlfriend

  2 replies

  11 years, 5 months ago

  By: Grant Fritchey

• Transaction Log Backup file inserted into table 2008R2

  Is it possible to read a transaction log backup file into a table to run queries on the dataz? (Not…

  delizat

  3 replies

  11 years, 5 months ago

  By: Gail Shaw

• Job Executed as user: DomainName\SQLServerAgent. The step was cancelled (stopped) as the result of a stop job request.Executed as user: DomainName\SQLServerAgent. The step was cancelled (stopped) as the result of a stop job request.

  I'm getting entries in the job history that the Job was canceled. The code is proprietary so I do n…

  Welsh Corgi

  2 replies

  11 years, 5 months ago

  By: Welsh Corgi

• AUDIT LOG DISPLAYS WRONG TIME ...?

  i have implemented the sql audit for the sql server 2008 sp1.When view the audit logs I am wonderin…

  AK1516

  6 replies

  11 years, 5 months ago

  By: jcvaquier

• SQL Agent permissions

  I've got an AD user group setup Doman\BI Admins that I've given SQLAgentOperatorRole, SQLAgentReade…

  robert.gerald.taylor

  3 replies

  11 years, 5 months ago

  By: robert.gerald.taylor

• SQL Server 2008

  I have transaction log backup failures randomly. SQL Server Log says 'Memory constraints resulted r…

  Grace09

  8 replies

  11 years, 5 months ago

  By: Grace09

• Restoring master database

  Hi Experts, I want to restore master database and when i tried the RESTORE FILELISTONLY it is givin…

  VastSQL

  25 replies

  11 years, 5 months ago

  By: Perry Whittle

• Performance statistics of OLEDB connections into SQL Server?

  I'm a newbie DBA and am trying to collect statistics for our existing SQL Server 2008 database in p…

  bcaruso 14201

  4 replies

  11 years, 5 months ago

  By: bcaruso 14201

• Page Verify Setting

  Hi There, I want to find out the current page_verify setting of all the databases my environment on…

  imranalaskar

  9 replies

  11 years, 5 months ago

  By: free_mascot

• BPATool

  how to run BPA tool against sql server database engine ? i have a sql server 2008 active passive cl…

  Dhruva_51

  2 replies

  11 years, 5 months ago

  By: Dhruva_51

• set page verify for all databases

  We have more than 100 databases and we would like to alter the db option "page verify" from "none" …

  beppe_30

  4 replies

  11 years, 5 months ago

  By: Lowell

• Cannot attach sql 2005 database to sql 2008

  Hi, I have a strange condition where certain SQL 2005 databases canot be attached to a sql 2008 ins…

  renitaj

  5 replies

  11 years, 5 months ago

  By: imranalaskar

• Page file in SQL 2008 Servers

  We have page file issue, when we set option "automatic managing page file from all drives", the C d…

  sri2015

  4 replies

  11 years, 5 months ago

  By: durai nagarajan