Administering

• Topics

  Started by

  Posts

  Last post

• Log Shipping problem saving secondary destination configuration in SQL 2005

  Hi to all here, I am trying to setup a log shipping job using a primary and secondary server using…

  ac2

  7 replies

  5 years, 2 months ago

  By: IgorAmato

• Copy a SQL Job

  Hello Everyone I am wanting to copy a SQL job from one server to another server. How can I do this…

  AndrewSQLDBA

  9 replies

  5 years, 3 months ago

  By: Dominique DUCHEMIN

• QUERY: GET SPACE USED/FREE in All Databases

  Hello again, I need to get the following information: - Space Allocated from each database, - Space…

  JMSM

  28 replies

  5 years, 4 months ago

  By: Squatt Gmail

• How to split one mdf file into multiple file

  hi i have 2 tera database with 1 MDF = 1.9tera and 1 LDF = 100GB is there a way to split MDF into m…

  paksyeet

  11 replies

  5 years, 5 months ago

  By: lglenn1973

• ghost cleanup blocks checkpoint

  Sql 2005 64-bit Enterprise on Sql 2008 R2 64GB memory I've never seen this issue on any of our othe…

  Indianrock

  5 replies

  5 years, 6 months ago

  By: Jeff Moden

• How to find databases allocated and unallocated space per instance

  I need the following information: Space Allocated and unallocated space for each database, Can you…

  Narine M

  6 replies

  5 years, 6 months ago

  By: Sue_H

• OLE DB provider "SQLNCLI10" for linked server "XXX" returned message "The partner transaction manager has disabled its support for remote/network transactions.".

  Hi, I have two SQL Servers Server A and Server B. ServerA has SQL Server 2008 and ServerB has SQL S…

  garima.arya

  10 replies

  5 years, 6 months ago

  By: John D

• MSS SQL 2000 DTS Package Problem

  Hi Experts, I have one old server which runs on MS SQL 200 and using some DTS package , When I am …

  ichbinraj

  12 replies

  5 years, 7 months ago

  By: as_1234

• See the query in sp_execute

  I'm supporting an application that is big about using sp_prepare and sp_execute. I need to reverse…

  Ninja's_RGR'us

  28 replies

  5 years, 7 months ago

  By: jk.capoeira

• 'profile name is not valid' error with sp_send_dbmail

  I am currently migrating our sql2000 instance to sql2k5 on a new server. As part of this migration…

  J-Hob

  2 replies

  5 years, 8 months ago

  By: cms4j

• Cannot shrink log, simple recovery model, no open transactions, tried checkpoint, etc.

  We have a database which is just a backup/snapshot of some data. The log grew very large while loa…

  tim.steorts

  13 replies

  5 years, 8 months ago

  By: Chris

• Setting up Database mail using gmail account

  Hi,, any one any idea about this? I am trying to set up Databases mail on my laptop and I have a g…

  Achtang

  49 replies

  5 years, 9 months ago

  By: Lindsay

• Log Shipping Agent Error Message

  Hi all, I am trying to configure log shipping and getting following error in agent job history.(SQL…

  sidewing

  3 replies

  5 years, 10 months ago

  By: Leo.Miller

• Need a trigger to stop a restore with replace

  I have created a trigger to stop someone from dropping or creating a new database that works fine. …

  lmacdonald

  13 replies

  5 years, 10 months ago

  By: Hany Helmy

• Loading Data from a Linked Server - SQLNCLI errors

  I administer a local SQL Server 2005 database that was recently updated from SQL Server 2000. Ther…

  daren_sanborn

  12 replies

  5 years, 11 months ago

  By: vanu