June 7, 2008 at 7:54 pm
hi,
I executed the following scripts in management studio one with .bak n other with .lsbak.
we are using litespped for backups.
exec master.dbo.xp_backup_database @database = 'adventureworks',
@filename = 'C:\LitespeedBackup\adventureworks.bak'
exec master.dbo.xp_backup_database @database = 'adventureworks',
@filename = 'C:\LitespeedBackup\adventureworks.lsbak'
Iam able to get the backs for these above scripts but I would like to what is the difference between these 2 extensions n when to use .bak n .lsbak
June 8, 2008 at 7:10 am
You can have any naming convention, we generally use .bak for full/diff backup and .trn for transaction log backup. You can even have the file extension similar to .deepak..it will work
backup database master to disk='F:\softwares\master.deepak'
[font="Verdana"]- Deepak[/font]
June 8, 2008 at 11:41 pm
1) If you use .BAK extension, you can configure Database Maintenance Plan to delete older backup files.
2) File name extension should not affect the file content. The parameters will determin the content. For example: @BackupType = 'Full|Differential|Log'.
3) Refer the third party software (Litespeed) documentation.
4) If you use different backup softwares, it is better to use different extensions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply