Administering

• Topics

  Started by

  Posts

  Last post

• Error converting data type varchar to bigint

  Hi, I'm doing this query: DECLARE @TESTE BIGINT DECLARE @DB VARCHAR(100) SET @DB ='SGCTCENTRAL' SET…

  river1

  2 replies

  12 years ago

  By: Lynn Pettis

• missing .mdf and .ldf database file after hard drive crash

  Hello guru, Recently our hard drive crash and it doesn't look like we can recover the data any lon…

  hwp

  19 replies

  12 years ago

  By: SQLBlimp

• SQLSTATE 42000 error 22029 during backup transaction log

  Hi, We use sql server 2005. Our "transaction log backup" job shows us this error: "sqlmaint.exe err…

  cygne17_2 77208

  2 replies

  12 years ago

  By: free_mascot

• Page corrupted

  I'm getting following report while running DBCC DB. Is it the index that is corrupted? If so, how d…

  SQL_Surfer

  5 replies

  12 years ago

  By: Gail Shaw

• Backup TAIL LOG when the DB is OFFLINE

  Hi all, The MS article http://msdn.microsoft.com/en-us/library/ms179314.aspx states that it is poss…

  m--S3qU3L

  4 replies

  12 years ago

  By: Gail Shaw

• view all the restores made

  Hi, I need to see all the restores that were made to a database called SGCTI. The SQL server instan…

  river1

  5 replies

  12 years ago

  By: Sushant Yadav

• DATA Base mail configuration using GMAIL - Giving error

  Hi All, I was trying to do Database mail configuration from gmail. But I cant send Text mail. Its f…

  rajeshjaiswalraj

  3 replies

  12 years ago

  By: Lowell

• Import / Export data including keys and indexes

  Hallo, For some time I'm working with MS SQL 2005 and 2008. Ad the moment I'm using MS SQL 2005 man…

  harm.vanderlinde

  11 replies

  12 years ago

  By: buddy__a

• IBM CDC data replication tool

  Without getting into all of the politics of why I'm aksing this question, is there anyone out there…

  Dale Hughes-356583

  4 replies

  12 years ago

  By: phillia

• Could not continue scan with NOLOCK due to data movement.

  This is crazy ... I'm getting this error on a database that has zero activity to it, when attemptin…

  Adam Bean

  12 replies

  12 years ago

  By: Tim Roberts-250428

• "Sql server error 5120" while attaching database

  HI, I am trying to attach few databases to sql server 2005.I have my .mdf files in "D:\MSSQL\Data" …

  lays.babyblush

  26 replies

  12 years ago

  By: hessar

• TLOG Backup MaximumErrorCount Error

  My Transaction Log backup has 'MaximumErrorCount' error as below: SSIS Warning Code DTS_W_MAXIMUMER…

  irene.leung

  9 replies

  12 years ago

  By: lkennedy76

• DBCC CHECKDB - how use it in a maintenance plan ?

  hello, do you think it necessary to use DBCC CHECKDB ? how use it in sql server agent ? before back…

  yann.larvor

  33 replies

  12 years ago

  By: DavidB 36561

• reducing Database size - unused space?

  I have a DB (SQL Server 2005) Here are the result from sp_spaceused: database_namedatabase_size…

  Jpotucek

  2 replies

  12 years ago

  By: Jpotucek

• SQL Server crashing, cannot connect w/ SSMS, agent not starting

  Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmi…

  e_chow

  2 replies

  12 years ago

  By: e_chow