Administering

• Topics

  Started by

  Posts

  Last post

• Differential backups breaking Log shipping

  Hi Everyone, I have setup log shipping on a Primary Server for all the DB's. The Log shipping has …

  jack_kiran

  13 replies

  16 years ago

  By: Rajat Jaiswal-337252

• ANSI NULLS- QUOTED IDENTIFIER ON

  In my tools i took off all the ansi null options. I want to turn on ANSI NULLS- QUOTED IDENTIFIER …

  curious_sqldba

  3 replies

  16 years ago

  By: curious_sqldba

• Is it time to shrink my log file?

  I have a database where the data file is 7.5 gb, the log file is 4.1gb. The log file has 214 VLF's.…

  WayneS

  14 replies

  16 years ago

  By: alen teplitsky

• How to Move sql server 2005 cluster on windows 2003 to windows 2008.

  Dear Friends I need your Help, We are Trying to Move a SQL Server 2005 Cluster in windows server 20…

  psaikumar 41913

  1 replies

  16 years ago

  By: WayneS

• Update Stats job

  Hi, I run a update statistics job in hte weekend on one of our databases, the size of the datab…

  Skybvi

  22 replies

  16 years ago

  By: Skybvi

• SQL 2005 - when the databses are dropped why the maintenance plan doesn't pick up the changes

  Hi, In SQl 2005 when the databses are dropped why the maintenance plan doesn't pick up the changes …

  SqlSavy

  3 replies

  16 years ago

  By: Adiga

• Problem with dbcc shrinkfile(datafile,targetsize)

  My tempdb datafile stats is as follows. current size is 32526 MB space used is 76.69 MB I had onl…

  DBAsql-1046554

  19 replies

  16 years ago

  By: DBAsql-1046554

• Named SQL Server Instance

  Hi, We have a Default SQL Server 2005 & several other named SQL Server Instances on the same b…

  Jeetendra

  3 replies

  16 years ago

  By: Henrico Bekker

• Rebuild Index - Loghshipping

  If i rebuild an index on the source database which is logshipped , will the rebuilt index be done o…

  curious_sqldba

  9 replies

  16 years ago

  By: azad maratha

• Upgrading Win2008 R1 Std to R2 Ent with SQL Server 2005 Ent installed

  We wish to do an upgrade of the OS from (x64) Windows Server 2008 Std to R2 Enterprise to utilise m…

  ChrisTaylor

  2 replies

  16 years ago

  By: ChrisTaylor

• Ways to backup restore Very Large Database (VLDB)

  Hi, I was just approached to comment on the strategy to backup a database with initial size 2 TB an…

  Shriji

  13 replies

  16 years ago

  By: homebrew01

• using triggers to keep all versions of rows after update, delete + replication

  I maintain an application that uses SQL 2005 / 2008 for data persistence. Some clients use Merge Re…

  simonsmeets

  4 replies

  16 years ago

  By: GSquared

• I've tried this on 2 other forums, does anyone know the answer?

  I am fairly new to SQL Server, and an IBM DB2 DBA by training. We are implementing a new project he…

  troy.hodge-981400

  51 replies

  16 years ago

  By: waxingsatirical

• Database drops

  I recently had a client where someone dropped 2 databases thinking they were on the test sql server…

  imSQrLy

  5 replies

  16 years ago

  By: muthukkumaran Kaliyamoorthy

• Need to pull data from SQL Server using an intermediate server that does not have SQL Server - Best Approach?

  We need to pull data from a SQL Server using an intermediate server that does not have SQL Server i…

  malik_nagel

  6 replies

  16 years ago

  By: Evil Kraig F