SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• upgrading SQL SERVER 2005 Enterprise to 2008 R2

  I am kind of newbie on this. We need to upgrade SQL server 2005 to 2008 R2 (Both Enterprise Edition…

  SQL_Surfer

  1 replies

  14 years ago

  By: Orlando Colamatteo

• Moving large files/backups across data centers.

  Hello, I'm looking for a solution for moving large files across data centers (in the sense of makin…

  Xxx

  5 replies

  14 years ago

  By: Orlando Colamatteo

• How to Create failover ssis package one server to anthor server

  can you any one help me how to create siis package for mirroring failover server to server give me …

  ARUN KUMAR AGUNURU

  1 replies

  14 years ago

  By: Orlando Colamatteo

• SQL 2000 -2008 migration does it work ?

  Hello all, Is it possible to migrate from SQL standard edition to SQL 2008 web edition, without ha…

  pk2011

  1 replies

  14 years ago

  By: Orlando Colamatteo

• File Locations and SANs

  I want to make sure I don't cause my data files and transaction logs to compete for resources. As s…

  Sioban Krzywicki

  12 replies

  14 years ago

  By: brendan woulfe

• Automating SQL Server Service Pack installation

  Hello all, I need to upgrade the Service Pack level on my office environment servers and as the num…

  rahulr.sharma

  4 replies

  14 years ago

  By: okbangas

• I am not finding Connect and object explorer in sql2008r2

  Hi, I am not finding Connect and object explorer in sql2008r2 I tried in view it not show there too…

  ARUN KUMAR AGUNURU

  5 replies

  14 years ago

  By: ARUN KUMAR AGUNURU

• sqlcmd and registered servers

  Anyone know if it's possible to query a list of registered servers via sqlcmd? I'm not seeing anyth…

  Jon.Morisi

  1 replies

  14 years ago

  By: Elliott Whitlow

• Indexing in sql server 2008R2 versus sql server 2005

  Hi Experts, I have recently migrated my Navision database (340GB in size) from MSSQL 2005 Enterpris…

  Eswin

  14 replies

  14 years ago

  By: Eswin

• read images from datbase and write to file system in tsql

  Hi folks, I have the sql server 2005 database with images loaded in the varbinary datatype in the t…

  AK1516

  2 replies

  14 years ago

  By: jonsborn

• how to shrink this DB without suffering downtime?

  I've been wandering in circles looking at a bunch of postings without finding a conclusive recommen…

  mrTexasFreedom

  8 replies

  14 years ago

  By: Jeff Moden

• Log File out of control

  When I have a log file growing exponentially or if the log file is filled up, I do a log file backu…

  alanspeckman

  5 replies

  14 years ago

  By: Ninja's_RGR'us

• SQL Agent job notifications for success and failure

  Hello All Is it possible to setup notifications in jobs to send an email for both the conditions of…

  anish_ns

  2 replies

  14 years ago

  By: anish_ns

• Shrink and backup

  People, I need a help. A have to create a maintenance plan with next steps: 1. Set recovery model …

  imilikic

  37 replies

  14 years ago

  By: Chris Metzger

• TempDB Test question

  Hi, We're planning on testing performance of TempDB on a new storage device. If we update master D…

  Lexa

  5 replies

  14 years ago

  By: Lexa