SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Want to ensure I'm not going to break my SQL Server service account

  I'm working on cleaning up some bad choices made during SQL setup on a few boxes of mine, and one o…

  jasona.work

  10 replies

  11 years ago

  By: jasona.work

• Logshipping failing due to log backup missing

  Hi every one i have problem related to logshipping , i am taking log backup every hour and restore …

  aprathour.89

  1 replies

  11 years ago

  By: Gail Shaw

• master.dbo.xp_delete older backup files not deleted

  Hi Below Command is working with SSMS without any errors. Management plan job dos not delete older…

  SQL Galaxy

  5 replies

  11 years ago

  By: Perry Whittle

• SQL Server Administration

  My Client does not want DBA to view user tables/Data in Sql server database on every instances but …

  rishikesh.tiwari

  1 replies

  11 years ago

  By: Gail Shaw

• how to control LDF file growing size?

  Hi. Generally shrinking Transaction log file is not recommended and it is not best practices also. …

  SQL Galaxy

  1 replies

  11 years ago

  By: Gail Shaw

• Sql Server - Running a Job on Multiple servers

  I am using SqlServer 2008. I have a Sql Server Job that checks Disk Space and emails admins if the …

  SmilingLily

  10 replies

  11 years ago

  By: barsuk

• How to kill current queries taking most cpu.

  Hi All, User calls up and tell that SQL Server is using 100% CPU. Please find the most expensive qu…

  Joy Smith San

  22 replies

  11 years ago

  By: Joy Smith San

• performance counter prepare values

  Hi all Please tell me the which values are best prepared value for given below memory objects Memo…

  hanumanth.jkc

  2 replies

  11 years ago

  By: Stuart Davies

• Trouble Installing SP3

  I am trying to install SP3 for SQL Server 2008 R2 and when i double click on the file it extracts a…

  jayoub

  1 replies

  11 years ago

  By: CooLDBA

• Replication - adding an existing column to an existing publication

  Hi All, I've been trying to find some information on the behaviour of this, but haven't really foun…

  Matthew Darwin

  4 replies

  11 years ago

  By: Matthew Darwin

• Is there any way to find who whas configured replication in SQL Serve 2008/2005 ?

  Hi, Is there any way to find who whas configured replication in SQL Serve 2008/2005 ? And one needs…

  Joy Smith San

  2 replies

  11 years ago

  By: Grant Fritchey

• Replication error

  Hi All, Please see the attached error. Please guide how to resolve this issue. I tried creating Ali…

  Joy Smith San

  2 replies

  11 years ago

  By: Joy Smith San

• SQL Server 2008 Express: The login is from an untrusted domain and cannot be used with Windows authentication

  On the server computer, I have installed SQL Server 2008 Express, I set the firewall rules for TCP …

  radu.sandu

  2 replies

  11 years ago

  By: radu.sandu

• SQL Server closes database backup request to NAS share in middle of restore

  We have an issue with our Dev and Test servers for some of our larger database backups. Whether we…

  Brandie Tarvin

  12 replies

  11 years ago

  By: SQLRNNR

• SQL 2008 R2 Background Process

  There is one background block by process is running (spid:41) with sa user on User database. this p…

  sri2015

  1 replies

  11 years ago

  By: Grant Fritchey