SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Compare and sync different databases using management studio

  Can anyone please guide me in doing this ?

  AK1516

  1 replies

  14 years, 10 months ago

  By: John Rowan

• Info on a failed backup

  I'm looking for a field in the MSDB backup tables to query against for any failed backups. For exa…

  Josh B

  3 replies

  14 years, 10 months ago

  By: Josh B

• 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 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

  14 years, 10 months ago

  By: herladygeekedness