quote:

---

Originally posted by sunsanvin

Dear All,
in our organization only full backups are running daily.

after a full backup, all the data in the log file will free up to the data file? or still the data will be there in the log file?

No,Full backup doesn't free up inactive portion of log. Only Log backup frees up.

i've a BIG doubt that how to check which type of backups are running in my server? will a job run automatically for this after selecting a maintenance plan?

Use this to Check your backups. Put databasename:

declare @databasename as varchar(100)



set @databasename = 'yourdatabasename'



Select database_name + rtrim(case when type ='L' then space(5)+ name

when type ='D' then space(1)+name

when type ='I' then space(3)+name else '' end)+ space(3)+

convert(varchar, Backup_Start_date, 121)

from msdb..backupset

where database_name = @databasename

and Backup_Start_Date >= (select max(Backup_Start_Date)

from msdb..backupset

where database_name = @databasename

and type = 'D')

order by Backup_Start_date

Arnav
Even you learn 1%, Learn it with 100% confidence.

---