Yes, you can add where clause in the above query:

select db_name(database_id),type_desc,physical_name from sys.master_files where type_desc = 'LOG'

What's frequency of log backup?

I guess you are loged on with your domain\yourusername and running the backup so it's giving your info in profiler. Now in schedular you are using SSA so you just...

I guess you need to change server name as you would like to execute it on new server but make sure and test it on dev or test environment before...

You need to add "Maintenance Cleanup Task" with desire retention period of Database Bakup.

HTH

Cheers

Thank you, Gila for clarification and prompt reply.

Refer link:

http://technet.microsoft.com/hi-in/library/cc917680(en-us).aspx

Thank you Gail for such a Wonderful article 🙂

A quick question:

???If database is corrept and we are taking backup.... does backup too have corruption?

???If we are restoring the database with...

however you need to creat "History clean up task" to clear history else it will there and unless and untill manually deleted it.

Also I doubt that mirroring is not in sync hence unable to truncate the data from log on production.

Make sure your mirroring is working find before taking any steps.

No terry,

Still there are lost of new features are there which DBA can target. eg. high availability like mirroring, Snapshot, service broker, clr intigrity, xml and much more etc....

I feel...

Best way to do this is use Data modeling tool like ERwin.

Alternate is creat Script for the same.

If your database is Production than after changing db back to Full recovery mode do not forget to take full backup.

can you try following code:

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

DECLARE @cmd nvarchar(2000)

SET @cmd = 'EXEC master.dbo.xp_delete_file 0,N''\\ServerName\C$\SQL Data\MSSQL.1\MSSQL\LOG\'',

N''txt'',N''' + CONVERT(nvarchar(256),Dateadd (dd, -6, getdate()), 101) + ''''EXEC (@cmd)

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

HTH

Think about the Packaging of SQL Server 2005.

It will help you to retain the standard as well as minimal knowledge.

HTH