thanks..

ya i tried ..its like old only

i need "last backup database details"

can please give query to retrieve the data

please help

thanxs

Thanks bru

can u explain briefly how to do with examples ..please

ok thanx

i am checking profiler only now

thanx Reischl

today only i started profiler against that server

now i am capturing full day process

not working means ---application page is coming unavailable

now i need to trace the time...

please check this

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[test](

[id] [int] NULL,

[date] [datetime] NULL

) ON [PRIMARY]

insert into test

select 1,'2009-01-01' union all

select 1,'2009-05-01' union all

select 2,'2009-04-01' union all

select 2,'2009-01-01' union...

hi this is not solved .. problem is coming for varchar,nvarchar,char data type ..please give solution

thanx

please can u give the vb script

i will try with the vb script

hi Swarndeep

thanks..

today i changed the datatype to text ..but no use

i am using dts normal paclage

thank u Jeffrey

same think what u told.. we are running maintenance plan in sunday 6.30 Am ..

Differential backups are cumulative - in other words, they contain all of...

thanks kumar

i checked every think ..

we remove the mapped network drive and re-mapped the drive ..still problem is continuing

hi sakthi

J:\ is mapped network drive

only 3.am backup is failling.......

we are using domain administrator login for all service...

i tried for iexplore.exe right click for run as ..its not...

thanks john

please tell how to take tail log backup and how to restore tail log

please give syntax with example