Actually i had already successfully restore the backup and put the database in the latest stage.

That what i did, but for overcome such a incident we have to share our knowldge here.

If you are good DBA then why not provide me solution.

I did the backup restore but i am yet in curiosity to know the alternate way.

Hi guys

I have find one link in which they mention recover data from transaction log file.

http://dbarecovery.com/backup-and-recovery-exercises/sql-server-2000-disaster-recovery-exercises/sql-server-2000-lost-primary-data-file.html

select {fn extract(hour from datetimeColumnName)} +':'+{fn extract(minute from datetimeColumnName)} ,datetimeColumnNamefrom [TableName]

But for this you need administrative privilege to drives.

select {fn extract(hour from datetimeColumnName)},datetimeColumnNamefrom [TableName]

I think there are some hidden command in sql server which Microsoft not make it public.

Can any body know the powershell command?

http://beyondrelational.com/blogs/ashish/archive/2010/08/31/ssis-file-operations-copy-file-move-file-rename-file-and-delete-file.aspx

I think i have to post support ticket to microsoft for the same.

GO

/****** Object: Table [dbo].[ProcessDocumentLog] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[ProcessDocumentLog](

[strDocumentLogId] [varchar](255) NOT NULL,

[strLogId] [varchar](255) NOT NULL,

[strDocTypeName] [varchar](255) NULL,

[strFieldCaptionName] [varchar](255) NULL,

[strFieldValue] [nvarchar](max) NULL,

[dateTimeCreated] [smalldatetime]...

Restore database is one option but we have no rights for that and also it data centre server and they charge for space

Please try to understand As per your query i have to modify query each when user added new fieldName

I have no idea about it

Can you help me out?