September 2, 2010 at 7:36 am
We make in our company some times differential backups. The default file extension in the maintenance plan wizard is for this type of backup .BAK. So my question is: Is there any industrial standard about the extension for differential backups like e.g. .dbk or what ever?
September 2, 2010 at 7:52 am
There is no standard I'm aware. Just use whatever makes sense to you and make sure you stick to that naming convention.
In my case I've always used .bak and I just use <full_dbname_datetimestamp>.bak or <diff_dbname_datetimestamp>bak as a naming convention.
September 3, 2010 at 7:32 am
There's no standard. In fact, I'd probably just leave the extension as is and rename the file as the other poster did.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 13, 2013 at 2:32 pm
Typically:
.dif = differential backup
.fil = filegroup backup
.trn = tranlog backup
as most people follow MS's lead, as they did with .bak, .mdf, .ndf (silly, imo, why not .mdf also???), etc..
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply