Hi Lays,

How did u copy the log from D:\ to E:\ as mentioned.

this way i could attach it but then i took the db offline copied the log from...

Its just an example thats it.

It looks like this...

The query to be tunned is like this to

select * from test.samp_id,test.b_id,

case when (test.case_active='N' and sample.case_te_date is null)

then 'In Active' when (not tbl_test.case_te_date is null)

then 'Marked for Del'...

Hi cath,

I am able to see history of other jobs,but i am not able to see history of backup jobs.The job has ran fine i have crosschecked.

Any other idea?

Check if log files are taking more space and shrink only once dont do shrink every time it causes fragmentation.

If log files are taking more space,schedule frequent log backups and...

Thanks cath.

I will monitor and will tell u.

Cath,

Log file size was 5.62 gb.

I took transaction log backup twice but still the size is same when i crosscheck the size is still the same as 5.62 gb.

I think...

xp_msvr will run on any dbs.

Hey create this procedure in msdb db and exec as

EXEC usp_job_history '10/02/2004'

------------------

CREATE PROCEDURE usp_job_history

@dateparam DATETIME

AS

SELECT dbo.sysjobhistory.server, dbo.sysjobs.name AS job_name,

CASE dbo.sysjobhistory.run_status

WHEN 0 THEN 'Failed'

WHEN 1...

USe

SELECT @@VERSION AS 'SQL Server Version'

and

xp_msver

it returns information about the actual build number of the server and information about the server environment.

Thanks

Data size is 8 gb and log size is 14 gb.

i checked through profiler lot of transaction are going on.

So during weekend the log file size reaches 20 gb

Suresh,

Once we shrink it will reduce,but after some hours log file size increases about more than 2gb.Thats the issue.

I am shrinking daily.Wats the solution.

In sql server 2005 we can do this.

backup log db to disk=' '

DBCC SHRINKFILE (db,800) WITH NO_INFOMSGS

I did like this it worked.Try this.

can i user database maintenance plan for only deleting old backup files in sql server 2005

pls help

hi MD,

can u pls help me on this.......

atleast do u know the batch code to delete the old .txt or .doc files so i can alter that

i want to delete...