For reporting purpose, but all connection are suspended stauts, ather application getting time out issue web page,

Thanks

Thank you for information...

No issue.If I connect mangement studio through another server all job are good. But i connected through local server , jobs steps are not available. I think Sql server 2005...

Hi,

Its works. Great

Thanks lot....

I will check it. just i wil use this one - DBCC opentran()

Could you give any example for encrypt & decrypt two column in a table ( ssn int, b_date datetime)

i'm going to implement in production server..

Thanks

Thank you.. not enough memory to run the backup..

i wil change to os memory settings.

I ran the Dbcc chekcdb .. getting no errors..

sql server 2000 version

thanks,

How to resolve this issue in main production server..

I could not find the soultion . .please give me solution the resolve the problem

sysadmin found the error , the drive affected in bad stripe problem in raid drive.

Thanks you so much .. for your support..

Database status is normal. I gettting error while backup"

" Nonrecoverable I/O error occurred 'E:\data\MSSQL\prod_up.mdf'. backup failed."

Any bad stripe in hard disk..

No luck . i tried to another drive to backup database. same error ' noreoverable i/o error occurred'

database size : 12 GB

I has lots free space there : more than 85 GB

i have queried table and databse is online status.. what is the problem..

i...

my problem dont have old backup so i take up new backup , but i could not take backup .got error" non recoverable i/o error occured' yester also database went...