SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Database backup running out of space

  I have been using maintenance plans to backup all the user databases on my SQL Servers. Lately I ha…

  Aaron Christenson

  3 replies

  14 years ago

  By: PaulB-TheOneAndOnly

• ODBC Connection issues between XP Client and 2008 R2 MSSQL Express Server

  Hi- I'm trying to connect a client's XP windows machine via ODBC to a SQL EXPRESS 2008 x64 server. …

  jacobbdrew

  1 replies

  14 years ago

  By: NLV

• Installing updates on multiple instances?

  Likely an easy question. If we install multiple instances of SQL Server 2008 R2 (all will be the sa…

  jasona.work

  1 replies

  14 years ago

  By: MarkusB

• how to setup central publisher replication

  Hi, I am having trouble in setting up central publisher replication. I am having hard time to add a…

  deep_kkumar

  3 replies

  14 years ago

  By: Roy Ernest

• "EXECUTE msdb.dbo.sp_send_dbmail" runs in SSMS 2008R2 via Query but fails as stored procedure job.

  Environment: SQL Server 2008R2. Problem: "EXECUTE msdb.dbo.sp_send_dbmail" runs via SSMS 2008R2 via…

  hmbtx

  4 replies

  14 years ago

  By: hmbtx

• Sql Server Agent and Multiple Sql Instances

  Hi, Our app has 6 servers, a common, 4 identical servers where the data has been farmed out and a h…

  SteveScanlan

  2 replies

  14 years ago

  By: SteveScanlan

• file group backup vs differential backup

  I have a large database split into multiple file groups. We have one filegroup for each year ( fg20…

  arr.nagaraj

  7 replies

  14 years ago

  By: Devendrakumar

• Blocking

  Hi All, we are using SQL Server 2005 Working with Service broker technology along with replicatio…

  Simha24

  1 replies

  14 years ago

  By: Bhuvnesh

• sqlcmd app to connect to sqlserver

  Hi Friends, I am trying to start sql server and while starting i wanted users to connect using "sql…

  Oracle_91

  2 replies

  14 years ago

  By: Devendrakumar

• the rarer options on CREATE INDEX commands;

  I'm playing with scripting some of the little known options when you do CREATE INDEX. before you s…

  Lowell

  3 replies

  14 years ago

  By: okbangas

• processadmin - can it stop sql instance ?

  I tried to test that by creating a sql login, and giving it processadmin rights. Then loging in as…

  SQLEngine

  2 replies

  14 years ago

  By: SQLEngine

• deadlock capture.

  We are facing deadlock errors in application logs. but Deadlock events are not getting captured in …

  Satya_0000

  3 replies

  14 years ago

  By: Satya_0000

• Alter Index Fail Error: Invalid object name 'dbo.DatabaseLog'

  Hi Everyone, One of our SSIS jobs failed this morning(It's been running successfully for nearly 2 m…

  WillBen

  2 replies

  14 years ago

  By: Gail Shaw

• Install SP4 for SQL server through batchfile

  I am in the process of installing Service Packs for 2k5 and was wondering if I can create a batch …

  Trooper09

  1 replies

  14 years ago

  By: okbangas

• Copy Database error through SSIS

  Hi all, I am getting an error at the "Execute SQL Server Agent Job" step. When checking the log I c…

  mariobehring

  1 replies

  14 years ago

  By: SQLRNNR