SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Enable network transaction support in DTC for SQL 2005 & SQL 2008

  I have an SSIS package that is configured to use transactions. Unfortunately it is failing because…

  Daniel Bowlin

  1 replies

  15 years, 5 months ago

  By: colin.Leversuch-Roberts

• If Job Failed, then Rerun the same job

  Hi, Wish you a Happy New year to Everyone. I have one query like if any jobs failed then …

  balaji.ganga

  3 replies

  15 years, 5 months ago

  By: Koen Verbeeck

• replication with only 1 server

  Hi, I want to experiment replication or the fisrt time Question 1: Is it possible to build replicat…

  calico-604598

  2 replies

  15 years, 5 months ago

  By: Wildcat

• Weired Problem with Link Servers

  Hi I do configure all SQL link servers by creating SPN and delegation windows service account, it w…

  Tara-1044200

  1 replies

  15 years, 5 months ago

  By: Wildcat

• Handling Fragmentation

  I've been tasked with developing a package and database elements that will allow us to run Indexing…

  dndaughtery

  4 replies

  15 years, 5 months ago

  By: dndaughtery

• Your Opinion/Help Please

  Hi, I was wondering if you could please take a look at the way I'll be tackling partitioning and if…

  dajonx

  5 replies

  15 years, 5 months ago

  By: Steve Jones - SSC Editor

• How to copy/migrate maintenance plan ?

  Hi, I have created one maintenance plan which performs backups,index rebuilding,stats maintenance t…

  abdul.samad.121

  5 replies

  15 years, 5 months ago

  By: Koen Verbeeck

• Automated Restores

  On a regular basis, we restore production database to testing servers. To do this we must have no …

  SW_Lindsay

  9 replies

  15 years, 5 months ago

  By: Jeffrey Williams

• Connect to a distant server across the Internet

  I've been beating on this for several days, and feel I've missing some obvious point. We had a work…

  WendellB

  2 replies

  15 years, 5 months ago

  By: Steve Jones - SSC Editor

• Alert On Sql Server Agent Error Log

  Hi, Possible To Alert On Sql Server Error and Agent Error Log, Thanks

  SQL Galaxy

  2 replies

  15 years, 5 months ago

  By: SQL Galaxy

• SQL server Installation by Power User

  Hello All, My Organisation is facing an issue where due to restricted policy we can not provide Adm…

  rahulr.sharma

  3 replies

  15 years, 5 months ago

  By: Oliiii

• SQLServer taking 12GM of RAM how to trouble shoot it

  Hi, sqlserver taking 12gm Ram how to trouble shoot it .sql server is running slowley.

  narasimhareddy.dba

  6 replies

  15 years, 5 months ago

  By: Indianrock

• Move Database from SQL2000 to SQL 2008R2

  Hi All, I have to upgrade only the Database from SQL 2000 to SQL 2008R2. Please give suggestions or…

  Pulivarthi Sasidhar

  10 replies

  15 years, 5 months ago

  By: herladygeekedness

• Counter - Data File(s) Size (KB)

  Hi, 5400.00 MB total space 4073.31 MB used space 1325.79 MB free space I want raise alert when free…

  SQL Galaxy

  2 replies

  15 years, 5 months ago

  By: Sven Otromke

• Authority to perform DB backup

  I would like to create a maintenance plan on SQL 2005 for DB backup, user (bkoper) has been created…

  matthew.lau

  2 replies

  15 years, 5 months ago

  By: matthew.lau