Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2005-03-07 : 10:23:27
|
| Just a quick question, What is the deifferenc between dmp files and bak files.All help appreciated. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-07 : 13:30:58
|
| How far back are you going? I seem to remember back in SQL [version] 6.5 days we used to talk about "Dumping the database" where now we say "Backup the database"is that perhaps "it" ?Kristen |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-07 : 13:53:52
|
| Basically, there is no difference. It's a naming convention. Some old-timers still use the .dmp file extension because that's what we used to use. We also use to use the DUMP DATABASE command instead of BACKUP DATABASE. You definitely shouldn't still be using that though. Microsoft keeps saying they aren't going to support it some day.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2005-03-07 : 17:36:57
|
| Thanks alot. I needed some clarification as I was telling a co-worker that they are the same. Thank you again.All help appreciated. |
|
|
|
|
|
|
DMP file vs BAK files