YES, but from april to july, where will we find data?

hoe can we restore it? we do not have information to restore the data

nop, the clients most recent backup if from April.....

What do you mean by clean backup? it's a backup with no data inside?

It worked, the database is now in emergency mode, but when i try to put it on single user mode or see it's tables i always receive the same error:

Msg...

thank you for reply again paul.

I can't put the database in emergency mode...

How can i put the database in emergency mode in SQL Server 2000?

Sorry, the first one was no complete i didn't knowed how to delete it.

yes, there is , i am running this command from a VB application (nor in query window).

I have achieved this goal yesterday.

Thank you for the reply.

hum.... didn't undestood your answer 🙂

i have made what you say like:

USE [SecurDB]

GO

/****** Object: StoredProcedure [dbo].[DBCCCheckDB] Script Date: 07/06/2010 15:40:18 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure...

i'm having problems with this command:

declare @FileNameOut as varchar(250)

declare @cmd as varchar(8000)

set @FileNameOut ='c:\OutputConsistencia_'+@DB+'.txt'

select @cmd = 'osql -U'+@user+' -P'+@pass+' -S -Q"dbcc checkdb ('''+@db+''') with no_infomsgs" -o"'+@FileNameOut+'" -w500'

Exec master..xp_cmdshell @cmd

When i...

Ok, no problem, and thank you for your reply.

i'm not choore that it does not return any messages if the database as errors, what i think (but not choore) is that this command does not print results to...

Thank you for reply lowel.

I say:

dbcc checkdb (SandBox) with no_infomsgs does not return any results....so why bother capturing the results in a text file in the first place? maybe it...

perfect solution Steve , thank you

Thank you for reply GAIL.

you sugest this?:

select * from master.sys.databases

where [state_desc] <> 'online'

Question:

If a database is suspect what will be is state_desc?

If a database is in read_only what will be...