Administering

• Topics

  Started by

  Posts

  Last post

• Check memory

  Hello, I am trying to check if my SQL Server setting are correct: I have AWE checked min 250 MB max…

  Krasavita

  4 replies

  15 years ago

  By: Krasavita

• Sql Server Agent job

  HI, I have been deleted All job but still running backup job in sql server 2005

  arun.cnb

  2 replies

  15 years ago

  By: Skybvi

• Database log file full, Mirroring , please help

  Help me in shrinking the LOG file of huge database. its about 273 gigs of size and and its a Mirror…

  - Win.

  17 replies

  15 years ago

  By: Gail Shaw

• database mirroring monitor - remove server or database

  does anyone know how to remove a database from the database mirroring monitor once you have registe…

  Adam Angelini

  9 replies

  15 years ago

  By: FTdenali

• Shrinking a TLog while Mirroring

  I have looked on the Web as well as in this forum and I can't quite find a definitive answer on how…

  Reg_Mayfield

  17 replies

  15 years ago

  By: Gail Shaw

• job failed for ower of job have no server access

  I got some backup job of maitenance plan failed. I found the job is running an account under a dba …

  sqlfriend

  9 replies

  15 years ago

  By: sqlfriend

• Query plan re-use

  Hi, I've been checking one of the servers with this query: SELECT left(text, 30), count(*) FROM sy…

  Roust_m

  11 replies

  15 years ago

  By: curious_sqldba

• SQL Service Account - Identifying Folder Permissions

  I'm changing the account used for SQL Services, and the current account has various folder permissi…

  homebrew01

  2 replies

  15 years ago

  By: Shawn Melton

• database tracing (sp_create_trace) not working as expected

  Evening all, I'm trying to set up and SQL server trace using the create trace stored procedure. I…

  dave-dj

  3 replies

  15 years ago

  By: dave-dj

• SQL Deadlock

  Hello, I found a deadlock on the database, how can I find out what is objectid and how to fix this …

  Krasavita

  3 replies

  15 years ago

  By: Grant Fritchey

• sql server startup in minimal configuration mode and tempdb creation location

  Hi, In SQL Server 2005, At instance level i have changed my default database settings as below Data…

  Oracle_91

  1 replies

  15 years ago

  By: Perry Whittle

• SQLDump####.mdmp & txt filling C drive on a regular basis

  Hi All We have an instance of 2005 Standard to which keeps writing mdmp and txt files in the format…

  Ant-Green

  3 replies

  15 years ago

  By: Gail Shaw

• spid

  How can I find out what is spid 222? What is this error mean?? This is my error message: The client…

  Krasavita

  1 replies

  15 years ago

  By: SQLRNNR

• SQl Server went down

  Guys, My production server goes down every 2-3 weeks. I can't figure out why? 1.How can I put alert…

  Krasavita

  4 replies

  15 years ago

  By: Krasavita

• drop login

  I need to drop login as well as drop the same user from all the databases. (Login name and user nam…

  charipg

  4 replies

  15 years ago

  By: Sal Young