josebrwn (4/19/2010)

---

I'm trying to figure out a failed "history cleanup task" - this is just the standard maintenance plan task. The Server Agent user has sysadmin, and when I...

Read the below URL's

http://www.sqlskills.com/blogs/paul/post/Example-20002005-corrupt-databases-and-some-more-info-on-backup-restore-page-checksums-and-IO-errors.aspx

http://www.sqlservercentral.com/articles/Corruption/65804/

Krishnraj (4/16/2010)

---

Hi All,

Today my database suddenly went to suspect mode and i recover it normal mode by using below query.

EXEC sp_resetstatus 'databaseName';

ALTER DATABASE databaseName SET EMERGENCY

DBCC checkdb('databaseName')

ALTER DATABASE databaseName...

Ur welcome....:-)

K. Hari Das (4/16/2010)

---

I just wonder where I can find the backed up files for my database when I run the following command:

USE DatabaseName

GO

DBCC SHRINKFILE(<TransactionLogName>, 1)

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

DBCC...

dba-vb (4/14/2010)

---

hi to all,

Can anyone give the sp fine tuning steps/guidelines, how can i optimize the sp?

if a sp is taking log time to execute how can check why...

syedyaserahmed (4/15/2010)

---

Hi Friends,

Im having a strange problem with SSMS, i have two CD's for SQl Server2005 standard edition.

when i installed i got all other components and tools but there was...

Barkingdog (4/15/2010)

---

We have a table with an index on column "A". We encountered a perfomance issue and the Database Tuning Advisor recommended we create a new index

on Column...

Question was not clear.

durai nagarajan (4/9/2010)

---

Hi,

Server is on windows 2003 SP2 and SQL 2005 sp2 suddenly not showing green icon near server name , neither on sql agent also. i coudnt get option...

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx

Ananda-292708 (4/9/2010)

---

Is there a set of questions which i can ask customers to fill so that it will help me selecting the sql server 2008 edition for their requirements.

I got...

How long the update is...

rpatil22 (4/9/2010)

---

Are the followings indexes are correct for rows 110k?

Table contain following Columns

employeeId - uniqueindentifier ( primary key )

machine - nvarchar(100)

firstname - nvarchar(100)

lastname - nvarchar(100)

startdate - datetime

finishdate - datetime

location...

SELECT

DATABASE_NAME,[TYPE],BACKUP_FINISH_DATE,

(BACKUP_SIZE/1024/1024) SIZE_MB,PHYSICAL_DEVICE_NAME,

[USER_NAME]

FROM MSDB.DBO.BACKUPSET A JOIN MSDB.DBO.BACKUPMEDIAFAMILY B

ON(A.MEDIA_SET_ID=B.MEDIA_SET_ID)...