SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Sql Server 2008 R2 takes more memory

  one of our new production server launched 3 days before, Windows 2008 and Sql server 2008 R2 with …

  solomon.jernas

  4 replies

  12 years, 10 months ago

  By: kevaburg

• Execution of SQL Job, the moment a file exist

  Hi, I have a scenario.. I have a SQL Job which needs to be executed based on demand, means the mom…

  dakshinamurthy-655138

  9 replies

  12 years, 10 months ago

  By: Orlando Colamatteo

• Fullbackup succeeded but no files in disk

  Hi , we are taking full backups every date with script .backup job status is successfull but only…

  Lavanyasri

  3 replies

  12 years, 10 months ago

  By: MyDoggieJessie

• Lock Pages in Memory

  I have Windows 2008 R2 with SQL 2008r2,RAM 16 GB If I am Setting SQL MIN & MAX memory to 13 GB…

  Akkare

  4 replies

  12 years, 10 months ago

  By: Abu Dina

• Restore space needed WAY more than bak file size

  I have a 14GB uncompressed .bak file that I'm trying to restore to a new 20GB (20,000MB) database t…

  peterjbassi

  6 replies

  12 years, 10 months ago

  By: Gazareth

• Running "DBCC FLUSHPROCINDB" as part of maintenance plan?

  Hey guys, I was looking through the database maintenance plan the other day, and it looks our vend…

  DVSQL

  7 replies

  12 years, 10 months ago

  By: Gail Shaw

• Backups to a Share Drive

  I execute the Job and it succeeds. However I go to the location that I specified as the backup loca…

  Welsh Corgi

  7 replies

  12 years, 10 months ago

  By: VastSQL

• To Re-index all indexes for a table.

  Hi All, I have to do re-index of all the indexes on a particular table, however, when I go to datab…

  SQLisAwe5oMe

  12 replies

  12 years, 10 months ago

  By: SQLisAwe5oMe

• Data and log files with UNC path

  Hi, I'm analyzing a server with a RAID50 system. The SAN is supposed to support 2000 IO operations …

  PiMané

  14 replies

  12 years, 10 months ago

  By: PiMané

• stop/start SQL services

  Hi, If I need to stop/start sql services since Windows will be shutdown for some time, what is the …

  SQLisAwe5oMe

  5 replies

  12 years, 10 months ago

  By: Orlando Colamatteo

• Database usage details (#reads & write times over a period)

  Hi Guys, I am actually looking out for some DMV or script based on which I can find database usage …

  Feivel

  4 replies

  12 years, 10 months ago

  By: Richard Fryar

• cdosysmail works for a few days then stops

  I am having an issue with cdosysmail. I am using this to send me an alert to tell if a SQL Agent jo…

  Tha Bizness

  16 replies

  12 years, 10 months ago

  By: Jeff Moden

• SQL patches

  Hi, Do anyone know how to check whatever patches we have installed in SQL server? 😀

  fatinfzi

  2 replies

  12 years, 10 months ago

  By: Orlando Colamatteo

• Change Owner of All Tables

  Hello Everyone I was wondering if there is a way to change owner of all tables in a database. I wou…

  AndrewSQLDBA

  2 replies

  12 years, 10 months ago

  By: Richard Fryar

• Cannot view Report Server Jobs in management studio

  Good Day Please assist, trying to view the Report Server jobs in management studio, but its blank, …

  SQL_Student

  14 replies

  12 years, 10 months ago

  By: Ant-Green