SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• netbackup .bch to exclude database snapshots

  On some servers, we are using Veritas netbackup to backup our databases directly to tape. We speci…

  NJ-DBA

  1 replies

  15 years ago

  By: NJ-DBA

• Data file has been dropped but sql server wont let go

  Hey here is a question for you is there a way to have sql server let go of a data file thats been d…

  bopeavy

  25 replies

  15 years ago

  By: bopeavy

• Change the table design in sqlserver 2008

  Hi It was very easy to change the design of table in sqlserver 2000 by right click on it and chois…

  armm1388

  1 replies

  15 years ago

  By: BrainDonor

• What is a good SQL Server strategy for copy/move database tables between two location in different networks?

  What would be the best strategy for a SQL server database copy/move from a source location separate…

  odanwada

  9 replies

  15 years ago

  By: Perry Whittle

• Standard to Enterprise, In-Place or New Installation

  We are currently running SQL Server 2008 R2 Standard x64 We have to move to SQL Server 2008 R2 Ente…

  Melissa.Fischer

  10 replies

  15 years ago

  By: rfr.ferrari

• Error: Non-SysAdmins have been denied permission to run..... But the Owner and the person trying to start the job ARE sysadmin

  Ok, wierd case, I am getting the error when trying to start a maint plan job: Non-SysAdmins have be…

  Elliott Whitlow

  3 replies

  15 years ago

  By: Elliott Whitlow

• compressed index/partition impact on log, backup?

  Do a compressed table save work / resources in the log and/or backup processes? I'm thinking of add…

  Jonas Bergström

  4 replies

  15 years ago

  By: Jonas Bergström

• Does adding new SQL 2008 R2 named instance require a reboot?

  I have a SQL 2008 R2 server that I would like to add a named instance to. The new instance will al…

  bustell

  3 replies

  15 years ago

  By: Syed Jahanzaib Bin hassan

• Creating a new instance on SQL Server 2008 on a 2008 R2 Failover Cluster

  Hello All, We have a SQL Server 2008 instance on the cluster server and would like to add a new ins…

  chaudharyabhijit

  2 replies

  15 years ago

  By: Syed Jahanzaib Bin hassan

• MDS Home page redirecting to unauthorised.aspx

  Hi Team, Need some expert help! While I was trying access MDS home page its redirecting to unauthor…

  JoyKing

  4 replies

  15 years ago

  By: JoyKing

• Database Connection Time Outs

  [font="Tahoma"]Am Getting Connection Time out's at Fully loaded Time of my Database (500GB Space). …

  subramanyamv

  10 replies

  15 years ago

  By: rfr.ferrari

• Error installing Sql Server 2008 Enterprise R2

  Hi, I'm trying to install Sql Server 2008 Enterprise R2 (obtained from MSDN subscription) in a Wind…

  amns

  2 replies

  15 years ago

  By: amns

• What is the use of switch operator used in partitioning the data

  Hi, What is the use of switch operator used in partitioning the data in Sql Server 2008? I tried to…

  happysmile

  1 replies

  15 years ago

  By: Suresh B.

• Use of partition Functions

  Hi, Im preparing for my MCTS. Have no idea on what Partition functions are? Can someone help? 🙂

  happysmile

  4 replies

  15 years ago

  By: happysmile

• SQL server license

  We have project based teams to develop software. For example there are 10 people in the group. Each…

  sqlfriend

  4 replies

  15 years ago

  By: sqlfriend