I did the following

1. Change the recovery model to simple

2. issue the commnad backup log <DB Name Here> with truncate_only. But this time file size not changed. FIle size is still 10 gb...

Thanks for all.

Backup and copying backup after the backup are working fine.

Mathew

Pls recheck u r logical file names 'DBName_Data'  and 'sglue_md_Log' in restore command . May be these logical files names are wrong.

I disable the anitivirus application,again it is not working.

At last I find the problem,….I find the output file the reason...

Symantec Antivirus corporate edition ver 8 antivirus  is running on my sql server and it scan a  new file that is coming on my server.

Is any way to not run...

BACKUP DATABASE [OHMIS] TO  DISK = N'F:\backup\OHMISDIFFBKP\OHMISDIFFBKP' WITH  INIT ,  NOUNLOAD ,  DIFFERENTIAL ,  NAME = N'OHMIS backup',  NOSKIP ,  STATS = 10,  NOFORMAT

Yes , My Sql Server agent use the Domain Administrator account.

After back up, with out any delay I try...

I do not have daily/weekly /monthly mantenance plan

But I am taking full DB Backup every 12 hrs and Differental Backup...

Thanks for u  r reply

Yes .. We have some performance issue in application. Some of the users complain that before...

Create a clustered index on fruit name column not store the record on the order of forename. If we issue...

Dear All,

Thanks for your suggestion and all of u r suggestion is valid.

Stave Jones can...

Dear Sir,

Thanks for your reply.. I will go for auditing in SQL Server..

Regards

Mathew